Hi all,

I was post this problem more then one time but without any luck. I?m
desperate. So if you guys can help me with this.

I have main form where user create Order. Each order have only one Estimated
cost Received from Suppliers. But Suppliers can send more invoice amount for
that Order. So I create Continues Subform (Invoice Order)In Subform I have 5
field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
Now in Main form I create Order (OrderID = 14) and Estimated Cost for this
Order is 5000 $.
In Subform :
InvOrderID	OrderID		InvoiceCost		Discaunt	Inv.Date
1		14			2500$			0%		12/11/2002
2		14			1000$			0%		18/12/2002
So total of invoice Cost for OrderID 14 is 3500 $.
And I have Accrual Report. Accrual report show list of open Orders( orders
with difference between Estemeted cost ? TotalInvoice Cost).So in report by
above example:
OrderID 	OpenCost
14		1500$ (5000$ - 3500$)

Now my problem. Because Estimated cost is not guarantied cost from supplier,
difference between
Estimated cost and TotalInvoice cots in 95% of orders will never be 0.00$.So
I was thinking to create Check box (Last Invoice of Order).So when user
receive last invoice for order hi gonna select check box and this order will
not show anymore in Report.
Enzo suggest to create List Box instead Subform but this is out of my
leage(I dont know to make setup with list box and how is posible to add  or
edit record in list box)

So guys please help me with any solution, idea advice!!!

Thanks

Hello Nikola

If I understand you correctly, this is what you do.

Go ahead and create your checkbox.  Then create a field in your orders table
which will contain the value of the checkbox. (Checkboxes have a different
value when they are ticked and when they are not ticked.)
Your report will, I assume, be based on a query on the orders table.  Open
the query in design view, insert the field which contains the checkbox
value, then set the criteria for that field to the value of the checkbox
when it is ticked.  The query will then filter out any orders which fit this
criteria and they wont appear on your report.

If your report is based directly on the table itself, you will need to
create a query as above and change your reports data property to that.

Hope this helps

Regards, Wesley Kendrick

----- Original Message -----
From: "Nikola" <Nikola@b...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 1:04 AM
Subject: [access] Realy need Help


> Hi all,
>
> I was post this problem more then one time but without any luck. I'm
> desperate. So if you guys can help me with this.
>
> I have main form where user create Order. Each order have only one
Estimated
> cost Received from Suppliers. But Suppliers can send more invoice amount
for
> that Order. So I create Continues Subform (Invoice Order)In Subform I have
5
> field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> Now in Main form I create Order (OrderID = 14) and Estimated Cost for this
> Order is 5000 $.
> In Subform :
> InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> 1 14 2500$ 0% 12/11/2002
> 2 14 1000$ 0% 18/12/2002
> So total of invoice Cost for OrderID 14 is 3500 $.
> And I have Accrual Report. Accrual report show list of open Orders( orders
> with difference between Estemeted cost - TotalInvoice Cost).So in report
by
> above example:
> OrderID OpenCost
> 14 1500$ (5000$ - 3500$)
>
> Now my problem. Because Estimated cost is not guarantied cost from
supplier,
> difference between
> Estimated cost and TotalInvoice cots in 95% of orders will never be
0.00$.So
> I was thinking to create Check box (Last Invoice of Order).So when user
> receive last invoice for order hi gonna select check box and this order
will
> not show anymore in Report.
> Enzo suggest to create List Box instead Subform but this is out of my
> leage(I dont know to make setup with list box and how is posible to add
or
> edit record in list box)
>
> So guys please help me with any solution, idea advice!!!
>
> Thanks
>
>
>

Hi Wesley,
My problem is that subform is continues form so if I have more then 1
invoice record in subform,
check box will show in each record.Is possible to have visible check box
only on last records or on new records? So if i enter one record in subform
check box will be visible but if I enter another record ,check box on old
one will be disenable or invisible.
Thanks for help even if you ignore this post!

-----Original Message-----
From: Wesley Kendrick [mailto:wez.k@n...]
Sent: Friday, December 20, 2002 10:32 AM
To: Access
Subject: [access] Re: Realy need Help


Hello Nikola

If I understand you correctly, this is what you do.

Go ahead and create your checkbox.  Then create a field in your orders table
which will contain the value of the checkbox. (Checkboxes have a different
value when they are ticked and when they are not ticked.)
Your report will, I assume, be based on a query on the orders table.  Open
the query in design view, insert the field which contains the checkbox
value, then set the criteria for that field to the value of the checkbox
when it is ticked.  The query will then filter out any orders which fit this
criteria and they wont appear on your report.

If your report is based directly on the table itself, you will need to
create a query as above and change your reports data property to that.

Hope this helps

Regards, Wesley Kendrick

----- Original Message -----
From: "Nikola" <Nikola@b...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 1:04 AM
Subject: [access] Realy need Help


> Hi all,
>
> I was post this problem more then one time but without any luck. I'm
> desperate. So if you guys can help me with this.
>
> I have main form where user create Order. Each order have only one
Estimated
> cost Received from Suppliers. But Suppliers can send more invoice amount
for
> that Order. So I create Continues Subform (Invoice Order)In Subform I have
5
> field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> Now in Main form I create Order (OrderID = 14) and Estimated Cost for this
> Order is 5000 $.
> In Subform :
> InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> 1 14 2500$ 0% 12/11/2002
> 2 14 1000$ 0% 18/12/2002
> So total of invoice Cost for OrderID 14 is 3500 $.
> And I have Accrual Report. Accrual report show list of open Orders( orders
> with difference between Estemeted cost - TotalInvoice Cost).So in report
by
> above example:
> OrderID OpenCost
> 14 1500$ (5000$ - 3500$)
>
> Now my problem. Because Estimated cost is not guarantied cost from
supplier,
> difference between
> Estimated cost and TotalInvoice cots in 95% of orders will never be
0.00$.So
> I was thinking to create Check box (Last Invoice of Order).So when user
> receive last invoice for order hi gonna select check box and this order
will
> not show anymore in Report.
> Enzo suggest to create List Box instead Subform but this is out of my
> leage(I dont know to make setup with list box and how is posible to add
or
> edit record in list box)
>
> So guys please help me with any solution, idea advice!!!
>
> Thanks
>
>
>

Hello Nikola

The checkbox will have a Visible property (in the Format page) and an
Enabled property (in the Data page)
If you set the Visible property to False, the checkbox will disappear (set
to True to make it appear).
If you set the Enabled property to False the checkbox will still be there
but it will turn grey and you can not use it. (set to True to make it
enabled again).

These properties can be set in VB like this:

YourForm!YourCheckbox.Visible = False
or
YourForm!YourCheckbox.Enabled = False

