Macros & Forms

[Tecora]

what I am trying to do is...
a macro was already created to import some information from paradox. Then a report is ran to print out some tags. What I am doing is creating a form that has 3 buttons on it one to call the macro, one to call the report to print the tags and of coarse the exit button. The macro was set up to delete the object and recreate it and populate it with new records. If I don't have it delete the object it will continue to create a new table (venttags1 , venttags2 etc each time I run it) then the report will not work because it is looking for the venttags table. So when I run it with the delete object it will give the an error that the table is locked. Whole story nothing but the truth!!!! Can anyone help?

 

[boblarson]

Have you set the form's Recordsource property to the table in question? If so, you can't delete a table when the form is opened as it is "using" the table at the time.

If all the form has is the buttons, then make sure to clear the Record Source property (forms don't always have to have a record source).

BL
hth

 

[Tecora]

thanks for your help. The problem was I was trying to display the current run number from the file so the file was locked by my program. I had to create another form that was called by a command button to show the run number currently in the table. By doing that the table was not locked when I ran the macro. I really appreciate everyone's help.