The database that I am designing is to track documents done in a Word Processing Center. There are 10 tables in the design. I created a Form from the Main...

Hi all, I'm hoping that my tables are normalized properly, but I'm stumped on a particular layout and design structure. I hav a table with faculty, which...

This website is for artist, freelancers, programmers, writers, translators. All who is looking for work. If you are a skilled professional use page "Add...

I have two tables table07 and table08 one has data for 2007 and the other 2008. What I need to do is to take the information from both tables that matches and...

Hi all, I am in a case that a image and some texts should be best saved as a record into a table and can be retrieved back in a win form. I am wondering how...

I have three tables, one for vendor ID, another for centerID (which identifies country business cost location) and one for invoice information identfying...

I have appended query that scans a part number as shown below: INSERT INTO Triggers ( , , , , Qty, , Supplier, ) SELECT Products., Products., Products. ,...

Whenever I've created junction tables in the past, I always made the PK of the junction table the combined pks from the two other tables. Ex: Table1 PK=A;...

I am trying to create an access database that will show upcoming appointments with clients. These appointments are always recurring every month, 3 months, or...

Is there a fast way to recreate the structure of a database without the data? I would like to use the design but not the data... Thanks! Cheese

Hi Everyone, I'm trying to figure out which would be the better design for a table or two. I'm converting paper forms into a db format. On the paper forms,...

I am adding records to tblEmployees using below, no connection: strAddRecord="INSERT INTO tblEmployees() VALUES ()" DoCmd.RunSQL strAddRecord and this works...

The following tables were generated by my data base, what cuase it? MSYsAcceStorage, MSysACEs, MSysNavPaneGroupCategory, and a few more with similar...

I have a database where I want to have the lookup fields cascade. A good example of this is when you visit an automotive parts website. You first enter the...

hi, Is there any code or thing that can transfer a report to pdf file? many thanks

Hello, I have read some explanantions about many to many table relationship, but it is not so clear to me in practice. My church membership database that I...

I have a table for OT(primary Key is ID that auto numbers) that the employee goes in to a form and enter in the hours they are available to work for the...

I have 2 tables that have coorsponding data that are gathered in time. In table A the time is (EX. 12:34:17pm) in table B the time is calculated every 6...

I have 12 locations, 4 security checks, and 16 different security check times. They want to put in a db a months worth of random checks (so they can see...

This form has five sections (all on a tab control) 1. materials 2. up 3. down and 4. take up and 5. properties. Each of these sections have...