I have a Database with a large amount of data, I had an autonumber as the primary key. Over time I have deleted records and added many more. Recently I have...

how do i remove "is null" or "is not null" on filtering?

Can someone provide me with some quidance on how to write a dlookup formula. I was able to create on for a form, but I am trying to create one that looks up a...

We have a problem with an Access 2000 table where the KeyID field was duplicated. When we look at the table and attempt to append a record to the bottom of...

I have this popup form that I'm inserting information from a table that is indexed by CTANumber. The CTANumber is located on my other popup forms so that the...

I am trying to put percentage numbers with up to three decimal places but access holds the decimal and shows a rounded figure. Any answers?

I have a database of projects. I need to see just projects completed in specific month how can I make query etc.

I am creating a database application to quote products in our sales dept. at a made-to-order manufacturing facitilty. We manufacture three different product...

I've tried several of the database templates (inventory control, order entry, and customer orders) to set up a purchase order/receiving database, but...

I have a business providing language classes for children. The customers are the parents who sign their kids up for the classes. The tables I have...

Hi, I would like to create two tables, a master and detail, containing order information. I've created a header table with two primary keys, one text type...

Hello, I'm trying to combine two tables into one form, without using subforms. One table has 255 fields and the second table has about half of that. Is...

Hello! i want to prevent entry in one field on a form unless another field has been filled in. Could someone please tell me how to do this! Thanks Derek

Hello, A little new to access programming (I'm a MySQL/PHP guy), and I was wondering if it's possible to change a Yes/No field to different values, besides...

I have a table that was created by someone else. Here is the layout: Number Comments Date With the info showing up as: 1033 It's raining today...

In designing a database, is there a way to keep users from looking at tables, if all I want them to have access to is their form.

I want to be able to run a macro from a command button that allows for a specific data set to be found and then appended to a seperate table. I have a central...

I just wanted a quick starting point fi anyone has a template available. Thanks for any help you can provide.

I have several combo boxes which hold data from 1 table. Some fields in the table are empty but they show up in the combo boxes as blank rows. Is there any way...