Problem from converting from Access 2000 to 2003

M

Michalis J.

I have just converted a file from Access 2000 to 2003.
A combo box that used to take values from a query (when selecting a value
from an other combo box) does not return any values any more.
I also get an annoying security worning when I start up the file.
Does anybody know how can these problems be solved?

Thanks in advance.
 
M

Mark M

I'm not sure about the combo box problem, but the security warning can be
changed by going to Tools|Macro|Security menu and changing the option from
the default "Medium" to "Low".
 
M

Michalis J.

Thank you for your answer Mark M. The problem with the combo box I believe
originates from the way text is read in the table. The appearance and
aligning of the text in the table (which is used in the query) looks strange.
 
M

Michalis J.

As regards to the security problem, although I get the same instractions from
the help file, I have no security option under Tools|Macro
 
J

John Vinson

As regards to the security problem, although I get the same instractions from
the help file, I have no security option under Tools|Macro
Click to expand...

It's not there: it's under Tools... Security.

John W. Vinson[MVP]
 
B

Brendan Reynolds

It's Tools, then Macro, then Security. If you see a downward-pointing arrow
at the bottom of the Macro submenu, hover the mouse over that for a moment
to fully expand the menu.

If you still don't see the Security menu item, you need to reset your menu
bar. Right-click the menu bar and choose Customize. Choose the Toolbars tab.
Now select Menu Bar in the list of toolbars. Now click the Reset button, and
then the Close button.

Resetting the menu bar will remove any customizations you may have made to
that menu, but I'm not aware of any other way to do this. I'd guess that it
is probably possible to do it by editing the registry, but that's just a
guess.
 
R

Rick Brandt

I think you have to reset the menu before it shows up on some systems (though it
has always been there on every PC I have looked at).
 
M

Michalis J.

Thank you very much Brendan. That solved the problem with the combo box
aswell.
 
Top