Search results for query: *

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

I've two fields in a form; Test and Location that are both combo boxes. The row source type of Test is a value list; FCT and ICT. The locations for FCT and ICT are stored in separate tables (FCT Locations and ICT Locations). How can I make the row source type of Location refer to the particular...

How can I change the background colour of Access97 form template? It is a wmf file.

I've completed custom backup and restore database facilities but encountered a minor problem. When I do a backup, I kill strTarget&"*.ldb". If I restore the backup and auto backup module does a backup of this restored database (which is a backup), there isn't...

On my main switchboard, OnClick of a particular button displays the database window. I was thinking whether it is possible to deny user access to viewing the database window and at the same time grant him permissions to insert, delete and edit the data in the table, bound to the form. In this...

I don't quite get what you mean but what I did was to use a list box instead of a subform. In this way, whatever I do to the list box has no effect on the main form. Can't think of a better solution...