Copy a query and give a new name

[Ianw]

I have Access 2010 and I have a query that I want to take a copy of, save as and call it call it something else in the same database.



For example "query1" I want to save as and call it "query2" does anyone know the VBA code for this.
I have searches the forum but cannot find anything on this.


Thanks

Ian

[orange]

Do some basic testing/experimenting.

1. Go to the list of queries
2. Copy a query
3. click or point anywhere and select Paste
4. It will give you a new query called Copy of XXXXX where XXXXX is the name of the query you copied.
5. Change the name to whatever you want.

[Ianw]

Thanks for the answer orange. However, I am trying to do this programatically. Per the help you have me the other day I have managed to figure out how to change the parameters programatically in the passthrough query I have.

I am looking to have a control button so that when I click on it it will take a copy of the query and call it something else. The macro I have will then change the parameter in the new query and then kick everything off automatically. The bit I am missing is this piece where I can programatically copy and paste the query rather than the simple manual process you have suggested.

Thanks



FYI, I do appreciate your help on the parameter issue.

[orange]

I wasn't aware that this was a follow on post. It just seemed a little out of the blue with no related attempts/thoughts on approach.
Anyway, I don't use macros. In vba you could copy the sql of a query, and run it without saving it under a new name.
Or you could create a new querydef and save it. see this sample There are others search createQuerydef MsAccess

Happy to help.

[Ianw]

ok. got it. I did create a new QueryDef and it works a treat.

Public Sub Mytest2()
Dim qdf As QueryDef
Dim Posit As String
Dim dbs As Database
    Set dbs = CurrentDb
    Set qdf = dbs.QueryDefs("qryMainACCUMTest")
    DoCmd.CopyObject , "qryMainACCUMTestParam", acQuery, "qryMainACCUMTest"
End Sub

I'm slowly but surely figuring this out. Thanks again for your help.

[orange]

Did you install Access 64 bit on purpose?

Read this thread.

[Ianw]

No. Access 64 bit came with the PC.

[orange]

Ok. Others have access 64 bit. It's just, as you have probably read, that it offers little to nothing for Access.
I think the 64 and 32 bit versions come on the same CD/DVD. That's what I've read.