Hi, I have an access members database, quite extensive. I also have a members excel file which details frames won and lost in each match for the season...

Access Knowledge level - medium low (can create tables, link them, basic queries, basic forms and reports). Using Access 2003 I have 48 people who have...

I have an excel sheet that gets refreshed each day. I've linked a table to it. I've split the database and have a copy of the front end on other users...

Hi. We have been using Access for a project database for years. However, we just added our customer information (formerly in ACT) to Access. Now I have...

I have a database which stores information about courses. This Course table structure is very simple: CourseID, Description, Title, etc. I need to store...

If someone could please help me get my head around this it would be much appreciated. I have three tables: tblEmployee with the Primary Key being...

I have a historical table with a JOB#'s field in it. the numbers for this field were entered somewhat randomly and go up to about the number 7700. I would like...

I'm using Access 2007. I have a very small business & am trying to use access for payroll/hours. When I enter hours with decimal (ie" 7.5), it...

Clip art is made of pictures and real pictures.

Hi I will have 4 tables name "TblCostomers","TblVendors","TblAccounts", TblExpenses" Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers"...

How do I save the date a record was last modified in Access 2003? I know a little about Access databases, and need help with a database I designed. Any...

Hi, It's nice to be back here!! I am planning to make a database for Engineering Documentation I have the following fields tblDocumentList Document No ...

I have just converted an exsiting database to Access 2007 format. It is split, front end and back end. I have created a new field in a tables database as...

I've had this situation designing two different dbs recently and wanted to see if there was a better way to do it. This db has a Roster table with names and...

In my database of employees I have three date/time fields - Agency Start date, Rehire date (a lot of our employees only work part of the year) and Separation...

Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and...

I have created a look up table and the fields are SuburbID (primary key) Suburb, State, District, Map Ref. Then I have created a form that allows me to put...

I am trying to break the link to an external database while keeping all the data in the tables housed locally. It is possible I will loose access to the...

In a form that I'm developing I have 4 columns and 5 rows. I would like for the row height of all rows to automatically adjust to accommodate the text entry...

I was curious to get some ideas for the best way to maintain the address of mailers that had been sent out. So by way of example we send out mailers or...