Replies

I’d check the report in design view and see how long the REPORT FOOTER section is and try shortening it. Sounds like a formating problem to me.

It sounds like a Anti Virus program performing a preset drive check and you might look at your settings.

You may want to look at the ACCESS MVP website and use the code posted there by Dev Asish.

Dim strDocName As String
Dim strWhere As String
strDocName = “rptSomeReport”
strWhere = “[RunID]=” & me!RunID
DoCmd.OpenReport strDocName, acPreview, , strWhere

This prints only the current record.

If you are concerned with the possibity of a script attachment or an executable that could be a virus, you may want to consider changing the default click behavior on .vbs and .exe files from OPEN to EDIT. This can be done in Explorer/View/FolderOptions/FileTypes. By going in here the behavior of the mouse click can be changed by choosing EDIT and what will happen is that the e-mail attachment will merely open in NOTEPAD and if it was destructive it would never unleash its load on your system. This is a way of side-stepping a virus.

Hope this helps.

dj,

If you have a spare keyboard you might want to try using it and see if the problem re-occurs. It could be a worn-out keypad problem. The mouse cord should be away from other electic goodies.

Hope this helps!

I thought I’d throw in my 2 cents worth:

Try unseating the sound card from its slot and re-seating it a couple of times to clear out any corrosion, etc. that may be creating static. You may even try running without the card to see if it still occurs. If you have a back-up sound card see if it still happens. I’d even check the wire connections on the sound card to the speakers as well.

Hope you find it!

I’d leave it checked, based on a right-click to get more info. This locks only one record at a time.

I’d do a repair/compact at this point and see if that doesn’t clear it up. You may have to create a new blank database and import your tables and start fresh.

Check out the options available by going to TOOLS/OPTIONS/ADVANCED and selecting the record-locking strategy that is suited to your environment. You might try NO LOCKS or EDITED RECORD; BE CAREFUL. You will have to adjust each machine. Examine the ODBC settings as well.
I went through this and found that making an entry for for new data which is “blank”, i.e. set for data entry in the design properties, works best because the set of records is not loaded into the form when opened.
Hope this Helps.

You might try opening up the report(s)in design view and for a title use an existing field from the query or table from which the report gets its data. Something like a text box you could create in the report header that would have its date source set to =”Report”&” “&”ON”&” “&[CompanyNameField].

Hope this helps.

I would suggest looking at the report in design mode and examining the possibilities under “SORTING/GROUPING” and set the grouping for the field in question to keep together on one page.

Hope this helps.

Open up each form, report, and query in DESIGN VIEW and change the data source to the newly imported tables paying careful attention to the names as they are assigned.

I would suggest you use the Report Wizard and try as many types as you need to in order to get the result.

I searched the MS KB and I found the following articles that may help: Q251787 AND Q235300.

Apparently a corrupted .dll file.

Hope this helps!

You may want to try compacting your folder(s). Under FILE,
FOLDER, COMPACT.

Hope this helps.