Regards, Wesley Kendrick

----- Original Message -----
From: "Nikola" <Nikola@b...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 1:40 PM
Subject: [access] Re: Realy need Help


> Hi Wesley,
> My problem is that subform is continues form so if I have more then 1
> invoice record in subform,
> check box will show in each record.Is possible to have visible check box
> only on last records or on new records? So if i enter one record in
subform
> check box will be visible but if I enter another record ,check box on old
> one will be disenable or invisible.
> Thanks for help even if you ignore this post!
>
> -----Original Message-----
> From: Wesley Kendrick [mailto:wez.k@n...]
> Sent: Friday, December 20, 2002 10:32 AM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Hello Nikola
>
> If I understand you correctly, this is what you do.
>
> Go ahead and create your checkbox.  Then create a field in your orders
table
> which will contain the value of the checkbox. (Checkboxes have a different
> value when they are ticked and when they are not ticked.)
> Your report will, I assume, be based on a query on the orders table.  Open
> the query in design view, insert the field which contains the checkbox
> value, then set the criteria for that field to the value of the checkbox
> when it is ticked.  The query will then filter out any orders which fit
this
> criteria and they wont appear on your report.
>
> If your report is based directly on the table itself, you will need to
> create a query as above and change your reports data property to that.
>
> Hope this helps
>
> Regards, Wesley Kendrick
>
> ----- Original Message -----
> From: "Nikola" <Nikola@b...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 1:04 AM
> Subject: [access] Realy need Help
>
>
> > Hi all,
> >
> > I was post this problem more then one time but without any luck. I'm
> > desperate. So if you guys can help me with this.
> >
> > I have main form where user create Order. Each order have only one
> Estimated
> > cost Received from Suppliers. But Suppliers can send more invoice amount
> for
> > that Order. So I create Continues Subform (Invoice Order)In Subform I
have
> 5
> > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > Now in Main form I create Order (OrderID = 14) and Estimated Cost for
this
> > Order is 5000 $.
> > In Subform :
> > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > 1 14 2500$ 0% 12/11/2002
> > 2 14 1000$ 0% 18/12/2002
> > So total of invoice Cost for OrderID 14 is 3500 $.
> > And I have Accrual Report. Accrual report show list of open Orders(
orders
> > with difference between Estemeted cost - TotalInvoice Cost).So in report
> by
> > above example:
> > OrderID OpenCost
> > 14 1500$ (5000$ - 3500$)
> >
> > Now my problem. Because Estimated cost is not guarantied cost from
> supplier,
> > difference between
> > Estimated cost and TotalInvoice cots in 95% of orders will never be
> 0.00$.So
> > I was thinking to create Check box (Last Invoice of Order).So when user
> > receive last invoice for order hi gonna select check box and this order
> will
> > not show anymore in Report.
> > Enzo suggest to create List Box instead Subform but this is out of my
> > leage(I dont know to make setup with list box and how is posible to add
> or
> > edit record in list box)
> >
> > So guys please help me with any solution, idea advice!!!
> >
> > Thanks
> >
> >
> >
>
>
>
>
>

Thank you very mach.I will try tonight.
Nikola
Sorry but what is Format and Data page?
----- Original Message -----
From: "Wesley Kendrick" <wez.k@n...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 5:08 PM
Subject: [access] Re: Realy need Help


> Hello Nikola
>
> The checkbox will have a Visible property (in the Format page) and an
> Enabled property (in the Data page)
> If you set the Visible property to False, the checkbox will disappear (set
> to True to make it appear).
> If you set the Enabled property to False the checkbox will still be there
> but it will turn grey and you can not use it. (set to True to make it
> enabled again).
>
> These properties can be set in VB like this:
>
> YourForm!YourCheckbox.Visible = False
> or
> YourForm!YourCheckbox.Enabled = False
>
> Regards, Wesley Kendrick
>
> ----- Original Message -----
> From: "Nikola" <Nikola@b...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 1:40 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hi Wesley,
> > My problem is that subform is continues form so if I have more then 1
> > invoice record in subform,
> > check box will show in each record.Is possible to have visible check box
> > only on last records or on new records? So if i enter one record in
> subform
> > check box will be visible but if I enter another record ,check box on
old
> > one will be disenable or invisible.
> > Thanks for help even if you ignore this post!
> >
> > -----Original Message-----
> > From: Wesley Kendrick [mailto:wez.k@n...]
> > Sent: Friday, December 20, 2002 10:32 AM
> > To: Access
> > Subject: [access] Re: Realy need Help
> >
> >
> > Hello Nikola
> >
> > If I understand you correctly, this is what you do.
> >
> > Go ahead and create your checkbox.  Then create a field in your orders
> table
> > which will contain the value of the checkbox. (Checkboxes have a
different
> > value when they are ticked and when they are not ticked.)
> > Your report will, I assume, be based on a query on the orders table.
Open
> > the query in design view, insert the field which contains the checkbox
> > value, then set the criteria for that field to the value of the checkbox
> > when it is ticked.  The query will then filter out any orders which fit
> this
> > criteria and they wont appear on your report.
> >
> > If your report is based directly on the table itself, you will need to
> > create a query as above and change your reports data property to that.
> >
> > Hope this helps
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:04 AM
> > Subject: [access] Realy need Help
> >
> >
> > > Hi all,
> > >
> > > I was post this problem more then one time but without any luck. I'm
> > > desperate. So if you guys can help me with this.
> > >
> > > I have main form where user create Order. Each order have only one
> > Estimated
> > > cost Received from Suppliers. But Suppliers can send more invoice
amount
> > for
> > > that Order. So I create Continues Subform (Invoice Order)In Subform I
> have
> > 5
> > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > Now in Main form I create Order (OrderID = 14) and Estimated Cost for
> this
> > > Order is 5000 $.
> > > In Subform :
> > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > 1 14 2500$ 0% 12/11/2002
> > > 2 14 1000$ 0% 18/12/2002
> > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > And I have Accrual Report. Accrual report show list of open Orders(
> orders
> > > with difference between Estemeted cost - TotalInvoice Cost).So in
report
> > by
> > > above example:
> > > OrderID OpenCost
> > > 14 1500$ (5000$ - 3500$)
> > >
> > > Now my problem. Because Estimated cost is not guarantied cost from
> > supplier,
> > > difference between
> > > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > 0.00$.So
> > > I was thinking to create Check box (Last Invoice of Order).So when
user
> > > receive last invoice for order hi gonna select check box and this
order
> > will
> > > not show anymore in Report.
> > > Enzo suggest to create List Box instead Subform but this is out of my
> > > leage(I dont know to make setup with list box and how is posible to
add
> > or
> > > edit record in list box)
> > >
> > > So guys please help me with any solution, idea advice!!!
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
>
>

