I'm using a mixture between access and visual basic to create a program, that allows users to enter data into a visual basic program and it sends the data through that program into an access database and then onto another program that the it administration can look at to see what needs to be done and what requests we have from users.
It works on both my computer and the other administrators computer but when i try to open it from a users computer it comes up with a run time error 91 object variable or With block variable not set.
The whole program works, we have tryed it between the two admin computers and it works perfectly except for the runtime error when i open the program from any other computer.
i have pinpointed it to the line of code that adds a new column to the database when the program first opens.
- adodc1.recordset.addnew
it is creating a new line in the access database so users can enter the data, does anyone know how to fix it.
if anyone knows that would be great.
thanks...
It works on both my computer and the other administrators computer but when i try to open it from a users computer it comes up with a run time error 91 object variable or With block variable not set.
The whole program works, we have tryed it between the two admin computers and it works perfectly except for the runtime error when i open the program from any other computer.
i have pinpointed it to the line of code that adds a new column to the database when the program first opens.
- adodc1.recordset.addnew
it is creating a new line in the access database so users can enter the data, does anyone know how to fix it.
if anyone knows that would be great.
thanks...