I have an Access database for our customers that contains their current status of maintenance and the date their maintenance expires. My boss would like to...

Hi, I need to create a table that can store the following data: Employee ID, Reference, Departure Location, Transport Type, Departure Date, Destination ,...

I want to link a Demographics table to my table in Access that gives me Pt Information. I want the table I link to fill in the from the Demographics table to...

Project leaders receive the same per piece pay as employees but receive a stipend. How can I set up my Access database to accommodate the stipend?

Hi I was wondering if anyone could help me with this problem. I have a form based on a query. When you press the button to open the form the query asks you...

Hello could some one please tell me if it is possible to get a macro to do a "Save As" . What it will have to do is save as a given date which will be at all...

Hi, I have a small problem which should be easy to solve, but hasn't been. I am trying to take the customer name from my customer table and insert it into my...

I'm using a web database to track users in Access. I have one large table where I store the times and details of which page was visted and by whom, etc. I...

Hi All Is it possible that once data is added to a table it is inserted to the table in alphabetical order. Eg. Name Security ...

I have created a database using Access, and filled it with data to test it. Now I want to empty it, and prepare it for distribution. What is the best way to...

Ok, first off, I am totally new to Access, so my question might seem way too basic, but after searching through 100s of webpages (ok, maybe a bit exaggerated)...

I have a parent table, which represents a list of businesses. Then a child table which represents instances of a business participating in a program. The...

I am trying to automate the values of the option button groups that I have on a form by entering those values into an external table. I have tried using macros...

For every record in (Parent) Database, I want to create a child database. For example, Cards in a tickler file have Name, address, cell number, etc. Then the...

I have a database of books, and I need to store information such as the US Price, the UK Price, the Australian Price, etc. only each book does not strictly...

What is the correct answer to this function in MS Access: @Prompt(,,,,)

I have a spreadsheet like table that I want to break down. I have the concept but need help/recommendations with Keys and relationships. The machine_id is...

I need to create a database to track employee movement (new & terminate). I m afraid I have poor table design, which cause me to supplement many queries...

HOW DO I GET CELLS TO EQUAVAL TIME? AS IN 2:00PM + 6:45PM = 4.75 HRS.

I'm designing a database to keep track of which employee has which piece of equipment. It needs to keep store who has what at any one time but also a record of...