converted all macros to VBA but?

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

Guest

I converted all my macros to VBA and when I teried to open my forms from my
switchboard, nothing happends. It says I am missing a certain file or? I also
checked my backup and it does the same thing. What happened and how can I fix
this? PLEASE HELP!
 
Why file is it complaining about?

While in the VB Editor, select Tools | References from the menu bar and
examine all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)
 
It does not work. This is very strange. I do not want to redo everything in
Macros. It would take me a month or so. This is the first time I tried using
macros and will be the last. Can you think of anything else that would cause
this. No buttons work at all!

Thanks for your help
 
Here is what it states when the program opens...

Windows can not open J:\Asset Current.accdb... This looks like it is trying
to open and or read from a certain folder? I never changed any folder or or
path before or after the macro conversion. Whne I try and open another form
directly from another form it states..error..ambiguors name dectected
form_sb_click and it also states the expression on LOAD you entered as event
property setting. This makes no sense? Any ideas?
 
VBA code is disabled by default in Access 2007. You need to add the path
where your databases are stored to Trusted Locations. You do this through
the Office Button | Access Options | Trust Center | Trusted Locations.

Incidentally, I've noticed you're also carrying on this discussion in
another newsgroup. If you feel you need to post to more than one group
(HINT: it's seldom necessary), please have the courtesy to cross-post (send
the one message to all groups at once), rather than multi-post (send
individual messages to each group). In this way, all responses to your post
will be available together, regardless of what group the responder was in,
and the rest of us won't have to read your post multiple times. (It also
uses fewer server resources)

If you're using Microsoft's web interface to post, you should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.
 
Back
Top