Access 2007

S

sgopus

I have a database I designed in access 2003, some of the forms will not work
in office 2007, specifically I have a combo box that I want to look up a
record and populate the rest of the fields in my form, depending on the
record name I click on in the combo box, but each time I select a name I get
an error, invalid arguement or function, and it takes me to VB, to the line
of code for that subroutine, I even tried redoing the form in 2007 letting it
set the combo box, no dice, same error, is this a problem with a missing
microsoft library, like some problems in 2003 or just what is the problem.
 
M

Maurice

Post your code from the combo here and point out where the problem arises so
we might be able to help you.
 
L

Linq Adams via AccessMonster.com

Two things come to mind.

Code does not run in 2007 unless your database resides in a folder that has
been declared a “trusted†location.

To trust your folder, click:

Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

Also, when code works on one PC and not another (which means another copy of
Access is in use) or when moving code from one version of Access to another
and the code stops working, you have to think about missing references.
 
B

Bill Smith

sgopus said:
I have a database I designed in access 2003, some of the forms will not
work
in office 2007, specifically I have a combo box that I want to look up a
record and populate the rest of the fields in my form, depending on the
record name I click on in the combo box, but each time I select a name I
get
an error, invalid arguement or function, and it takes me to VB, to the
line
of code for that subroutine, I even tried redoing the form in 2007 letting
it
set the combo box, no dice, same error, is this a problem with a missing
microsoft library, like some problems in 2003 or just what is the problem.
Click to expand...

I've had the same issue on a few of my databases. I took the eary route and
just deleted the combobox and recreated it. They all work fine now.
 
S

sgopus

Thanks all for your responses, I managed to resolve my issue, by converting
the database format to 2007, I created it years ago using 2003, once I did
the conversion, my forms worked fine, drove me nuts for hours till I read
about it, in another forum.
 
Top