I have the suspition that only in Access XP the following message appears. I created the file in Access 2000 and when I was using access 2000 was fine. After I...

Hi, I'm trying to figure this one out and was wondering if there were any best practices I should be looking at I have a typical Domain relationship, e.g....

Hey Guys, I am trying to create a schedule database for employee that do their jobs based on a 30 minutes blocks. example employeeA starts shift at 9:00 AM and...

Check the permissions on the Share, not just the folder. Sometimes the Share permission will downgrade the folder permission. -- Doug Steele, Microsoft...

I have created a database using Access 2000 but what I want to do is create a main page, so when you open up the database, the first thing you see is a page...

I have a database set up to handle various administration tasks. Many of these systems require employees to be selected. For instance, on a purchase order, the...

I designed my database, did some testing and it has been working fine. My manager would like to have the database open to everyone in the department. This will...

Need help with the relationships now. If you can help me set up the first set, I'm sure I can set the rest up. Have the following: tblEmployees EmployeeID...

The solution to my last problem was to use an Append Query. This has worked for most of the tables I wanted to add to my BIGTable. However, several tables...

Hello, Bad design, I know, but a customer wants to take what is currently field1, field2, field3, etc. and use this data in a drop down box. The table is a...

I'd like to supress a system message ie 'unable to copy record due to duplicate unique key' or words to that effect, and replace it with my own message telling...

I have 4 tables (Quality, Safety, Process, Maintenance) each with the primary key set as "Report#" (no dupliactes allowed). I would like to relate these...

Real Estate Database: for condo developer. Is there a recommended number of fields in an access table? I have a table with 75 fields and could break it up...

Hi, I'm working on table design for a primary key that allows sorting a text field. The field contains values such as 9.21, 9.21(a),...

I made a database to track hearings of an administrative tribunal. I have two main tables (people and decisions). All other tables are lookup tables. In the...

If I need a blank photo box in my database, can I do this in access without writing code. Photos wil be stored in a seperate folder not in the database

hi asked this question before then had to go on a trip so i will start over. i have this equation in excell but need it to work in...

I'm trying to take a simple database I created to track barcode #s and make it so when a new record is created, a specific barcode number is assigned to the...

I need to create a database for school and I'd like to get some help from you experts. I'm new to Access, but I'm learning. So far I have put together three...

In Access 2000 and later, you can create a relation between tables where related records can be automatically set to Null rather than deleted when the...