I think you might be able to add a field to your Order table, a field with
BOOLEAN data type (Yes/No), that will store the 'yes' or 'no' from the
checkbox.  Name it something like "Order_Complete".  When you create a new
order record, set it to NO (which is the same as zero, or FALSE).  Place
this field on your form as a checkbox as you would any other field, so that
it updates back to the record.  When the user clicks it, the field is set to
TRUE.  Now, in your report, modify the data source, or where clause, or
filter (however you are structured) to include "Orders.Order_Complete 
FALSE" (of course, using the field names appropriate for your real project)

Good Luck!
David

-----Original Message-----
From: Nikola [mailto:Nikola@b...]
Sent: Thursday, December 19, 2002 7:04 PM
To: Access
Subject: [access] Realy need Help


Hi all,

I was post this problem more then one time but without any luck. I'm
desperate. So if you guys can help me with this.

I have main form where user create Order. Each order have only one Estimated
cost Received from Suppliers. But Suppliers can send more invoice amount for
that Order. So I create Continues Subform (Invoice Order)In Subform I have 5
field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
Now in Main form I create Order (OrderID = 14) and Estimated Cost for this
Order is 5000 $.
In Subform :
InvOrderID	OrderID		InvoiceCost		Discaunt
Inv.Date
1		14			2500$			0%
12/11/2002
2		14			1000$			0%
18/12/2002
So total of invoice Cost for OrderID 14 is 3500 $.
And I have Accrual Report. Accrual report show list of open Orders( orders
with difference between Estemeted cost - TotalInvoice Cost).So in report by
above example:
OrderID 	OpenCost
14		1500$ (5000$ - 3500$)

Now my problem. Because Estimated cost is not guarantied cost from supplier,
difference between
Estimated cost and TotalInvoice cots in 95% of orders will never be 0.00$.So
I was thinking to create Check box (Last Invoice of Order).So when user
receive last invoice for order hi gonna select check box and this order will
not show anymore in Report.
Enzo suggest to create List Box instead Subform but this is out of my
leage(I dont know to make setup with list box and how is posible to add  or
edit record in list box)

So guys please help me with any solution, idea advice!!!

Thanks

Hi Nikola

These are pages on the checkbox's Property Sheet - to open this, open your
form in design mode, then select the checkbox, then you wil find on the
toolbar a button which looks like a hand holding a sheet of paper - that's
the Properties button. Press it and the Property Sheet will open.

Wesley

----- Original Message -----
From: "Nikola" <nikola@b...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 3:20 PM
Subject: [access] Re: Realy need Help


> Thank you very mach.I will try tonight.
> Nikola
> Sorry but what is Format and Data page?
> ----- Original Message -----
> From: "Wesley Kendrick" <wez.k@n...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 5:08 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hello Nikola
> >
> > The checkbox will have a Visible property (in the Format page) and an
> > Enabled property (in the Data page)
> > If you set the Visible property to False, the checkbox will disappear
(set
> > to True to make it appear).
> > If you set the Enabled property to False the checkbox will still be
there
> > but it will turn grey and you can not use it. (set to True to make it
> > enabled again).
> >
> > These properties can be set in VB like this:
> >
> > YourForm!YourCheckbox.Visible = False
> > or
> > YourForm!YourCheckbox.Enabled = False
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:40 PM
> > Subject: [access] Re: Realy need Help
> >
> >
> > > Hi Wesley,
> > > My problem is that subform is continues form so if I have more then 1
> > > invoice record in subform,
> > > check box will show in each record.Is possible to have visible check
box
> > > only on last records or on new records? So if i enter one record in
> > subform
> > > check box will be visible but if I enter another record ,check box on
> old
> > > one will be disenable or invisible.
> > > Thanks for help even if you ignore this post!
> > >
> > > -----Original Message-----
> > > From: Wesley Kendrick [mailto:wez.k@n...]
> > > Sent: Friday, December 20, 2002 10:32 AM
> > > To: Access
> > > Subject: [access] Re: Realy need Help
> > >
> > >
> > > Hello Nikola
> > >
> > > If I understand you correctly, this is what you do.
> > >
> > > Go ahead and create your checkbox.  Then create a field in your orders
> > table
> > > which will contain the value of the checkbox. (Checkboxes have a
> different
> > > value when they are ticked and when they are not ticked.)
> > > Your report will, I assume, be based on a query on the orders table.
> Open
> > > the query in design view, insert the field which contains the checkbox
> > > value, then set the criteria for that field to the value of the
checkbox
> > > when it is ticked.  The query will then filter out any orders which
fit
> > this
> > > criteria and they wont appear on your report.
> > >
> > > If your report is based directly on the table itself, you will need to
> > > create a query as above and change your reports data property to that.
> > >
> > > Hope this helps
> > >
> > > Regards, Wesley Kendrick
> > >
> > > ----- Original Message -----
> > > From: "Nikola" <Nikola@b...>
> > > To: "Access" <access@p...>
> > > Sent: Friday, December 20, 2002 1:04 AM
> > > Subject: [access] Realy need Help
> > >
> > >
> > > > Hi all,
> > > >
> > > > I was post this problem more then one time but without any luck. I'm
> > > > desperate. So if you guys can help me with this.
> > > >
> > > > I have main form where user create Order. Each order have only one
> > > Estimated
> > > > cost Received from Suppliers. But Suppliers can send more invoice
> amount
> > > for
> > > > that Order. So I create Continues Subform (Invoice Order)In Subform
I
> > have
> > > 5
> > > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > > Now in Main form I create Order (OrderID = 14) and Estimated Cost
for
> > this
> > > > Order is 5000 $.
> > > > In Subform :
> > > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > > 1 14 2500$ 0% 12/11/2002
> > > > 2 14 1000$ 0% 18/12/2002
> > > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > > And I have Accrual Report. Accrual report show list of open Orders(
> > orders
> > > > with difference between Estemeted cost - TotalInvoice Cost).So in
> report
> > > by
> > > > above example:
> > > > OrderID OpenCost
> > > > 14 1500$ (5000$ - 3500$)
> > > >
> > > > Now my problem. Because Estimated cost is not guarantied cost from
> > > supplier,
> > > > difference between
> > > > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > > 0.00$.So
> > > > I was thinking to create Check box (Last Invoice of Order).So when
> user
> > > > receive last invoice for order hi gonna select check box and this
> order
> > > will
> > > > not show anymore in Report.
> > > > Enzo suggest to create List Box instead Subform but this is out of
my
> > > > leage(I dont know to make setup with list box and how is posible to
> add
> > > or
> > > > edit record in list box)
> > > >
> > > > So guys please help me with any solution, idea advice!!!
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>

