I have inherited a *.mdb with many tables and many relationships between them. I've also noticed that there are not a lot of indexed fields. As a...

Had some help with this, went and bought a book (which is still a bit greek to me), and have played around some with the code. I have a main form with a...

I am trying to make a db with client notes in it. My problem is I need to be able to track the client name changes. For example: client comes in today...

Is there a way to retrieve the Caption of a Table or Query field through VBA? Thanks, Pflugs

Hi, I want to create a database that list researchers and their asscociated subjects (can be more than one). I guess the design would be in the shape of a...

I am using Access 2007. I have designed my own Address book. It looks fine but I would like a new page for each alphabet. How can I get the report to...

How can I add a calculated field to a query ie. Order_Count: Order_Count

I am new to Access and my project is this...having trouble with designing my tables. My contacts are both my colleagues and customers. Both have a facility...

Hi, up to now I have been using a single master table for my inventory, with all of the duplicate date. I have figured out how to split the table so that it...

Hi hope you can help I am having problems with dlookup. I’m using access 2000 and I’m trying to retrieve the ‘email’ address contained in a table...

A2007 allows multiple hyperlinks in a single column. I want to update a hyperlink column with some additional hyperlinks. The column may or may not be null....

I want to insert a button to map the address listed in a form. Can someone help me with this?

Hello, I have to create an access database that will be share with 3 departments. The database need to control the Shoes, handbags and...

Hi: I need to create a simple database to track trainees and coaches plus all trainning session. There will be 3 users and we would like to share the...

Hi Experts: I'm trying to create a lookup table from the below text file, here is some data: ID Field2 Field3 Field4 2122 ...

I'm getting a Syntax error (missing operator) in query expression, ‘where_Fact_Orders.Transport_Days 3’.

I have the employee name separated by LastName & FirstName (2 separate columns) in my TblEmployee. In my report, would like to combine the last and first...

I want to keep an inventory Database. One of the inputs will be daily sales. I can either keep track of the amount on hand (simple solution) or try to keep...

Hello, looking for some input to the design of a database. I have 6 field trucks that are always out in remote areas(no cell or communication services), I...

i have a badly designed table that has some fields with values that would better fit into a separate table e.g. i have something like this: let's say that...