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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: MackC
  • Content: Threads
  • Order by date
  1. MackC

    Cannot use automation after CreateWorkspace (Access 2000)

    am trying to use VBA to delete a form from a series of databases. Some databases are secured (the Admins user, Superv, is the owner) and some are not. I first determine if Superv is the owner of the database by opening it as Superv using CreateWorkspace. If Superv is the owner, I use DOA to give...
  2. MackC

    Is control source a formula (Access 2000)

    I have a form that is based on a query, which includes some formulas. How would I programmatically determine if the control source of a control is a formula in the query as opposed to a field in the query?
  3. MackC

    ActiveForm in function called by On Current (Access 2000)

    I'm having a problem with a function that is called from the On Current event of several different forms. The purpose of the function is to record the ID number of each record, so that I have this value available to use in an audit trail program when I delete a record. This is the code: Function...
  4. MackC

    Call a function from Before Del Confirm event? (Access 2000)

    Is there any way to call a function from the Before Delete Confirm and After Delete Confirm events of a form using the standard arguments, for example, BeforeDelConfirm: =SuppressDelConfirm(Cancel, Response) or can you only use event procedures with these events? The is the function (in a...
  5. MackC

    Change pointer to hand without hyperlink

    I am trying to use the following custom mouse pointer code posted on the "Access Web" web site. I want to call the MouseCursor function from the MouseMove event of a text box to display a hand pointer when the mouse moves over the text box. I don?t want to use the PointM function...
  6. MackC

    Set OrderBy property of a table using VBA?

    Is there any way to set the OrderBy property of a table using VBA?
  7. MackC

    Error converting database to Access 97

    I have Access 2000/SR1. When I try to convert my database to Access 97, I get the following error: "The Microsoft Jet database could not find the object 'Main Table'. Make sure the object exists and that you spell its name and the path name correctly." I have converted this...
  8. MackC

    Tag property value set with a macro not saved

    When I use the SetValue action in a macro to set the value of the tag property of a text box on a form, the value in tag is not saved when I save the form. The macro is triggered by clicking a button. When I reopen the form, tag is blank. I have not tried doing this with VBA, but I assume the...

Part and Inventory Search

Back
Top