export access qry to another database with filepath from text box

[gdesreu]

Hi guys,

I am trying to export an access query as a table in another database. The table name and query names are static but the filepath is dynamic. I would like to derive the filepath from a textbox on a form. So if you hardcode the path below where it says "TXTBOX FILEPATH" it works fine but if I try to insert the textbox value I get invalid qualifier compile error.

DoCmd.TransferDatabase acExport, "Microsoft Access", "TXTBOX FILEPATH", acTable, "Sdata", "sloc", False

Here is what I tried:

Private Sub Command59_Click()
Dim destination As String
destination = ([Forms]![frm_append]![Text57])
DoCmd.TransferDatabase acExport, "Microsoft Access", (destination), acTable, "GIS data locations - soil", "soilloc", False
End Sub

Any ideas as to what I obviously did wrong?
Thanks

 

[GinaWhipp]

Try removing the parenthesis, after all it is a variable, so, it should be fine.

 

[gdesreu]

Try removing the parenthesis, after all it is a variable, so, it should be fine.

Thanks Gina, I had tried that previously but it didn't work. I was having some odd Access behavior at the time. After rebooting and installing all of the MS updates, it works fine now without the parenthesis as you stated. Thanks!

 

[GinaWhipp]

*Odd behavior* never good. If it's just that application suggest bringing all Objects into a clean database. If Access on the whole then the updates probably fixed it...