Problem Opening Query with Macro (1 Viewer)

access2010

Registered User.
Local time
Today, 10:18
Joined
Dec 26, 2009
Messages
1,019
We are using Access 2003 and would like to open a query as shown below

Macro name ^R
Query Name Research=Portfolio
 

access2010

Registered User.
Local time
Today, 10:18
Joined
Dec 26, 2009
Messages
1,019
We are using Access 2003 and would like to open a query as shown below

Macro name.... ^R
Query Name.... Research=Portfolio
View........................ Data.Sheet
Data Mode........... Edit

Could we please receive advice on why this query does not open?

Thank you,
Nicole
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:18
Joined
Oct 29, 2018
Messages
21,358
What is the name of the macro?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 12:18
Joined
Feb 28, 2001
Messages
26,999
First question would be whether the query can be opened manually through the navigation panel.

Second question is whether that is an equals-sign in the query name, because Access doesn't like special characters in names. If that IS "=" as part of the name, try removing it and instead use a name like ResearchPortfolio or Research_Portfolio.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 17:18
Joined
Feb 19, 2013
Messages
16,553
suspect Data.Sheet is not correct either - would expect Datasheet
 

Users who are viewing this thread

Top Bottom