I am inserting rows from other tables into a table that has various constraints/indexes. When one of them is violated (say trying to put a null value into a...

I am wondering if someone can give me an elegant solution regarding importing data. I am getting daily CVS files that I would like to import into Access 2000....

Hello- I'm creating a Book database and im having some trouble. I have one table that stores the book's information called tblBooks. One field in this...

I have a table of data that I am importing in from another software program (Creative Solutions - Go System). The other program is an accounting trial balance...

I would like to have the ability for (lets use the number 3 for example) three employees to enter data into their own spreadsheet or database. I would like...

Hi there - would be grateful if someone can advise I havent worked in access in a long time and I have forgotten more than I know!, i'm trying to create a...

Fairly new to this.... Is there anyone who has templates for creating a knowledge base or an issues log? It's a huge systems implementation, and the project...

How would I input in a field a formula that automatically counts the number of say yesses in the previous fields of the same table? What I'm...

Hi. Im using Access 2002 on XP, in a multi user networked environment. I have a db which Im being asked to change for a slightly different use but by the...

I use Access 2000 on my pc but now need it on my pda. Is this possible ---------------- This post is a suggestion for Microsoft, and Microsoft responds to...

I have a database of over 200 records in ACCESS. I need to audit 30 records at random. Is there a program that can help me with that tasks.

I have a split database (Access 2002) with the data tables in a server-based back-end and a bunch of pre-defined reports in the front-end (MDE). I have a lot...

I am new to access and am trying to develop a returned check database for my business. I have three table that I am trying to link together so that I am also...

Please help! Working on an Access 97 database that I have inherited, on win 2000. The database is converted into an .mde file for the users. I need to...

I have a database with front end and back end. The backend contains many tables with just two fields one of which is a memo field the other a text field. The...

Anyone have a template designed in Access to list what employees will be working in the future? I need a calendar type report to list employees and hours for...

Hello there, Teaching myself access and have some design questions. I'm trying to design a payroll type database. The pay period closes on the 5th and 20th of...

I would like to print selective information about a table. Will this utility or another like it print selective info? Where can I download this? Thanks Dave

I'm creating a table with a field call tracking but the data type not allowing me to customize that field. I like to see this automaticly every time a new...

Have backend on server. Frontend copied to 10 clients. Worked fine until ... I copied an updated frontend to the clients. Somehow, the links to the backend...