I would be very grateful for any help anyone can give me. I am really struggling to make it work.
I have a textbox with a filename in it on a form and when I click abutton I want to transfer the file name to an import statement and import the file.
However I am unable to assign the sting in the textbox to a variable.
What I have been doing is
public filename as string
filename = [Forms]![run query]![TexT_startdate]
DoCmd.TransferDatabase acImport, "dBase IV", "p:\infdata\foxpro\" & filename & ", acTable, "", , False"
When I try and assign the string to a variable (the part in red) i get the error message:
object or class does not support the set of events
Any help would be wonderful. Many thanks, Juliet