Hello experts: What is our basis to determine that a group of deta should be on a separete table. I found it that actually this database is very helpful in...

This is a new one for me. I have a shared database with linked tables. Both databases reside on our share drive. The path for the linked file is set to S:...

I've made a lookup table with a primary key based on age and total score (if the test taker is a certain age and scores a certain total score, various other...

Hi, Here is the situation, I have one nurse who may stay in 3 different accommodations on one work order. I have one tablel that contains all of the...

Dear all, Although many Microsoft Access books advise to set an autonumber field as primary index (a so called pseudo primary key),...

Is there anyway to show the current day of year and days remaining in the office calender?

I have a 250meg Access db running on Access 2003 on WinXPPro. The db is hosted on one very fast PC and two other very fast PCs also use the db through a...

i have a db with 5 tables. the first tabel timember with memberid being pk and the field Partner id linked to a table memberspartners on the field...

I just don't understand something findemental about input masks. Please enlighten me. I can set an input mask on table fields, and I can also set it on Form...

run access 2003 works fine.while synching one of the files to the palm it looks like the auto numbers has gotten corrupt. the last 2 numbers where...

ok, so my query is this I have a work order table which has a one to many relationship with an accommodations table and a one to one relationship with a...

Hello, I am new to the databases and the database in access that I am creating is linked to a paradox database. I have one table that I update with all the...

I am designing a data base for my business and I want to import data from an excel spreadsheet. I have put my spreadsheet in the same order as the table,...

I use access 2003 I have a table named products ProductID ProductName Unit Price Residential $15 Commercial ...

Hi all I am creating a data base that tracks information pertaining to musical performances by a group of musicians. I have five tables: Songs: SongName,...

Why should I use the JOIN ON syntax instead of the WHERE syntax? In my antique book Jet Database Engine Programmer's guide Page it says (page 119) "This is...

In report header I need fields : requested by 1) Date supplier name request order# payment terms (either cash or cheque) 2)

I have recently been put in charge of coming up with a solution to a mess of data that is unuseable. Currently information is being read every half hour and...

I try to open a database designed in Microsoft Access XP , in Microsoft Access 2007. All forms and tables seems to be ok but NO COMMAND THAT I WRITE IN VBA...

Hello - I'm working on a database that has some many-to-many relationships. I've used Access several times however I am fairly new to creating databases. ...