In the object table, I can see there is a linked table but how do I know the
actual table located?

I am struggling to create a database with client ID, Names and Service
Offerings for the year on a daily basis.
The user input will be a tick mark if the service was used by the respective
client for a particular day.

I am creating a database to be used by multi users. how do you prevent
openning a form if already open by another user?

I'm creating a query that includes the cities in descending order. Each city
should appear only once. I can't get the cities to appear only once they
appear multiple times... what do I need to put for criteira?

I am using Access 2003. When I create a new form with the query
wizard, I am given the option to create it in a tabular, columnar,
datasheet, PivotTable, or PivotChart view. If I have one-to-many
joins, there is the option to view it by subform.

Does anyone know if you can (and how you can) create a combo, list, or value
box and set the properties so that the user can multiple select?

I am looking for some design help. Does anyone know of how others have gone
about producing a ghant chart type interface with Access? I have used Access
extensively for many types of applications and would like to use it, if
possible, for my latest idea, but as far as I am aware, ...

I'm triying to replicate a sample database "Contact Tracking.accdb" that is
part of the companion CD from the book "Access 2007 Inside out" by John L.
Viescas and Jeff Conrad, but when i try to set the validation rule for the
Products table following the book instructions (Pages ...

Hi! I am currently making a VB program that would read a databse consisting
of three elements. An (1)Industry elements, (2)Division elements and (3)
Position elements. If anyone can help me in designing this database, I would
greatly appreciate it. The database would look like this:

I want to build a simple database….
All tables will be linked to a Commercial Manager
There will be three tables
Commercial Manager containing:

Could someone please help me with general design concepts in making a
manufacturing inventory.
I'm think I would use three tables:
   Raw Material

I have a split database, I've designed a new table. How do I get the table
into the front end db so I can also design a corresponding subform?

A question that I have is what do you believe is the best way to design a
timesheet for a week.   The form design is to have the task on the left side
of the page and the days of the week going across the page.  Should I utilise
unbound fields or use bound text boxes. ie

I have a very complex database - I'll admit from the get go that I'm probably
in over my head.
Having said that... hiring a programmer is not really an option for our
small non-profit firm... so I put on my "database designer" hat, took a quick

I am trying to create a database that records in and out movement of staff.
This data base will include, time options to select and names of the staff
that work for our company.
The data base would need to be able to record individuals data as well as