Don't put the checkbox on the subform, put it on the parent form

-----Original Message-----
From: Nikola [mailto:nikola@b...]
Sent: Friday, December 20, 2002 9:21 AM
To: Access
Subject: [access] Re: Realy need Help


Thank you very mach.I will try tonight.
Nikola
Sorry but what is Format and Data page?
----- Original Message -----
From: "Wesley Kendrick" <wez.k@n...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 5:08 PM
Subject: [access] Re: Realy need Help


> Hello Nikola
>
> The checkbox will have a Visible property (in the Format page) and an
> Enabled property (in the Data page)
> If you set the Visible property to False, the checkbox will disappear (set
> to True to make it appear).
> If you set the Enabled property to False the checkbox will still be there
> but it will turn grey and you can not use it. (set to True to make it
> enabled again).
>
> These properties can be set in VB like this:
>
> YourForm!YourCheckbox.Visible = False
> or
> YourForm!YourCheckbox.Enabled = False
>
> Regards, Wesley Kendrick
>
> ----- Original Message -----
> From: "Nikola" <Nikola@b...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 1:40 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hi Wesley,
> > My problem is that subform is continues form so if I have more then 1
> > invoice record in subform,
> > check box will show in each record.Is possible to have visible check box
> > only on last records or on new records? So if i enter one record in
> subform
> > check box will be visible but if I enter another record ,check box on
old
> > one will be disenable or invisible.
> > Thanks for help even if you ignore this post!
> >
> > -----Original Message-----
> > From: Wesley Kendrick [mailto:wez.k@n...]
> > Sent: Friday, December 20, 2002 10:32 AM
> > To: Access
> > Subject: [access] Re: Realy need Help
> >
> >
> > Hello Nikola
> >
> > If I understand you correctly, this is what you do.
> >
> > Go ahead and create your checkbox.  Then create a field in your orders
> table
> > which will contain the value of the checkbox. (Checkboxes have a
different
> > value when they are ticked and when they are not ticked.)
> > Your report will, I assume, be based on a query on the orders table.
Open
> > the query in design view, insert the field which contains the checkbox
> > value, then set the criteria for that field to the value of the checkbox
> > when it is ticked.  The query will then filter out any orders which fit
> this
> > criteria and they wont appear on your report.
> >
> > If your report is based directly on the table itself, you will need to
> > create a query as above and change your reports data property to that.
> >
> > Hope this helps
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:04 AM
> > Subject: [access] Realy need Help
> >
> >
> > > Hi all,
> > >
> > > I was post this problem more then one time but without any luck. I'm
> > > desperate. So if you guys can help me with this.
> > >
> > > I have main form where user create Order. Each order have only one
> > Estimated
> > > cost Received from Suppliers. But Suppliers can send more invoice
amount
> > for
> > > that Order. So I create Continues Subform (Invoice Order)In Subform I
> have
> > 5
> > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > Now in Main form I create Order (OrderID = 14) and Estimated Cost for
> this
> > > Order is 5000 $.
> > > In Subform :
> > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > 1 14 2500$ 0% 12/11/2002
> > > 2 14 1000$ 0% 18/12/2002
> > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > And I have Accrual Report. Accrual report show list of open Orders(
> orders
> > > with difference between Estemeted cost - TotalInvoice Cost).So in
report
> > by
> > > above example:
> > > OrderID OpenCost
> > > 14 1500$ (5000$ - 3500$)
> > >
> > > Now my problem. Because Estimated cost is not guarantied cost from
> > supplier,
> > > difference between
> > > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > 0.00$.So
> > > I was thinking to create Check box (Last Invoice of Order).So when
user
> > > receive last invoice for order hi gonna select check box and this
order
> > will
> > > not show anymore in Report.
> > > Enzo suggest to create List Box instead Subform but this is out of my
> > > leage(I dont know to make setup with list box and how is posible to
add
> > or
> > > edit record in list box)
> > >
> > > So guys please help me with any solution, idea advice!!!
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
>
>

Nicola,

I have been following you problem for quit some time. This is what I 
have cooked up for you.

1.  create a field in you order master table as Last_invoice (Boolean).
2.  Put a check box in you order main for and bound it to the above 
field.
3.  In report underling query. put the criteria as last_invoice=3Dfalse.

Inform your users that once they receive the last invoice for an order. 
click the check box last_invoice.

Hope this solves your problem


rgds
Khyamuddin Basheer
APL-Jeddah
Saudi Arabia
Tel  00966-2-6697397 Ext 32
Fax 00966-2-6673212

-----Original Message-----
From: Nikola [mailto:Nikola@b...]
Sent: Thursday, December 19, 2002 5:04 PM
To: Access
Subject: [access] Realy need Help


Hi all,

I was post this problem more then one time but without any luck. I'm
desperate. So if you guys can help me with this.

I have main form where user create Order. Each order have only one 
Estimated
cost Received from Suppliers. But Suppliers can send more invoice amount 
for
that Order. So I create Continues Subform (Invoice Order)In Subform I 
have 5
field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
Now in Main form I create Order (OrderID =3D 14) and Estimated Cost for 
this
Order is 5000 $.
In Subform :
InvOrderID	OrderID		InvoiceCost		Discaunt	Inv.Date
1		14			2500$			0%		12/11/2002
2		14			1000$			0%		18/12/2002
So total of invoice Cost for OrderID 14 is 3500 $.
And I have Accrual Report. Accrual report show list of open Orders( 
orders
with difference between Estemeted cost - TotalInvoice Cost).So in report 
by
above example:
OrderID 	OpenCost
14		1500$ (5000$ - 3500$)

Now my problem. Because Estimated cost is not guarantied cost from 
supplier,
difference between
Estimated cost and TotalInvoice cots in 95% of orders will never be 
0.00$.So
I was thinking to create Check box (Last Invoice of Order).So when user
receive last invoice for order hi gonna select check box and this order 
will
not show anymore in Report.
Enzo suggest to create List Box instead Subform but this is out of my
leage(I dont know to make setup with list box and how is posible to add  
or
edit record in list box)

So guys please help me with any solution, idea advice!!!

Thanks

Hi, I can not solw this problem
in attachment is print screeen of my Order form with InvOrder Subform

Thanks

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Friday, December 20, 2002 3:34 PM
To: Access
Subject: [access] Re: Realy need Help


Don't put the checkbox on the subform, put it on the parent form

-----Original Message-----
From: Nikola [mailto:nikola@b...]
Sent: Friday, December 20, 2002 9:21 AM
To: Access
Subject: [access] Re: Realy need Help


