It's alright. The goal was 5pm Friday. No big deal, I'm still working on the test database.
I will look at the code on Monday to see what I find regarding the "unload." I'm taking the weekend off to refuel my brain.
I'll see what I can find. I did find that my original database has an error as well, which is odd because I set it to its original parameters, but I'll fix that on Monday too.
...
Marilyth
Last Activity: May 5 '09, 04:09 PM
Joined: Apr 29 '09
Location:
-
Here's the frustration now. I removed the docmd.close, and close using the "X" and it works perfectly! But, with this group of people there HAS to be a "Close & Save" button, or else the world will end (those of you who work with bureaucratic bs will understand).
So, now, how do I get a command button that will mimic the "X"??
So close!!! 2:30pm, 2.5 hrs until 5pm goal.Leave a comment:
-
Your assertions are correct.
I think I understand what you're saying. Is it a manner of changing the order of the commands so they run individually/in a different order, so the form errors are identified, the message box identifies the errors, allows user to go back to form or exit without saving & once all information is correct allow the user to save & close the form for later use?
Thanks for the assist!!...Leave a comment:
-
The answer to the question is we are entering information into fields as text and in command boxes (pull down boxes) that are required to save the record. The purpose of the action is to have a pop-up box indicate to the user that they have not entered information in a required field, and allow them the opportunity to go back to the form and enter the information.
I have a Save/Close button on the form. After I entered the long format...Leave a comment:
-
Another Issue
I entered the code as indicated, however it selects the first control, pops up the box, and when OK is selected it closes the form. I want it to go back to the control so it can be entered so the info is not lost. When it does this the info is lost.
I'm not sure what's causing it, and I don't know the syntax to resolve the issue.
Any suggestions?
Thanks again!!!...Leave a comment:
-
Thank you for the responses. I will check them today.Leave a comment:
-
hello, I read your post an i think it would be easier to communicate via email to help you build this. It seems your wanting to create a form, allows multi users to enter data, but must fill out certain fileds (required) and can't save or exit unless the record is complete or message is given that the data will be lost. About right? -
Saving Record with "Conditions"
I am using Windows XP and Access 2003. I have searched through my HUGE book & the questions here, and found some items that "might" help, but unsure still. I am still getting versed on Access. I know there are expressions, however the order and manner in which they need to be phrased is still a work in progress.
I am looking for help creating some code/expressions. The database is summarized below:
1....
No activity results to display
Leave a comment: