Using old database in Access 2007

  • Thread starter Thread starter Art4U
  • Start date Start date
A

Art4U

I have a new computer w/Office 2007 installed. Our database was created under
Office 2000/upgraded to 2003.
In Form, I have a field: "Name Lookup" which allows (or allowed) me to move
from one record to another easily.
PROBLEM: Nothing happens now when I type a last name in the block. The drop
down box shows the name being searched for , but the Form doesn't shift to
the corresponding data. Any ideas (short of recreating my database)???
 
Triss,

You have to enable the macro's in your project. It's also necessary to place
you db in a trusted directory.

Follow these steps:

Go to the Office button
Choose "Access options"
Choose Trustcenter - trustcenter settings (right side)
In the next dialog choose macro settings (enable macro's)
In the trusted locations add your directory where the db resides to the
trusted locations.

Open the db and try again.
hth
 
Maurice -
Great - sort of helped. After I followed your steps, I tried it again -
still didn't work but then accidentally "right-clicked" my mouse and tada! it
brought up the requested record.

Is that a 'glitch' or is that what should have happened. (My technical
expertise is zip, so any help is appreciated!)
Thanks
 
Strange, that isn't the way to activate it :-) although it worked it's not a
new glitch of how things should work.

By default macro's are being disabled so reading your post I see a combobox
with VBA event behind it. So while the macro's are being disabled one of the
options would be to enable them. New feature is to put db's in a trusted
directory so the macro's will run. I don't know anything about the rightclick
feature that might trigger something. Have you tried closing Access and
starting it up again? Does the record still show up with the right click
option...
 
Back
Top