I have inherited a database that has a list of image files in the database but the actual files are located in various places on 3 different network drives, I...

I don't know access that well to be honest. I am trying to extract some data from an access 97 database. It contains 11 tables. I have gone through all the...

Can someone explain exactly what happens when I create a linked table inside a ADP project? The wizard's help text isn't very clear, and I can't find much more...

I would like to know, if it's possible, how to calculate the range between dates but not including the holidays. Like the "networkdays" formula in...

I have two different forms, each has the same set of controls for entering payment information. One control is an option box to select payment method - cash,...

Dear all, Can anyone help me to set up the input mask for my text field? This field could be 123.99, or V12.45, or 123.2. My point is : the length of this...

I want to set a default date field as follows. Get todays date - Date() Convert it to Day of the Week Add number of days that would change Todays date to...

I have a Access Query that will be calling a SQL Server store procedure that has two parameters. I have the SQL (exec p_get_sla @sd, @ed ;) to call the store...

I am using Microsoft Office Professional at home. There are critical updates needing to be downloaded but because of my slow dial up which is all that...

If anyone can help with this I would be very grateful. When I right-click an icon on desktop (ms word / notepad item) and 'send to' .... the option to send it...

Dear Colleagues, I want to open a file from an Acess form using the registered default Windows application, just as if I were to double-click on the file...

I get the error message "Application-defined or object-defined error" in Access 2000 SP-3 whenever I attempt Tools/Analyze/Documenter/Options. The error...

I used SHAddToRecentDocs(2, installpath & myfile) to add myfile to Recent documents. Then I used the following loop to Wait for the SHAddToRecentDocs to...

what are the secret code to make free calls

I just started to use mysql as the back end and I was just wondering how it is different from using access as a backend. Some of the querys that I wrote in...

Hi When I try to run access 97 I get the message 'Microsoft Access couldn't find file c:\windows\system32\system.mdw'. When I try to create the system.mdw...

Each month, I create a table and corresponding query which summarizes every item (quantity, sales, cost, etc.) sold to every customer. Is there a way that I...

Hello, I am developing a small database using Access 2000 for non MS Access users. My problem is when the user open the database via a icon on the desktop...

I have noticed 3 occurences of a system file named SYSTEM.MDW in the following 3 locations on my system (Win 2000 and Access 2003). C:\Documents and...

A database has a form with a complex recordsource. When one tries to open the form, the message "Can not open any more databases" appears. The database is a...