macros

[Tecora]

how do you call a macros that is already created from a form using a command button. I continue to get a message that the table is locked and it will not run the macro. The macro runs fine when I go into macros.

 

[Tecora]

I am not sure I understand what you mean. I am new to access and macros etc. After I run the macro I run a report(that creates tags for the shop floor).

 

[David R]

You can create a duplicate query to the one you've got now, just name it something different. Use one as the basis for your form and the other to run your report/macro.

David R

 

[Tecora]

huh? I am not sure what you mean by that the set up that is. I want the macro to delete the object and recreate it every time that is what is causing the problem

 

[David R]

Are you trying to empty out a table? You're not really giving us enough information to help you effectively.

David R

 

[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!!!!

 

[David R]

I don't use Macros, but if you post your problem in the Macros forum with what you're using currently, I'll bet someone will be able to help you make a smoother running setup.

Good luck,
David R

 

[Tecora]

Thanks!