wabtrainer
IS-IT--Management
Is there any reason why I am getting this error now when it has worked before????
All I am doing is copying a table in the current database.
For example I have Parts table which when altered the user clicks a button to save it with a different name.
Heres the code:
newname = InputBox("Enter a name for the Parts list")
'***************************************************
'Keep a list of names
'add newname to list
'***************************************************
sqlstr = "INSERT INTO tblPartsListNames (TableName) " _
& "VALUES ( '" & newname & "') "
DoCmd.RunSQL (sqlstr)
DoCmd.CopyObject , newname, acTable, "Parts"
It has worked before but for some reason
If you want to be a bear:
Be a Grizzly!
All I am doing is copying a table in the current database.
For example I have Parts table which when altered the user clicks a button to save it with a different name.
Heres the code:
newname = InputBox("Enter a name for the Parts list")
'***************************************************
'Keep a list of names
'add newname to list
'***************************************************
sqlstr = "INSERT INTO tblPartsListNames (TableName) " _
& "VALUES ( '" & newname & "') "
DoCmd.RunSQL (sqlstr)
DoCmd.CopyObject , newname, acTable, "Parts"
It has worked before but for some reason
If you want to be a bear:
Be a Grizzly!