The following is code I used in a previous Access 97 app to add a new record to a table. When I put this code into my Access 2000 app it fails with the error: "Compile error: User defined type not defined".
Anyway here is my 97 code, if anyone could translate this into 2000 code...
I need some way of clearing all of the data from a table in my database.
What I have is a time collection system which needs to have it's collection table cleared every time the merging program is run. I am using ADO with an ODBC source called "TCMerge".
Here is my current code...
Thanks for the help, however another user already told me my problem. I just had the wrong syntax. The above looks like it will work so if I have anymore problems I'll try that. Thanks again.
Cyb.
In my project there is a subform that needs to have it's RecordSource updated dynamically through code.
When the user changes the record on the main form, I want the subform to be updated to match the mainform. In order to do this I have to change the subform's RecordSource(Could also use...
In my project there is a subform that needs to have it's RecordSource updated dynamically through code.
When the user changes the record on the main form, I want the subform to be updated to match the mainform. In order to do this I have to change the subform's RecordSource(Could also use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.