Thank you very mach.I will try tonight.
Nikola
Sorry but what is Format and Data page?
----- Original Message -----
From: "Wesley Kendrick" <wez.k@n...>
To: "Access" <access@p...>
Sent: Friday, December 20, 2002 5:08 PM
Subject: [access] Re: Realy need Help


> Hello Nikola
>
> The checkbox will have a Visible property (in the Format page) and an
> Enabled property (in the Data page)
> If you set the Visible property to False, the checkbox will disappear (set
> to True to make it appear).
> If you set the Enabled property to False the checkbox will still be there
> but it will turn grey and you can not use it. (set to True to make it
> enabled again).
>
> These properties can be set in VB like this:
>
> YourForm!YourCheckbox.Visible = False
> or
> YourForm!YourCheckbox.Enabled = False
>
> Regards, Wesley Kendrick
>
> ----- Original Message -----
> From: "Nikola" <Nikola@b...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 1:40 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hi Wesley,
> > My problem is that subform is continues form so if I have more then 1
> > invoice record in subform,
> > check box will show in each record.Is possible to have visible check box
> > only on last records or on new records? So if i enter one record in
> subform
> > check box will be visible but if I enter another record ,check box on
old
> > one will be disenable or invisible.
> > Thanks for help even if you ignore this post!
> >
> > -----Original Message-----
> > From: Wesley Kendrick [mailto:wez.k@n...]
> > Sent: Friday, December 20, 2002 10:32 AM
> > To: Access
> > Subject: [access] Re: Realy need Help
> >
> >
> > Hello Nikola
> >
> > If I understand you correctly, this is what you do.
> >
> > Go ahead and create your checkbox.  Then create a field in your orders
> table
> > which will contain the value of the checkbox. (Checkboxes have a
different
> > value when they are ticked and when they are not ticked.)
> > Your report will, I assume, be based on a query on the orders table.
Open
> > the query in design view, insert the field which contains the checkbox
> > value, then set the criteria for that field to the value of the checkbox
> > when it is ticked.  The query will then filter out any orders which fit
> this
> > criteria and they wont appear on your report.
> >
> > If your report is based directly on the table itself, you will need to
> > create a query as above and change your reports data property to that.
> >
> > Hope this helps
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:04 AM
> > Subject: [access] Realy need Help
> >
> >
> > > Hi all,
> > >
> > > I was post this problem more then one time but without any luck. I'm
> > > desperate. So if you guys can help me with this.
> > >
> > > I have main form where user create Order. Each order have only one
> > Estimated
> > > cost Received from Suppliers. But Suppliers can send more invoice
amount
> > for
> > > that Order. So I create Continues Subform (Invoice Order)In Subform I
> have
> > 5
> > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > Now in Main form I create Order (OrderID = 14) and Estimated Cost for
> this
> > > Order is 5000 $.
> > > In Subform :
> > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > 1 14 2500$ 0% 12/11/2002
> > > 2 14 1000$ 0% 18/12/2002
> > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > And I have Accrual Report. Accrual report show list of open Orders(
> orders
> > > with difference between Estemeted cost - TotalInvoice Cost).So in
report
> > by
> > > above example:
> > > OrderID OpenCost
> > > 14 1500$ (5000$ - 3500$)
> > >
> > > Now my problem. Because Estimated cost is not guarantied cost from
> > supplier,
> > > difference between
> > > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > 0.00$.So
> > > I was thinking to create Check box (Last Invoice of Order).So when
user
> > > receive last invoice for order hi gonna select check box and this
order
> > will
> > > not show anymore in Report.
> > > Enzo suggest to create List Box instead Subform but this is out of my
> > > leage(I dont know to make setup with list box and how is posible to
add
> > or
> > > edit record in list box)
> > >
> > > So guys please help me with any solution, idea advice!!!
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
>
>

Hi Nikola, you haven't attached anything

Regards, Wesley Kendrick

----- Original Message -----
From: "Nikola" <Nikola@b...>
To: "Access" <access@p...>
Cc: <dcarnley@a...>
Sent: Monday, December 23, 2002 2:00 PM
Subject: [access] Re: Realy need Help


> Hi, I can not solw this problem
> in attachment is print screeen of my Order form with InvOrder Subform
>
> Thanks
>
> -----Original Message-----
> From: Carnley, Dave [mailto:dcarnley@a...]
> Sent: Friday, December 20, 2002 3:34 PM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Don't put the checkbox on the subform, put it on the parent form
>
> -----Original Message-----
> From: Nikola [mailto:nikola@b...]
> Sent: Friday, December 20, 2002 9:21 AM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Thank you very mach.I will try tonight.
> Nikola
> Sorry but what is Format and Data page?
> ----- Original Message -----
> From: "Wesley Kendrick" <wez.k@n...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 5:08 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hello Nikola
> >
> > The checkbox will have a Visible property (in the Format page) and an
> > Enabled property (in the Data page)
> > If you set the Visible property to False, the checkbox will disappear
(set
> > to True to make it appear).
> > If you set the Enabled property to False the checkbox will still be
there
> > but it will turn grey and you can not use it. (set to True to make it
> > enabled again).
> >
> > These properties can be set in VB like this:
> >
> > YourForm!YourCheckbox.Visible = False
> > or
> > YourForm!YourCheckbox.Enabled = False
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:40 PM
> > Subject: [access] Re: Realy need Help
> >
> >
> > > Hi Wesley,
> > > My problem is that subform is continues form so if I have more then 1
> > > invoice record in subform,
> > > check box will show in each record.Is possible to have visible check
box
> > > only on last records or on new records? So if i enter one record in
> > subform
> > > check box will be visible but if I enter another record ,check box on
> old
> > > one will be disenable or invisible.
> > > Thanks for help even if you ignore this post!
> > >
> > > -----Original Message-----
> > > From: Wesley Kendrick [mailto:wez.k@n...]
> > > Sent: Friday, December 20, 2002 10:32 AM
> > > To: Access
> > > Subject: [access] Re: Realy need Help
> > >
> > >
> > > Hello Nikola
> > >
> > > If I understand you correctly, this is what you do.
> > >
> > > Go ahead and create your checkbox.  Then create a field in your orders
> > table
> > > which will contain the value of the checkbox. (Checkboxes have a
> different
> > > value when they are ticked and when they are not ticked.)
> > > Your report will, I assume, be based on a query on the orders table.
> Open
> > > the query in design view, insert the field which contains the checkbox
> > > value, then set the criteria for that field to the value of the
checkbox
> > > when it is ticked.  The query will then filter out any orders which
fit
> > this
> > > criteria and they wont appear on your report.
> > >
> > > If your report is based directly on the table itself, you will need to
> > > create a query as above and change your reports data property to that.
> > >
> > > Hope this helps
> > >
> > > Regards, Wesley Kendrick
> > >
> > > ----- Original Message -----
> > > From: "Nikola" <Nikola@b...>
> > > To: "Access" <access@p...>
> > > Sent: Friday, December 20, 2002 1:04 AM
> > > Subject: [access] Realy need Help
> > >
> > >
> > > > Hi all,
> > > >
> > > > I was post this problem more then one time but without any luck. I'm
> > > > desperate. So if you guys can help me with this.
> > > >
> > > > I have main form where user create Order. Each order have only one
> > > Estimated
> > > > cost Received from Suppliers. But Suppliers can send more invoice
> amount
> > > for
> > > > that Order. So I create Continues Subform (Invoice Order)In Subform
I
> > have
> > > 5
> > > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > > Now in Main form I create Order (OrderID = 14) and Estimated Cost
for
> > this
> > > > Order is 5000 $.
> > > > In Subform :
> > > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > > 1 14 2500$ 0% 12/11/2002
> > > > 2 14 1000$ 0% 18/12/2002
> > > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > > And I have Accrual Report. Accrual report show list of open Orders(
> > orders
> > > > with difference between Estemeted cost - TotalInvoice Cost).So in
> report
> > > by
> > > > above example:
> > > > OrderID OpenCost
> > > > 14 1500$ (5000$ - 3500$)
> > > >
> > > > Now my problem. Because Estimated cost is not guarantied cost from
> > > supplier,
> > > > difference between
> > > > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > > 0.00$.So
> > > > I was thinking to create Check box (Last Invoice of Order).So when
> user
> > > > receive last invoice for order hi gonna select check box and this
> order
> > > will
> > > > not show anymore in Report.
> > > > Enzo suggest to create List Box instead Subform but this is out of
my
> > > > leage(I dont know to make setup with list box and how is posible to
> add
> > > or
> > > > edit record in list box)
> > > >
> > > > So guys please help me with any solution, idea advice!!!
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
>

