update 2000 to 2003 macro help

  • Thread starter Thread starter Gerry H
  • Start date Start date
G

Gerry H

Hi,

I have just converted a 2000 database to 2003 and now my macros dont work.
They should be quite simple and are for setting up OK and Cancel buttons on a
form to populate a query.

The error i get is related to the Action "SetValue" (when OK is pressed),
previously the parameters were Item - Visible and Expression - yes

The error I now get is that the expression is invalid.

Any help would be apreciated.
 
Hi Gerry,

here is an example from A2003 help. You may need to create a new macro in
A2003.
This example is used to set the SupplierID control to the current supplier
on the Suppliers form.

Action is SetValue
Item: [Forms]![Products]![SupplierID]
Expression: SupplierID

Jeanette Cunningham
 
Thanks Jeanette,

I have since established that some active X controls were missing from the
install and i needed to start a dummy project to initialise them.

It worked fine after that.

Again, many thanks,

Jeanette Cunningham said:
Hi Gerry,

here is an example from A2003 help. You may need to create a new macro in
A2003.
This example is used to set the SupplierID control to the current supplier
on the Suppliers form.

Action is SetValue
Item: [Forms]![Products]![SupplierID]
Expression: SupplierID

Jeanette Cunningham


Gerry H said:
Hi,

I have just converted a 2000 database to 2003 and now my macros dont work.
They should be quite simple and are for setting up OK and Cancel buttons
on a
form to populate a query.

The error i get is related to the Action "SetValue" (when OK is pressed),
previously the parameters were Item - Visible and Expression - yes

The error I now get is that the expression is invalid.

Any help would be apreciated.
Click to expand...
Click to expand...
 
Back
Top