Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jmacmicking

    Microsoft Excel Template Question

    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.
  2. jmacmicking

    Lost In Access Dilemma

    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...
  3. jmacmicking

    Running batch file from VB

    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...
  4. jmacmicking

    Lost In Access Dilemma

    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...
  5. jmacmicking

    Refer to control on another form

    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...
  6. jmacmicking

    VBA (Word): Command to close document and cancel all future code?

    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

Part and Inventory Search

Back
Top