I have three different types of aircraft and I need to inventory parts and assign locations for each aircraft type. I will then combine the three tables in...

Hi, This question regards a problem that I ran into while designing a new Access database for my company. Question Which solution works best for the problem...

I want to creat documentation showing all the files in a software system and all the fields in each file. I want to do this in a way that I can query on the...

Hi Guys, Totally new to Access, but I hope this is a straight forward question. How do you add a new record under the same heading (say a home address)...

I am stuck and I've tried reading on table design but I get terribly confused on how everything connects. I get the idea of Primary Key and Foreign Key so I...

Hi, Thank you for taking the time to read this. I'm having trouble with my drop down boxes in a database I'm creating. I need to be able to select more...

Can I freeze panes in access 2007 reports. I would like to see the headings as I scroll down. Please help me.

I have a table called MyType with 2 columns "MainType" and "SubType" The table "MyType" .... "MainType" "SubType" Document Book Document ...

my sample have 3 form: form1, form2, form 3. Here is code in form1 to create new database by VBA. It will make a new file "name.mdb" and new table in...

I am trying to turn an actual paper diary and turn it into an electronic diary. In this paper diary we write down every employees name and what they did...

I am trying to design a new Access 2007 database that needs to process a list of questions and store the results in a single row. The number of questions is...

My company has various equipment units (P141, P142......), these units have different size cases (40TE, 60TE, 80TE). We have an approvals process that...

I have made a database with tons of information in it. THere is an auto number. My question is , is there a way to freeze data in this database so no one...

I've created a custom menu that I would like to have used upon startup of my access database. However, when I try to choose my menu in the drop-down list in...

Hello, I have two tables - One is "Employees" and the second is "Holidays". Each Single Employee within Table Employees can have many holidays, the problem...

I would simply like to put a database on a network drive with no security so that four users can use it. I have tried the security wizard and all the...

I'm trying to build a database to match my client locations with vendor locations by job type. What I'd like to do is import the client locations and job...

Help....I am running a database that is used at 5 different sites. Each site has a stand-alone version of the front end and back end that is kept on a...

I am working on a database with the primary function of tracking attendance for many people to many events. The database is set up so that there is a table...

I created a log for cashier's check in MICROSOFT ACCESS PROGRAM - everyone is inputting but sometime they forget so I have to go back and research the...