-----Original Message-----
From: Wesley Kendrick [mailto:wez.k@n...]
Sent: Monday, December 23, 2002 12:10 PM
To: Access
Subject: [access] Re: Realy need Help


Hi Nikola, you haven't attached anything

Regards, Wesley Kendrick

----- Original Message -----
From: "Nikola" <Nikola@b...>
To: "Access" <access@p...>
Cc: <dcarnley@a...>
Sent: Monday, December 23, 2002 2:00 PM
Subject: [access] Re: Realy need Help


> Hi, I can not solw this problem
> in attachment is print screeen of my Order form with InvOrder Subform
>
> Thanks
>
> -----Original Message-----
> From: Carnley, Dave [mailto:dcarnley@a...]
> Sent: Friday, December 20, 2002 3:34 PM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Don't put the checkbox on the subform, put it on the parent form
>
> -----Original Message-----
> From: Nikola [mailto:nikola@b...]
> Sent: Friday, December 20, 2002 9:21 AM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Thank you very mach.I will try tonight.
> Nikola
> Sorry but what is Format and Data page?
> ----- Original Message -----
> From: "Wesley Kendrick" <wez.k@n...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 5:08 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hello Nikola
> >
> > The checkbox will have a Visible property (in the Format page) and an
> > Enabled property (in the Data page)
> > If you set the Visible property to False, the checkbox will disappear
(set
> > to True to make it appear).
> > If you set the Enabled property to False the checkbox will still be
there
> > but it will turn grey and you can not use it. (set to True to make it
> > enabled again).
> >
> > These properties can be set in VB like this:
> >
> > YourForm!YourCheckbox.Visible = False
> > or
> > YourForm!YourCheckbox.Enabled = False
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:40 PM
> > Subject: [access] Re: Realy need Help
> >
> >
> > > Hi Wesley,
> > > My problem is that subform is continues form so if I have more then 1
> > > invoice record in subform,
> > > check box will show in each record.Is possible to have visible check
box
> > > only on last records or on new records? So if i enter one record in
> > subform
> > > check box will be visible but if I enter another record ,check box on
> old
> > > one will be disenable or invisible.
> > > Thanks for help even if you ignore this post!
> > >
> > > -----Original Message-----
> > > From: Wesley Kendrick [mailto:wez.k@n...]
> > > Sent: Friday, December 20, 2002 10:32 AM
> > > To: Access
> > > Subject: [access] Re: Realy need Help
> > >
> > >
> > > Hello Nikola
> > >
> > > If I understand you correctly, this is what you do.
> > >
> > > Go ahead and create your checkbox.  Then create a field in your orders
> > table
> > > which will contain the value of the checkbox. (Checkboxes have a
> different
> > > value when they are ticked and when they are not ticked.)
> > > Your report will, I assume, be based on a query on the orders table.
> Open
> > > the query in design view, insert the field which contains the checkbox
> > > value, then set the criteria for that field to the value of the
checkbox
> > > when it is ticked.  The query will then filter out any orders which
fit
> > this
> > > criteria and they wont appear on your report.
> > >
> > > If your report is based directly on the table itself, you will need to
> > > create a query as above and change your reports data property to that.
> > >
> > > Hope this helps
> > >
> > > Regards, Wesley Kendrick
> > >
> > > ----- Original Message -----
> > > From: "Nikola" <Nikola@b...>
> > > To: "Access" <access@p...>
> > > Sent: Friday, December 20, 2002 1:04 AM
> > > Subject: [access] Realy need Help
> > >
> > >
> > > > Hi all,
> > > >
> > > > I was post this problem more then one time but without any luck. I'm
> > > > desperate. So if you guys can help me with this.
> > > >
> > > > I have main form where user create Order. Each order have only one
> > > Estimated
> > > > cost Received from Suppliers. But Suppliers can send more invoice
> amount
> > > for
> > > > that Order. So I create Continues Subform (Invoice Order)In Subform
I
> > have
> > > 5
> > > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > > Now in Main form I create Order (OrderID = 14) and Estimated Cost
for
> > this
> > > > Order is 5000 $.
> > > > In Subform :
> > > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > > 1 14 2500$ 0% 12/11/2002
> > > > 2 14 1000$ 0% 18/12/2002
> > > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > > And I have Accrual Report. Accrual report show list of open Orders(
> > orders
> > > > with difference between Estemeted cost - TotalInvoice Cost).So in
> report
> > > by
> > > > above example:
> > > > OrderID OpenCost
> > > > 14 1500$ (5000$ - 3500$)
> > > >
> > > > Now my problem. Because Estimated cost is not guarantied cost from
> > > supplier,
> > > > difference between
> > > > Estimated cost and TotalInvoice cots in 95% of orders will never be
> > > 0.00$.So
> > > > I was thinking to create Check box (Last Invoice of Order).So when
> user
> > > > receive last invoice for order hi gonna select check box and this
> order
> > > will
> > > > not show anymore in Report.
> > > > Enzo suggest to create List Box instead Subform but this is out of
my
> > > > leage(I dont know to make setup with list box and how is posible to
> add
> > > or
> > > > edit record in list box)
> > > >
> > > > So guys please help me with any solution, idea advice!!!
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
>

