A
alex
Hello,
Using Access ‘03
I’m trying to run the following VBA statement:
Dim strTable As String
strTable = InputBox("What's your table called?”)
DoCmd.RunSQL "alter table" & strTable & "add RecordID Counter"
I keep getting a syntax error, however. It has something to do with
strTable. When I change strTable to an actual table name, it works
fine.
Thanks,
alex
Using Access ‘03
I’m trying to run the following VBA statement:
Dim strTable As String
strTable = InputBox("What's your table called?”)
DoCmd.RunSQL "alter table" & strTable & "add RecordID Counter"
I keep getting a syntax error, however. It has something to do with
strTable. When I change strTable to an actual table name, it works
fine.
Thanks,
alex