Recent content by tekila

Oh, I didn't know that copying tables only does the same amount of work as copying the entire database. So you mean tables occupy similar file size as the database and the copying of tables take just as long as that for the database? What you're currently working on seems relevant to my...

Junior, what if I only want to do a auto backup on the tables since only data in the tables are updated everytime, possible? So whenever someone closes the database, only the tables will be copied over to the auto backup database that contains tables only. I'm afraid when the database grows to...

When I do a search on the file that I exported, it's not found at all.

My PC is running on Windows NT 4 and I'm using Access 97. I've installed snapshot viewer and I'm able to export almost all of my reports in snapshot format, except for weekly and monthly reports. I carried out the same procedure when exporting weekly and monthly reports but at the end of it, the...

Huh, can't you be more specific cos I don't get what you mean. Thanks.

What is the function used to find the mode (highest frequency) of a field in the report?

I guess that's what I want. So how can I go about doing that?

Well, this was what I included in the code instead:] ************************************************************If Not objScript.FolderExists(strActivePath) Then MsgBox "Active Path specified is invalid." & Chr(13) & "Please check and try again.", vbCritical +...

I've a custom backup form with three textboxes; ActivePath (Path of current DB), BckupPath (Path of Backup DB) and Name (An optional field if user wants to include a name to the folder of the backup DB, else saved as default name). There are two identical browse buttons next to the textboxes...

4: i would keep that in the same place that you're sharing the database from, then reference it in the users pc, or in the shortcut to open the database... Do you mean assigning the path of the workgroup files to where I store the database (shared drive on the network)? 6: The record source of...

Junior, I've been encountering many problems when I carried out the pilot run of my DMS. 1. #Name? appears on forms and reports for date field (on certain PCs but not all, a particular one runs on NT). 2. Only data in the report headers are displayed when reports are emailed to recipients...

What I mean is retain the graphics on the form template but change the background colour.

When I email a snapshot report to a recipient, working on Win98, only data on the report header is shown, the rest of it is missing. This is not a problem for WinNT. Why?

Oh yah, it should be Locatn instead of location, thanks for the advice.

I received a compile error: method or data member not found for .RowSource