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

help with opening the form /clear the form

P: n/a
I have a form which is designed to only data entery.When i try to open
to form in the run form I have the following errors

1. when i open the form I get an error message saying "Access can't
find macros" - The macro (or its macro groups) does not exits or
themacro is new but has'nt been saved.Not that when you enter a
macrogroup.macroname syntax in an argumentyou must specify the name
macro group was last saved under.

But when I click OK I am able to open the form.To make it clear I do
not think I have added any macro but I written few validation for the
fields.I do get this message after entering the data and hit enter to
save the data.

2. Secondly,I have written the following code in the key press event
of the employee number to allow the user to ente only numbers in this
field.

If (KeyAscii < 48) Or (KeyAscii > 57) Then
KeyAscii = 0
MsgBox "Please Enter Only Numbers", vbOKOnly, "New Employee
Number"
End If

When the data entry is complete and when I hit enter in the last field
to save the records,no doubt the records are saved but the fields do
not get clear for the next date entry.And when I press enter again the
fields get clear and I get the message writtin in the key press event
of the employee id and the focus stays in the last field.All I want to
do is to save the record,Clear the form for the next data entry,set
the focus to employee id field .

Thanks in advance
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.