OK, the criteria is a specific route (bus business) which will be listed for a set of dates. So I have 33 lines of information (one for each date). I have a...

I have a ComboBox on a form with the following in the Row Source "SELECT tblWorkOrders.ID, tblWorkOrders., tblWorkOrders.Description FROM tblWorkOrders ORDER...

I'm creating a database to track a particular form that we receive in our office. When we receive the form we give it a unique number that combines the...

Hi Everyone, I usually work with Excel, but I've been told that Access is more appropriate for the type of work I do. I have no idea of how Access works,...

I have a database of people's details on one table. I have other tables of information about those people eg Agency visited, assessments completed, training...

Blancpain Leman Perpetual Calendar Mens Watch 2685F-1127-53B Collection Watches Collection Site : http://www.watches-collection.com/ Blancpain Leman Perpetual...

I selected all record in the table an press Delete. Haw can I retreve them. Please help

I have a column with “expire date“ and I want to set up a reminder for 5 days before that date. It’s possible? How? Thank you.

I have a database application that over the years has migrated from DOS to an Access application. I started with Access 97 and so far it has been migrated...

Hi everyone - I hope this is an appropriate request. If not I apologize. I have a small "Contacts" database (the one that comes with MSOffice2000)that is 90%...

Hi all, This newbie needs some help please. I need my db to be on cd for other cutomers. I have 4 cd's of photos that go with it. My idea was to have the...

I am creating a select query and I have a field that currently contains the value of 10 and I need the field to be left zero filled so that the value is...

I have 6 values (S1 - S6). Some of these fields have values, and some contain 0 (zero). I need to average these values... NOT including any zero values. In...

I created a form to analyse sales performance.The form is designed in such a way that it lists all the products in a combo and a second combo lists all the...

HI I've just commenced the access learning curve I hope to import/create 14 tables (from Excel) How do i add and link the 14 tables to 1 new table I want to...

I have a table of contents that has somehow changed the page numbers (by 1) about halfway through. Is there a way to change all these without going into each...

I have formula's on my forms that take values in several fields and calculate a value and display that calulation. This value isn't stored on the table, but...

I have a form with an unbound combobox at the top and seventeen controls below it. Is there a simple way to prevent data entry in any of the controls until a...

Because I have a number of projects for which data needs to be kept separate I have created a split database with the intention that I could copy the created...

In previous position my IT support created a " shared feature "in a database where multiple users could enter updates at the same time and all changes would...