Search results for query: *

The problem is that when I go to enter data in the first data field of the subform I get the 'Field can't be updated' error message. As soon as I hit ok everything is fine and I can update the record. There are no other users as I am on a single PC and it is the only thing running. The...

I would like to run an update query in the background and not have it show the message box or ask for ok to continue as that is part of its usual routine, can I turn it off. Can you please tell me where that is done if I can do it. Thank you so much. I have read many screens, pages of them, to...

Where is the best place to put calculations. Here is the problem. Within the bound control on my form, I have been putting calculations in the Control Source Property. This calculation is based on entry of other fields, shipping cost, and discount amount, etc. I need to see the result of the...

Where is the best place to put calculations. Here is the problem. Within the bound control on my form, I have been putting calculations in the Control Source Property. This calculation is based on entry of other fields, shipping cost, and discount amount, etc. I need to see the result of the...

New to this, love Access, read this site often for answers. Need help PLEASE. Have unbound control on form "Itotals" which does calculations great, shows the results great. Form is bound to table "InvoiceC" I want to have the Itotals figure displayed, put in the field IAtotals. Please help me...

Is there a way to exit a subform based on a field control in the subform, such as, If the QTY is 0. I want to not save that entry of detail, and continue filling out the fields on main form. This is an invoice data entry situation that I am working on. I really like Access, but being new at it...

Is there an easy way to exit a subform and go back to the main form to finish entering data there. If the user doesn't enter a quantity in the detail of the subform I want to automatically leave the subform and continue on with entry to main form. Oh yes, can you tell me where to put the...

Have simple data entry layout subform, continous form type (Yes, a newbi, who needs help badly), yet I love Access. When the form is active for entry the form produces two lines of fields for entry. The first line has pencil symbol. Then lower is a line of fields same as above with an * which...

Being a newbie, some of this is so logical, so easy, and other things so complicated, I am missing something, DATA ENTRY Form. unbound text field and I want it to show the highext value in the current file. Form is connected to file, HIH and in that file is field VCNO so on control source...

I didn't make myself very clear before, sorry. I am creating an invoice system. My invoices involve two files, one for the header info and the second for the products ordered. In the header I have the entery person enter the customer code, then I want the customer name, address etc. to be...

On my data entry form, have entry of customer code, once this is filled in I want to display customer name and address from the file. I use dlookup and that works great for viewing data after the fact. I have the fields set to no entry and lock yes so the data will not dim, easier to see. I want...

I have at home and at office, Microsoft Office Access 2003, part of my office professional edition 2003. Both home and office computers are running Windows xp home edition and not hooked to a server, stand alone as they say. If I create an invoice system in Access 2003, at home, then take it to...

I have programmed before in Clipper, used Case statement and found it a wonderful tool. Checked all the books at Barns & Noble on Access 2003 and VB could find no such tool available. Then in one of the answers to another question an individual had, saw it used. "Select Case", I do hope someone...