trying to copy a query?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
G

Geoff Cox

Hello,

My PC recently re-booted itself whilst Access 2003 was open and I seem
to have lost some queries.

When I try to copy a query and then paste it back with another name
(so that I can change it so that it works for a slightly different set
of dates) I get a message telling me that "the name you entered
already exists for another object of the same type in this database
etc".

As far as I can see no such object exists!!

Any ideas please?

Cheers

Geoff

PS incidentally is there any way in which I can import a query from a
backup version of the database?
 
Hello,

My PC recently re-booted itself whilst Access 2003 was open and I seem
to have lost some queries.

When I try to copy a query and then paste it back with another name
(so that I can change it so that it works for a slightly different set
of dates) I get a message telling me that "the name you entered
already exists for another object of the same type in this database
etc".

As far as I can see no such object exists!!

Any ideas please?

Cheers

Geoff

PS incidentally is there any way in which I can import a query from a
backup version of the database?
Click to expand...

Are you sure the query(s) that seems lost is not just hidden?
Click on Tools + Options + View
Place a check mark in the Show Hidden Objects box.

To import a query from your back-up:
Click on File + Get Extnernal Data + Import
Navigate to your back-up database.
Select the query(s) you want to import.
Click OK

If you still can't re-name or import the query then use VBA to delete
the query (even if you can't see it).
DoCmd.DeleteObject acQuery, "QueryName"
Then re-import it as above.
 
Are you sure the query(s) that seems lost is not just hidden?
Click on Tools + Options + View
Place a check mark in the Show Hidden Objects box.
Click to expand...

Hello,

Thanks for the suggestion. In fact ticking show "hidden" didn't do it
but ticking "system objects" did!
To import a query from your back-up:
Click on File + Get Extnernal Data + Import
Navigate to your back-up database.
Select the query(s) you want to import.
Click OK
Click to expand...

I will try that out.
If you still can't re-name or import the query then use VBA to delete
the query (even if you can't see it).
DoCmd.DeleteObject acQuery, "QueryName"
Then re-import it as above.
Click to expand...

Thanks again for the help.

Cheers

Geoff
 
Back
Top