database form
I used microsoft access 2003 to create a simple database to track asset destruction. I would like to create either an application or a web based form that will allow my employees to fill out, submit, and update the database without having to manually update it. What is the easiest way I can go about [...]

Answer Question   |  August 8, 2008  1:41 PM
Access 2003, Microsoft Access

Highlight Keywords in Access 2003 Forms
I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?

Answer Question   |  August 7, 2008  1:20 AM
Access 2003, Database programming, Microsoft Access

MS Access DB – Query
I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can’t get the report to work the way that i want it to. I need the report to pull the record that i just entered via [...]

Answer Question   |  August 5, 2008  6:23 PM
Access 2003, Microsoft Access, Query

Access 2003 – adding values to a specific record via a query
i have a situation where i have a table whose fields are : -Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates) -value of payment: the monetary value of the payment that has to be paid at that date -Paid: here i enter [...]

Answer Question   |  July 24, 2008  11:45 AM
Access 2003, Database programming, Microsoft Access

Refusal to recognize SQL Server 2005 Express on a client PC
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that [...]

Answer Question   |  July 8, 2008  3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express

limit number of users in access 2003
I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn’t lock up the application and not populate the look up table…I inherited this application

Answer Question   |  June 16, 2008  2:08 PM
Access 2000, Access 2003

MDE to updating table in backend database
I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won’t write to the backend database.

Answer Question   |  June 27, 2008  12:29 PM
.MDE files, Access 2003, Database conversion, Microsoft Access

Microsoft 2003 Access relationship window
The relationships window is displayed, and you notice that one of the tables has two feilds shownin bold. What does this mean?

Answer Question   |  July 8, 2009  2:05 PM
Access 2003, Microsoft Access, Relationship window

Access Report Page Setup Won’t Save
I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC’s that it works on. Has anyone had this problem and found [...]

Answer Question   |  April 10, 2008  7:25 PM
Access 2003, Microsoft Access