access format problems on different computer 2

[dan26]

I developed a database on one computer, them moved it to another. Both have Access 97. I created a report which sorted the data by date. The date is pritned with the MMMM YYY format. On the "2nd" computer when I run the report I get a box on the screen that says "format" and then wants me to enter data. When I hit cancel on the box my report comes up but the month/year do not appear. Any ideas?

Thanks

 

[mwa]

Somewhere in your report you have a field or function or something called "format" that Access does not understand. It thinks that "format is a parameter that you are wanting to enter into the report. This is why you are getting the input box. I bet if you enter something (anything) into the input box your report will run and whatever you entered will show up on your report. To fix, Check the formatting that you have for the date field and see if there is something that says "format". This is where your problem will be... Hope that helps...

 

[dan26]

Thanks for trying but I don't think thats right. It runs perfectly on the original computer so it has to be something missing in the other installations.

 

[DonQuichote]

There might be broken references on the other computer. In this case NO references will run if they are not specifically mentioned. Therefore, the function Format() will not run, but VBA.Format() will. During startup, check all your references and mend the broken one. And be sure to state the library in the mending routine...

There's a nasty thing if your database runs on a network. In this case, a broken reference for computer "A" will cause the reference to be annotated as broken, so that on computer "B" it will not run either anymore, though the reference exists on computer "B". All the more reason for a mending routine.

Good luck

 

[dan26]

Thanks for the advice. Sorry for the rookie question, but how do I check and mend the references?

 

[DonQuichote]

just step through the references collection in your starup procedure. Each reference has an isBroken method. Search for References in the help file.

Best regards

 

[mfd777]

Following on from DonQuichotes' quote, you may be simply missing a reference in computer B. To fix this, open any module (or code in a form). Now click on tools --> references. If any are expected and are missing the work "MISSING" will prefix the offending reference. Click on this control and at the bottom of the window, access will show you the file name it is expecting. If this file is not on computer B then copy it from computer A. One thing to watch out for is when you have copied the file to the required directory, you need to click on browse in this window and select the file. The file may not be immediately visible as the explorer window may filter it out if the extension differs to the default (OLB, TLB, DLL) - it may be an OCX you are missing.