Search results

I have a form that includes a couple of Auto Fill boxes, some math, and After_Update, Before_update etc. event coding. The form resides on a Windows 2000 Server. The form works fabulously on my computer. I have user level administrative rights. When I open it on another computer, generally that...

Thank you, I had a feeling that might be part of the problem. I will try it tomorrow when I get in and post my results. Thank you.

First I changed the close code to DoCmd.Close. Both the "close door" button and the orange X completely close the form without asking for any information. Second, I put in the = 0 and it seems to completely bypass the Form_BeforeUpdate procedure and close the form. If there is nothing in any...

I have to admit I feel a little foolish, I do have a macro running the close door button. I also get the same errors when I click the Orange X. So I can't post any code. Only the code from the BeforeUpdate, which you've already seen, but I will post it here again: Private Sub...

If "No" is selected MS Access comes back with "You can't save this record at this time. Microsoft Office Access may have encountered an error while trying to save a record. If you close this object now, the data changes you made will be lost. Do you want to close the database any way? Yes/No" If...

Still getting the "Runtime Error" Any ideas?

I have a situation where users add one field and then close the form leaving imcomplete records in the table. I tried similar coding in the Before_update and got a similar result. I may be way off on this but here is what I have, (at this point I get an error and the form closes anyway)...

I used the macro version through the wizard to create the search button. When it brings up a record all is good but if no infromation is entered and a different record is selected a reference record using the search criteria (ie, "inspection number") is left in the coorepsonding table. The...

:) Success!! Bob and Chris, all I can say is you are my heros!! I am rusty and I fear a little outdated in my Access skills and I had forgotten some basic common sense programming helps. But your simplification and clarifications solved the problem. I also learned a few new things. Thank you and...

:banghead: I am afraid I am a bit rusty with VB. Can anyone help me firgure out why this is not working? It may be something simple but I can't see it. This is a form Named LogForm. When the "Save Button" is clicked I want it to check the Packaging Name field (which is a Drop Down Combo Box...