This forum does not accept screenprint attachments.  They are 
discarded.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Wesley Kendrick [mailto:wez.k@n...]
Sent: Monday, December 23, 2002 06:10
To: Access
Subject: [access] Re: Realy need Help

Hi Nikola, you haven't attached anything

Regards, Wesley Kendrick

----- Original Message -----
From: "Nikola" <Nikola@b...>
To: "Access" <access@p...>
Cc: <dcarnley@a...>
Sent: Monday, December 23, 2002 2:00 PM
Subject: [access] Re: Realy need Help


> Hi, I can not solw this problem
> in attachment is print screeen of my Order form with InvOrder Subform
>
> Thanks
>
> -----Original Message-----
> From: Carnley, Dave [mailto:dcarnley@a...]
> Sent: Friday, December 20, 2002 3:34 PM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Don't put the checkbox on the subform, put it on the parent form
>
> -----Original Message-----
> From: Nikola [mailto:nikola@b...]
> Sent: Friday, December 20, 2002 9:21 AM
> To: Access
> Subject: [access] Re: Realy need Help
>
>
> Thank you very mach.I will try tonight.
> Nikola
> Sorry but what is Format and Data page?
> ----- Original Message -----
> From: "Wesley Kendrick" <wez.k@n...>
> To: "Access" <access@p...>
> Sent: Friday, December 20, 2002 5:08 PM
> Subject: [access] Re: Realy need Help
>
>
> > Hello Nikola
> >
> > The checkbox will have a Visible property (in the Format page) and 
an
> > Enabled property (in the Data page)
> > If you set the Visible property to False, the checkbox will 
disappear
(set
> > to True to make it appear).
> > If you set the Enabled property to False the checkbox will still be
there
> > but it will turn grey and you can not use it. (set to True to make 
it
> > enabled again).
> >
> > These properties can be set in VB like this:
> >
> > YourForm!YourCheckbox.Visible =3D False
> > or
> > YourForm!YourCheckbox.Enabled =3D False
> >
> > Regards, Wesley Kendrick
> >
> > ----- Original Message -----
> > From: "Nikola" <Nikola@b...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 1:40 PM
> > Subject: [access] Re: Realy need Help
> >
> >
> > > Hi Wesley,
> > > My problem is that subform is continues form so if I have more 
then 1
> > > invoice record in subform,
> > > check box will show in each record.Is possible to have visible 
check
box
> > > only on last records or on new records? So if i enter one record 
in
> > subform
> > > check box will be visible but if I enter another record ,check 
box on
> old
> > > one will be disenable or invisible.
> > > Thanks for help even if you ignore this post!
> > >
> > > -----Original Message-----
> > > From: Wesley Kendrick [mailto:wez.k@n...]
> > > Sent: Friday, December 20, 2002 10:32 AM
> > > To: Access
> > > Subject: [access] Re: Realy need Help
> > >
> > >
> > > Hello Nikola
> > >
> > > If I understand you correctly, this is what you do.
> > >
> > > Go ahead and create your checkbox.  Then create a field in your 
orders
> > table
> > > which will contain the value of the checkbox. (Checkboxes have a
> different
> > > value when they are ticked and when they are not ticked.)
> > > Your report will, I assume, be based on a query on the orders 
table.
> Open
> > > the query in design view, insert the field which contains the 
checkbox
> > > value, then set the criteria for that field to the value of the
checkbox
> > > when it is ticked.  The query will then filter out any orders 
which
fit
> > this
> > > criteria and they wont appear on your report.
> > >
> > > If your report is based directly on the table itself, you will 
need to
> > > create a query as above and change your reports data property to 
that.
> > >
> > > Hope this helps
> > >
> > > Regards, Wesley Kendrick
> > >
> > > ----- Original Message -----
> > > From: "Nikola" <Nikola@b...>
> > > To: "Access" <access@p...>
> > > Sent: Friday, December 20, 2002 1:04 AM
> > > Subject: [access] Realy need Help
> > >
> > >
> > > > Hi all,
> > > >
> > > > I was post this problem more then one time but without any 
luck. I'm
> > > > desperate. So if you guys can help me with this.
> > > >
> > > > I have main form where user create Order. Each order have only 
one
> > > Estimated
> > > > cost Received from Suppliers. But Suppliers can send more 
invoice
> amount
> > > for
> > > > that Order. So I create Continues Subform (Invoice Order)In 
Subform
I
> > have
> > > 5
> > > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > > Now in Main form I create Order (OrderID =3D 14) and Estimated 
Cost
for
> > this
> > > > Order is 5000 $.
> > > > In Subform :
> > > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > > 1 14 2500$ 0% 12/11/2002
> > > > 2 14 1000$ 0% 18/12/2002
> > > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > > And I have Accrual Report. Accrual report show list of open 
Orders(
> > orders
> > > > with difference between Estemeted cost - TotalInvoice Cost).So 
in
> report
> > > by
> > > > above example:
> > > > OrderID OpenCost
> > > > 14 1500$ (5000$ - 3500$)
> > > >
> > > > Now my problem. Because Estimated cost is not guarantied cost 
from
> > > supplier,
> > > > difference between
> > > > Estimated cost and TotalInvoice cots in 95% of orders will 
never be
> > > 0.00$.So
> > > > I was thinking to create Check box (Last Invoice of Order).So 
when
> user
> > > > receive last invoice for order hi gonna select check box and 
this
> order
> > > will
> > > > not show anymore in Report.
> > > > Enzo suggest to create List Box instead Subform but this is out 
of
my
> > > > leage(I dont know to make setup with list box and how is 
posible to
> add
> > > or
> > > > edit record in list box)
> > > >
> > > > So guys please help me with any solution, idea advice!!!
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
>

The WROX P2P lists don't support attachments :(



