microsoft access cannot find the macro '.'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

this is a message box i get when opening or closing forms and queries. it
only appears 50% of the time, and everything works fine once I press ok.
I have not got a macro called . and access doesnt allow you to name a macro
'.'I have trawled through every bit of vba in my system, and thwere are no
referneces to any macro called '.' has anyone got an idea why my sytem is
doing this?
 
Hi.
I have trawled through every bit of vba in my system, and thwere are no
referneces to any macro called '.' has anyone got an idea why my sytem is
doing this?
Click to expand...

Most likely, the form, subform, or a control on any of these objects has an
event property with one or more spaces typed in it (which is why there's no
macro name mentioned in the error message). It's hard to find which event is
causing this error, but it's often due to an "OnCurrent" event or
"OnGotFocus" event with a space accidently typed in the combo box of the
property while the form is in Design View.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
Back
Top