HELP! I don't know what happened. I was just doing basic cleanup of forms and reports. Now any event that fires gives me an error - all based on "File...

Just to be clear, I am not looking for an explanation of how relational databases work in this question, I have been creating relational databases for many...

I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See...

I am trying to find the easiest method to write code which would allow me to open a report from a form linking up to five fields. For example: I have a...

What is input into the label boxes to all count those fields within a grouping that a blank. The Category is RSVPDate -- Rose

I am new to Access, and very little knowledge about SQL. I read allot about normalization, need to know if I went to far with it with my Family table. Here...

I am working on updates to a couple related databases (not linked by any tables) and have a question about virtues of Make Table vs Append queries. Make...

Hi, I have a table that holds information for jobs. The job number is an auto number field. It has grown to a 5-digit number and users want to start over...

Hello. I have an instance that I'd like some input-suggestions on if anyone would be so kind. We have a vendor table with each vendor ID being unique. One...

I have read that "in a junction table, you need to set the primary key to include the primary key fields from the other two tables. " If I do this, I keep...

I've created a database with about 15 tables for a participant data in a research study. Each participant will complete the 15 assessment measures. My...

I have a table that populates specific data from a SQL view when I manually run an append query - works fine. What I really need to do is have that table...

I need help in creating a solid table structure for tracking vehicle waivers. I posted this before, but I cannot find the related post. I will try to give as...

I am having trouble understanding a design concept. I am setting up an employee database for the first time. At issue is how to handle the actions entered...

Hi all, We have just made the transfer to Access 2007. Apart from the ribbon layout, which I believe only requires some time to get used to, I have a question...

Howdy. Using Acc 2007. Have two tables related one-to-many. Ref. integrity being enforced, without any cascading updates or deletes. Data in both...

I am working in an education template and want to see if there is a way to create a field that can be added to periodically to show all the courses a person...

So my company just bought another company and they send me a flat text file with 1.5 million records of customer name/orders/transactions etc - all in one...

In my recruitment database I have tblJobs, which at some point is linked to a candidate via a relationship table. There a two category of jobs: 1. Jobs for...