>From: "Nikola" <Nikola@b...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>CC: "Access" <access@p...>
>Subject: [access] Re: Realy need Help
>Date: Mon, 23 Dec 2002 14:15:11 -0000
>
>
>
>-----Original Message-----
>From: Wesley Kendrick [mailto:wez.k@n...]
>Sent: Monday, December 23, 2002 12:10 PM
>To: Access
>Subject: [access] Re: Realy need Help
>
>
>Hi Nikola, you haven't attached anything
>
>Regards, Wesley Kendrick
>
>----- Original Message -----
>From: "Nikola" <Nikola@b...>
>To: "Access" <access@p...>
>Cc: <dcarnley@a...>
>Sent: Monday, December 23, 2002 2:00 PM
>Subject: [access] Re: Realy need Help
>
>
> > Hi, I can not solw this problem
> > in attachment is print screeen of my Order form with InvOrder Subform
> >
> > Thanks
> >
> > -----Original Message-----
> > From: Carnley, Dave [mailto:dcarnley@a...]
> > Sent: Friday, December 20, 2002 3:34 PM
> > To: Access
> > Subject: [access] Re: Realy need Help
> >
> >
> > Don't put the checkbox on the subform, put it on the parent form
> >
> > -----Original Message-----
> > From: Nikola [mailto:nikola@b...]
> > Sent: Friday, December 20, 2002 9:21 AM
> > To: Access
> > Subject: [access] Re: Realy need Help
> >
> >
> > Thank you very mach.I will try tonight.
> > Nikola
> > Sorry but what is Format and Data page?
> > ----- Original Message -----
> > From: "Wesley Kendrick" <wez.k@n...>
> > To: "Access" <access@p...>
> > Sent: Friday, December 20, 2002 5:08 PM
> > Subject: [access] Re: Realy need Help
> >
> >
> > > Hello Nikola
> > >
> > > The checkbox will have a Visible property (in the Format page) and an
> > > Enabled property (in the Data page)
> > > If you set the Visible property to False, the checkbox will disappear
>(set
> > > to True to make it appear).
> > > If you set the Enabled property to False the checkbox will still be
>there
> > > but it will turn grey and you can not use it. (set to True to make it
> > > enabled again).
> > >
> > > These properties can be set in VB like this:
> > >
> > > YourForm!YourCheckbox.Visible = False
> > > or
> > > YourForm!YourCheckbox.Enabled = False
> > >
> > > Regards, Wesley Kendrick
> > >
> > > ----- Original Message -----
> > > From: "Nikola" <Nikola@b...>
> > > To: "Access" <access@p...>
> > > Sent: Friday, December 20, 2002 1:40 PM
> > > Subject: [access] Re: Realy need Help
> > >
> > >
> > > > Hi Wesley,
> > > > My problem is that subform is continues form so if I have more then 
>1
> > > > invoice record in subform,
> > > > check box will show in each record.Is possible to have visible check
>box
> > > > only on last records or on new records? So if i enter one record in
> > > subform
> > > > check box will be visible but if I enter another record ,check box 
>on
> > old
> > > > one will be disenable or invisible.
> > > > Thanks for help even if you ignore this post!
> > > >
> > > > -----Original Message-----
> > > > From: Wesley Kendrick [mailto:wez.k@n...]
> > > > Sent: Friday, December 20, 2002 10:32 AM
> > > > To: Access
> > > > Subject: [access] Re: Realy need Help
> > > >
> > > >
> > > > Hello Nikola
> > > >
> > > > If I understand you correctly, this is what you do.
> > > >
> > > > Go ahead and create your checkbox.  Then create a field in your 
>orders
> > > table
> > > > which will contain the value of the checkbox. (Checkboxes have a
> > different
> > > > value when they are ticked and when they are not ticked.)
> > > > Your report will, I assume, be based on a query on the orders table.
> > Open
> > > > the query in design view, insert the field which contains the 
>checkbox
> > > > value, then set the criteria for that field to the value of the
>checkbox
> > > > when it is ticked.  The query will then filter out any orders which
>fit
> > > this
> > > > criteria and they wont appear on your report.
> > > >
> > > > If your report is based directly on the table itself, you will need 
>to
> > > > create a query as above and change your reports data property to 
>that.
> > > >
> > > > Hope this helps
> > > >
> > > > Regards, Wesley Kendrick
> > > >
> > > > ----- Original Message -----
> > > > From: "Nikola" <Nikola@b...>
> > > > To: "Access" <access@p...>
> > > > Sent: Friday, December 20, 2002 1:04 AM
> > > > Subject: [access] Realy need Help
> > > >
> > > >
> > > > > Hi all,
> > > > >
> > > > > I was post this problem more then one time but without any luck. 
>I'm
> > > > > desperate. So if you guys can help me with this.
> > > > >
> > > > > I have main form where user create Order. Each order have only one
> > > > Estimated
> > > > > cost Received from Suppliers. But Suppliers can send more invoice
> > amount
> > > > for
> > > > > that Order. So I create Continues Subform (Invoice Order)In 
>Subform
>I
> > > have
> > > > 5
> > > > > field (InvOrderID,OrderID,InvoiceCost,Discaunt,InvoiceDate).
> > > > > Now in Main form I create Order (OrderID = 14) and Estimated Cost
>for
> > > this
> > > > > Order is 5000 $.
> > > > > In Subform :
> > > > > InvOrderID OrderID InvoiceCost Discaunt Inv.Date
> > > > > 1 14 2500$ 0% 12/11/2002
> > > > > 2 14 1000$ 0% 18/12/2002
> > > > > So total of invoice Cost for OrderID 14 is 3500 $.
> > > > > And I have Accrual Report. Accrual report show list of open 
>Orders(
> > > orders
> > > > > with difference between Estemeted cost - TotalInvoice Cost).So in
> > report
> > > > by
> > > > > above example:
> > > > > OrderID OpenCost
> > > > > 14 1500$ (5000$ - 3500$)
> > > > >
> > > > > Now my problem. Because Estimated cost is not guarantied cost from
> > > > supplier,
> > > > > difference between
> > > > > Estimated cost and TotalInvoice cots in 95% of orders will never 
>be
> > > > 0.00$.So
> > > > > I was thinking to create Check box (Last Invoice of Order).So when
> > user
> > > > > receive last invoice for order hi gonna select check box and this
> > order
> > > > will
> > > > > not show anymore in Report.
> > > > > Enzo suggest to create List Box instead Subform but this is out of
>my
> > > > > leage(I dont know to make setup with list box and how is posible 
>to
> > add
> > > > or
> > > > > edit record in list box)
> > > > >
> > > > > So guys please help me with any solution, idea advice!!!
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
>
>
>


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 3 months FREE*. 
http://join.msn.com/?page=features/virus&xAPID=42&PS=47575&PI=7324&DI=7474&SU= 
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_virusprotection_3mf