I am trying to create a database for my wife for Mary Kay. I need to be able to input product info, customer info, and use those databases to create orders. ...

I need to make three tables: Main_Account (6 digits) Sub_ACC_1 (7 digits) Sub_ACC_2 (8 digits) The main account number is also the first 6 digits of the...

Is there a way to hide all of the tables using sethiddenattribute without itemizing each table? Perhaps a "hide all" command? Thx.

I am setting up a database that will track the awards that personnel are awarded. The relationships will be many to many I think? I want to see how many...

I am trying to set up a database to tracking awards earned by personnel. Many people my earn many awards and the awards can be earned by many people. I...

Im trying to figure out if I should create two forms, one for inputing/editing data using drop-down menu's, and one for displaying/deleting data not using...

Hi, i've been playing around with MS Access 2k3 for a while now, and am still trying to learn good database design. I've rebuilt my current one (For IT...

How do I change which subform is displayed using a combo box? Background Info: I have a single Form displaying basic equipment info from the same table, but i...

Can anybody tell me how to customize the contact fields so I can use outlook much like I use ACT 6.0?

I have an order form which requires the names of 3 employees. (1)Order Taken By:, (2)Dispatched By:, (3)Dispatched To:. I have combo boxes set up and...

I have a very simple form in Access 2000 that a user can enter information about IV Pumps and keep track of them. They enter the patient, facility, serial #,...

How do I set up a form that automatically fills certain fields once one piece of related information is inputted? An example would be from a table with an ID...

I have a database with several 'master' tables and numerous 'support' tables. I'm trying to create a SQL SELECT statement that will select the 'master' record...

Background: I have a database with a single, linked table from a large excel file and I am trying to add more functionality within the database. The file has...

How do I get thumbnails of photographs in an Access Database

When I move from page 9 to page 10 of my document it switches automatticaly from print view to normal view

hi all !! i need to have an auto number in a new table but i need the auto number to start from a certain number not zero. how can i do this ??? any help...

I am in the process of designing a table and I am not sure what the best way to approach the design is. In summary, I have one table, lets call it...

I am currently setting up a small application where some of the users will not always have access to the database on the office shared drive. Though not...

I was reading a previous post on this subject, but it appears this post has went cold. In either case, I would like to print/save a form and/or report to a...