By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Data Entry Form and undo changes

P: 52
I’m hoping you can help me get my form to work. I have a few issues that I need to get squared away.

1. I am using a form for data entry only therefore I need the form to pop with the next available record. If I can get the form to load and be ready for input, making it as simple as possible for the user to enter records without having to navigate to the end of the database would be helpful.

2. I have an event_create_timestamp within a form in which I would like to auto populate when the form loads (same form as question number 1). Can I get the form to auto populate the field so the user does not have to? I currently have the field enactive so they can see it just not alter it.

3. Can you help me with a clear all fields in case they enter bogus data and want to start over before the record is saved to the database? It would be nice to clear all the data they may have entered and place them back into a scenario where they can carry on and append a record to the database.

Any help in getting these situations ironed out would be extremely appreciated..


Thanks much..
Mike
Dec 9 '06 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
"The title of this thread has been changed to make the problem clearer to experts and others searching for similar threads."

MODERATOR
Dec 9 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
I’m hoping you can help me get my form to work. I have a few issues that I need to get squared away.

1. I am using a form for data entry only therefore I need the form to pop with the next available record. If I can get the form to load and be ready for input, making it as simple as possible for the user to enter records without having to navigate to the end of the database would be helpful.
In the form properties, under the data tab, set the Data Entry property to Yes.

2. I have an event_create_timestamp within a form in which I would like to auto populate when the form loads (same form as question number 1). Can I get the form to auto populate the field so the user does not have to? I currently have the field enactive so they can see it just not alter it.
In the field (controls) properties under the data tab, set the default value to Now()

3. Can you help me with a clear all fields in case they enter bogus data and want to start over before the record is saved to the database? It would be nice to clear all the data they may have entered and place them back into a scenario where they can carry on and append a record to the database.
You need to put the following line of code behind a command button on the form.

[PHP]
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
[/PHP]

Mary
Dec 9 '06 #3

P: 52
Thanks Mary,

I will try to better describe my issues within the Title on future posts. Your assistance was truly appreciated and helped fill in multiple pieces of the puzzle. I am new to Access and am trying to learn from documentation (“Access 2003 Bible” from Wiley publications). I must admit it was truly above me but I am now starting to understand how this all works. I do have a few other questions though.

Can you recommend a reference that would give examples of how to build objects within a form or report? I unfortunately learn via example and need to see the context and structure of the statement before I can grasp it.

How can I pass the focus back to the first object within a form after the Clear command button is selected?

Again, I really appreciate the help. Thanks GOD for people like you who are willing to help goobers like me..

Mike
Dec 11 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks Mary,

I will try to better describe my issues within the Title on future posts. Your assistance was truly appreciated and helped fill in multiple pieces of the puzzle. I am new to Access and am trying to learn from documentation (“Access 2003 Bible” from Wiley publications). I must admit it was truly above me but I am now starting to understand how this all works. I do have a few other questions though.
You're welcome Mike.

Can you recommend a reference that would give examples of how to build objects within a form or report? I unfortunately learn via example and need to see the context and structure of the statement before I can grasp it.
Check out the thread called 'Links to useful Sites' near the top of the access forums.

How can I pass the focus back to the first object within a form after the Clear command button is selected?
just add the line ...

Expand|Select|Wrap|Line Numbers
  1. Me.ControlName.SetFocus 
after the undo statement

Mary
Dec 11 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.