Search results for query: *

Thanks, I have added the .Close statements and I'm still having the same problem.

I put the wrong error in my message, by the way. It was actually 7866, "Microsoft Access can't open the database because it is missing, or opened exclusively by another user." This database is on my C drive so I'm the only user and I do have the path and file name correct. The error occurs at...

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

Thanks, that should work unless someone has a better suggestion.

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?

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

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

Based on my research, here are the limitations of using Terry Kreft's custom mouse pointer functions to change the mouse pointer to a hand (see the code I posted earlier). The MouseCursor function does not work reliably in Windows 95 or Windows NT 4.0. It does apparently work in Windows 98 and...

I think you are right, vbajock. I tried it in Windows 2000 and it worked as expected, but it failed on Windows 95. Could someone test it in Windows 98, ME, and XP? All you need to do is put the code in a standard module and add the following to the MouseMove event of a text box...

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

That worked! Thanks

Now when I compile, it gives me the message, "property (Orderby) not found," which is what I had been getting before everytime I tried to change this property. It seems that Access is not making the property available to VBA.

When I compile this code, I get the message "user defined type not defined" with this line highlighted: Dim tbl As DAO.Table

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

Access 97 won't let you import an object from Access 2000

If anything changed, it would have been minor, for example, changing the spelling of a field name.

I did run Compact and Repair and yes I can import Main Table into another database.

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

Paul, I think you've got the answer. Based on responses I've gotten from other forums, no properties that are set programmatically in the form view can be permanently saved. However you can save properties that are programmatically set in the design view. I'm surprised that this important...

I have also tried to programmatically set the value of the tag property of an unbound text box using VBA. I then click the Save button to save the design of the form. When I reopen the form, tag is blank.