hello how are you, Can you tell me how to build a database in Access to track Product inventry, Employees Payroll information.Customer History, sales...

Hi All, I am a new user of MS Access. In fact, I have started to learn Access motivated by one of my requirements to manage a small database (class time table...

I've converted a database from 97 to 2003 - it comes up with an error - file not found when i use shell "\DIR\File.pdf"

Hi, I have 2 tables, let's say A and B. Both tables are basically the same with a few differences. Table A has records from 1/1/04 to 8/13/06, the date/time...

How, or what is the simplest method of backing up and restoring a back end database file? It must be done via an Access form, perferrably a one-button click....

Hello, I have a query that I want to have an expression and I wnat to use it on a RPT but everytime I write it it asks the expression after it asks for my...

What format can i use in order to sort one field containing first and last name by last name only? In table design view i have tried to put in a format that...

Access 2002/3 One combo box, the user types in data which then appears in a text box. This needs to be saved for later use, there can be up to 52 entries. The...

truthseekers, bearing mind i am very new to access, could someone help me please? i have looked up my problem in my textbook and on the internet and in the...

In access 2007, I don't see how to choose long integer for a field, a foreign key for example. Just number. Can somebody help? dennist

I have a lot of queires. I want to put the query names in a table, one field of the table will have a group_id. Then I want to execute the queries for a...

I think I'm way over my head... I have created a form with a sub form based on a table. The values that I put in the table need to be averaged by field. (...

I am trying to write an expression that would give the total number of days between an "OfferSentDate" and "DateAccepted" for a metrics query. I simply...

how to change the background color of a cell/field in a continuous form? tia, mcnewsxp

I have a report which is grouped on individual names. It lists inventory items in their care. I have a group footer and a page number field moved from the...

I have a database in access 97 that is used to book visitors into our building. There are over 100 people allowed to book the visitors in There are 22...

My company inherited a database that has numerous blank data fields. In order to make the project work correctly the blank field(s) was populated with the word...

Am still looking for a way to do this: Two or more fields, nulls allowed. Search for contents of one text-box per field. If not found, append a new record...

Without having to buy a book, does microsoft have an introduction to access 2007? Thankis folks. dennist

Hello I have been trying to work this out for a while, I am sure I have done something like it before but just can't seem to get it now. Basically I have a...