It seemed as though this worked! Thanks a million you saved me hours of aggravation. Just as a note to anyone else who may be encounting this problem I changed the above suggestion a bit just to work properly in my code. Thanks again!
Code:
Dim myCMDStr As String
myCMDStr = "INSERT INTO [" & userCircuit & "-" & userStart & "," & userEnd & "] ([Cable_Start])VALUES(Cable_Start)"
Hi, I am writing a program to accept multiple user inputs and put these values into a table. This database will end up having hundreds of tables, each table should have the user inputted data.
I have created the table and set the fields to their propper values. The problem I encounter is when I try to input the user data (stored in my global variables userStart, userEnd, userCircuit etc etc) into the proper fields. Here is what I have....
Leave a comment: