squidlings
asked on
Form query issue.
Hi,
I have a problem in a form where the tick box doesn't work when the form is open.
I've created a simplified version of my .mdb to upload. If somebody could give me the link to upload the file and have a look.
basiscally. I've got 2 tbls. one is customer info, the other holds info for cheques we've recieved.
I've done a query to sum the cheque amounts for each query.
When I create a form and use all the fields in tbl 1, plus the sum field, it doesn't allow the tick box to work?
This is really hurting my head, please help :)
I'm in the UK, It's 10.45am, I'm chained to this desk till 5.30pm, I'll be here to respond quickly to your help.
I have a problem in a form where the tick box doesn't work when the form is open.
I've created a simplified version of my .mdb to upload. If somebody could give me the link to upload the file and have a look.
basiscally. I've got 2 tbls. one is customer info, the other holds info for cheques we've recieved.
I've done a query to sum the cheque amounts for each query.
When I create a form and use all the fields in tbl 1, plus the sum field, it doesn't allow the tick box to work?
This is really hurting my head, please help :)
I'm in the UK, It's 10.45am, I'm chained to this desk till 5.30pm, I'll be here to respond quickly to your help.
ASKER
Ok, that's not good. But I've learned not to do that again.
Please could you give me an example of Dsum?
So I create a form with only TBL 1
Acc Num : text (key)
Customer order value: currency
release : yes/no
It is important I can see the value of all the individual cheques to confirm that the cheque value = order value before I can tick release. How do I use Dsum to enter that field within the form?
For your information ; TBL2
Acc Num : text (key)
Chq amount : currency
chq date : date/time
Thanks you so much. I've posted so many help questions for this and your the first person to tell me how it is!!! Thanks so much :) And I didn't even need to upload a copy of the DB!!!
Please could you give me an example of Dsum?
So I create a form with only TBL 1
Acc Num : text (key)
Customer order value: currency
release : yes/no
It is important I can see the value of all the individual cheques to confirm that the cheque value = order value before I can tick release. How do I use Dsum to enter that field within the form?
For your information ; TBL2
Acc Num : text (key)
Chq amount : currency
chq date : date/time
Thanks you so much. I've posted so many help questions for this and your the first person to tell me how it is!!! Thanks so much :) And I didn't even need to upload a copy of the DB!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers for your help there.
I have already got 1 form which can do this, main form and subform which runs the sum query, this works great, however, I needed the dsum command because I would like to have a full screen of customers, rather than individual account view. i.e. datasheet view.
I'm from manchester, but I'm living in london. small world eh? :P
I have already got 1 form which can do this, main form and subform which runs the sum query, this works great, however, I needed the dsum command because I would like to have a full screen of customers, rather than individual account view. i.e. datasheet view.
I'm from manchester, but I'm living in london. small world eh? :P
Therefore you have to find a different approach.
It sounds like you could base the form on the table alone, and then use an unbound control with a Dsum() function to get the total.