Search results

This is a complete mystery. I have a database that fails to work anymore when I do a Compact and Repair on it. I can see that the database size is smaller, but when I try to open it, it just comes up to the general Access 2007 screen. The database absolutely will not open. Any ideas whatsoever?

Well, good lord, that was easy! Boy, did I make this thing harder than it needed to be. Thanks for all your help.

It is a spellcheck routine I got off the web. It consists of 4 tables and 2 forms. It is called MS Access Spell Checker.

But does a Call command not go to the function being called and complete that function before returning to the calling function?

I have a form that I am using to send emails to our maintenance department when a work order is written. I want my code to automatically spell check a field on the form before it sends the email. I have the call to the spellcheck function on the buttonclick event, but it does not allow it to...

These are two separate databases. One is written in the older version. The reason I can't convert it to 2007 is because Access Runtime doesn't allow mail merges. This person has the full version of Access 2002 on her machine to run the older database. She also has the Access 2007 Runtime...

Further explanation of the problem. We have a database in Access 2002 (2000) format that was getting the above error. I put the Access 12 Object Library in the references and it seemed to solve the problem for that database. However, we also have an Access 2007 database (runtime only) that...

I can't convert it to 2007 because the people who use it do not have 2007 on their machines. I can open it in 2007 without any problems, but when I try to open it with the older version, I get the errors. It appears to attach the Access 12 object library to the references. How do I open it...

I am getting the following error when I try to open a database created in an older version of Access: "The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events." This database is in the Access 2000 format...

Thank you very much for your help.

I'm not quite sure I understand where this code is supposed to go: Function nnz(testvalue As Variant) As Variant 'Not Numeric return zero If Not (IsNumeric(testvalue)) Then nnz = 0 Else nnz = testvalue End If End Function Does it go on the "On Current" event of my...

I have a field on my main form that shows a total of a field on a subform. If there are no subform records, how do I keep the main form field from showing #Error? Any help would be greatly appreciated.

Is there a way to count different fields in one query? For instance, I have a query that counts the number of pending work orders, but I also want to know how many of those pending are one day old, two days old, etc.

That hit the spot. Thanks.

I have a cancel button on my form that displays a message box if the user presses it. I do not want it to display the message box if there have been no changes made to the form, only if changes have been made. If there are no changes, I just want the form to close. Is there a way to check the...

Is your bound column correct? If your bound column is not the same as the column being displayed, that may cause the problem.

Is there any way to avoid the following error when opening older databases with Access 2007: The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events.

No. It won't open at all.

I just did a compact and repair on a database and though everything looks normal, when I try to open the database, it just comes up to the general Microsoft Access screen (the one when you just open Access). The database is showing that it is 30.2 MB, but it will not open. Any ideas?

Well, that was simple enough. I should have known that. Thanks for your quick response.