Replies

Sandy, your problem is one that I have had often. It is caused by a missing reference. To fix, open a code window, click on Tools, click on References. There should be an item in the list identified as “Missing something”. Just uncheck it, close the References dialog, close the code window, and open a form or report that has Date() in it. (sounds like you may have to revise to replace a Now() with a Date().) This should help you.

Thanks, Charlotte. I like the macros. One question, do you ever sleep?

I gave you the syntax for Access 97. I should have said that first. But, it should work in 2000. Give it a try and let me know how it comes out. And, you are welcome.

I am sorry to disagree with Charlotte, but I have found a macro to be a good way to open a specific document in Excel or Word. The key is to write the command line in the RunApp action. You have to type in the specific path to Excel.exe. You have to insert a space. Then you have to type in the specific path to the Excel file.

Example:

c:Program FilesMicrosoft OfficeOfficeExcel.exe c:MyDocumentsExcelFilesMyExcelFile.xls

You can even run a macro located in your Excel file by adding a switch at the end of the Command line.

Example:

c:Program FilesMicrosoft OfficeOfficeExcel.exe c:MyDocumentsExcelFilesMyExcelFile.xls /mMacroName.

It does work.

(Sorry Charlotte)

That was it. You are a genius. I opened the Hosts file, deleted the Google line, typed http://www.google.com in the address box and, viola, Google opened. Thank you so much.

DrkRealm, I had to wait to get home to try it. The link on your response did not work. I get a “Page cannot be displayed” message. It is as if my computer blocks the Google URL.

Yes, Kenny. Look in Help for Refresh, Requery and Repaint. You place them before the End Sub. It would look something like this:

corwww = www
Me.Refresh
Me.Repaint
End Sub

You may have to play with it a little, but it should work. (Of course, Charlotte probably has a better way. )

You could just delete the table completely and do the import again.

Have you checked if the other user is opening the database in exclusive mode?

Andy, I really don’t know how to help you, but I have a similar problem at work. We have about 1,000 users. What I do is to walk over to the network administrators (we use Novell) and he shuts people off when they have left the database open and they are not at work. The network guys also can send a network alert to tell people important information, such as “We are closing the database for a while. Please log off!”

Do you have a similar system? If you don’t, you may not be able to do what you would like.

Hey. I had a ticking sound once. It was caused by a bad power supply. You probably don’t have this problem since your other drive works OK. But, it might not be a bad idea to have it checked, maybe.

Gail, if it works on one report and doesn’t on the other, then the reports must have different properties. Compare both reports, at the properties level, to see what the difference is. Also, do as Brian suggests and see if the CanGrow property is turned on in the report that doesn’t work.

Hi, Judy.

You could try what is discussed in a thread a few pages back called “Like statement”. (If I knew how to make this a link I would. Could someone let me know? ) I am not sure that this would work in .FindFirst. You would have to play with it a little to see if it would.

HTH

Could you explain a little more clearly what you are wanting to do?

It could be as simple as a parameter query that asks for a state, if I understand your question.