Hi, Is it possible to set a table fields properties to undertake a dlookup, and if so where would I put the syntax. i know how to do this in a form, but this...

I have developed 2 tables. One is an inventory of sorts table with a medication name, dose, lot number, and expiration date. There may be many entries with...

I have been assigned a task to create a database and need some advice on the correct design. I am not new to Access, but nowhere near an advanced user. The...

I have been working with a front-end / back-end configured database for a while and it works great. I have been creating the queries in the front-end but now...

I have a table that grows bigger and bigger year by year. Is there any way to move the old records to a new table automatically to make the overall operation...

I will try to simplify the problem. I have two tables called samples and Isolates, and would like to store pictures for both. I can join these each with the...

I am working on a database to record inwards and outwards mail and work in progress for my workplace. The database has been in existance for a couple of years...

How to calculate the different between two time values?

Database splitting question: I have a db that contains data tables (fixed information), dynamic tables (info that changes based on users input), queries,...

I am developing an order entry system. I have several products with several different prices. I am tring to create a way to allow customers to place orders...

Hello, I am a high school teacher that teaches several subjects during different periods and want to set up a database for my students that includes...

Is there ever a time when you would NOT use the Access Relationships design window to establish relationships between tables? The alternative would be to...

The table that I am designing will require a "Discount" field. The office manager wants the data entry person to have an option of directly entering a dollar...

Within an Excel Pivot table, you have the ability to turn off or on the "Grand Total" as an option. I'm wondering if anyone knows how to modify the "Grand...

I need to create a sequential record identifier that is made of a fixed text string and the sequential number, i.e. Book-nnnn, where "book-" is always the same...

I have a db in Access 2000 that needs to remain in 2000 b/c not all users have had their workstations upgraded to XP. This db needs to link to tables in...

Hi, Since I have being invited to post our issue, I am not sure if I am posting it at the right place. We are using an MSACCESS 2K database on a W2K3 TS...

Have a replicated 2003 database on several machines. Recently networked XP pro machines using small office wizard to share directories and printers. Once that...

I have 3 tables , one "Guests" table inserting guests details and another "Songs" table that will be populated with names of chosen songs stored on "Artists"...

I have a record on table1 columm called userID and I would like to automatically insert this value into table2 columm userID2 everytime I insert a new value in...