When you create the original macro create it in a seperate file; then set the autoopen event to run that macro. This will give you one spot where you can make all of your changes.
It would probably be easier to link to the DBase database directly inside of Access; I know you can like to tables in DBase III using Access 2000. Since the table(s) is/are linked Access will automatically stay synchronized with the original DBase data. If you need the data in a different...
I've had the same problem in the past with Windows 2000; try the exact same program in Win9x and you should have no problem. I still haven't anything (not even in MS TechNET) that mentions it though. I have heard some people say they have gotten it to work by using the ShellExecute API...
Assuming you just need the data on the table deleted you could use a macro to run delete query without a WHERE clause to delete the table, run your macro, run a delete query with a WHERE isnull([your fieldname]) clause and then exit Access using a RunCommand(Exit) action in the macro.
Creating...
There are two ways to do this; either use a public variable and set it's value based on the checkbox on the earlier form or refer to the checkbox using the form name.
To create a public variable just declare it in the Declarations section of your main form using "PUBLIC" instead of...
If I'm not mistaken you can just use "End" by itself to terminate all code execution. Your code for the Close button would look like this:
Private Sub cmdClose_Click()
Unload Me
ActiveDocument.Close
End
End Sub
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.