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...

This was just what I needed. I'll use the vb code thing because I can just set it to false for the time that it is needed then back again. Thanks for your help. Not sure about the unsafe part as it is just a simple update that shouldn't harm any of the data, only sets up the table for a simple...

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...

Trust me, I received the same thrashing from others on this subject, finally after persistant inquire got an answer. There are rules, and there are exceptions. Check my thread 702-1023228. I had had it and was going to trash access and do my project over in another system, then I got an answer...

Lorirobn, I felt the need to add to your orginal comment about finding answers. You should see the library I have, almost every current book on Access. I even took to spending time, lots of it, to reading most of them as though they were a novel. Though I now have a very good understanding of...

All worked great, I am very excited that I can now stuff that data into the table. There are 27 activities that depend on that data being there, and not constantly recalculated. There are rules, then there are exceptions. I thank you so much for your help and assistance. Appears you are very...

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...

My situation is such that the user need to see the result of the calculations on the screen, in the form, as they are working. Yes I agree that good design doesn't mean storing the result of calculations related to known data, that which is already being stored. There are times when a violation...

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...

I did this I put in the bound box, then on the BeforeUpdate event property IATotals = Me![Itotals] Hummmmm, it didn't work. Has to be a way to do this. It is a simple type of thing and logically your suggestion seems correct. Gave it a try and no cigar, still nothing in file. Any help...

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...

Not using autonumber, have simple numbering system that they had in use for quite some time. I get involved with converting clipper programs to Access. Pushing data and everything else, like new programs, screens the whole lot. I enjoy it a lot but some times Access stumps me because I am so new...

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...

Yes, yes, and yes. It worked, and I thank you so very much. Works beautiful and is just what I wanted, and they need. Should name my first born after you, just don't know how the family would pronounce PHV. Thank you.

When I put the [textbox name].requery in the AfterUpdate Event rocedure of the combo box, it tells me can't find macro of that name. Is there another way to get data from another file to display on a form that would be easier. Perhaps I am going about this all the wrong way. Please advise...

Thank you for your reply. I have the dlookup in the controlsource property of the textboxs but I don't know how to requery in the afterupdate event procedure of the combo box. the customer file is FILCUSTOMER Fields fldcco (customer code) fldna (name )...

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...