I have 2 tables. One is a main table containing all information about my records. The second table is a log table. What I want is an automatic entry made...

I have a master table, tblProject, and set a one to many Relationship with tblsource, and specified Referential Integrity, but I am having trouble adding new...

Can someone give me a short way to set up passwords for two groups. I have clerical staff that need complete access to program using one password. I have...

I am a total newcomer to Access, so I may also be totally unaware of an obvious possibility, but: I was thinking of using Access to manage a project, with its...

An order may be rescheduled to ship multiple times. The tables look like: TblOrder OrderID order...

Hi there Here is my problem..... =IIf( Between "1" And "100000","£240",IIf( Between "100001" And "150000","£280",IIf( Between "150001"...

I need to have a 8 1/2x11" sheet of paper accommodate several, say, +/- 3in x 4in "reports". I was given the great advice of setting a page to print x-number...

I have tried to find a clip art suitable for an 80th Birthday but have had no success. It seems that 30, 40 & 50th Birthdays are all that is covered....

I've had MS Office 2003 since it came out. I'm an advanced Excel user, and it has pretty much done whatever I've needed it to do. But I've never touched...

Given: TblSurveyResponse SurveyResponseID ResponderID SurveyItemID ResponseYesNo Can a single SQL be written to return all ResponderIDs who annswered Yes...

I have limited knowledge of Access 2003 and want to find a way to have numbers like: 1.02040816 in the following expression to change automatically if I change...

How can I print the screen I see when viewing - database objects - queies (detail view)? I have been using Print-screen but that gives me a bitmap. I want a...

Hi Guys, I want a physician look up list in my database. I have another flat database with physician FName, LName, and Specialty all in one table. My...

Not sure what newsgroup to put this in. We use FrontPage to develop our intranet where I work. On certain pages, we use links to start Access programs...

Hi I have 2 bombo boxes on a form. ComboCat is the first box that gives the user a list to select from. The data for this combo box is drawn...

Has anyone encountered the error message "Can not open any more databases" and what did you do to solve it? Thanks, Dave

Hi Guys, I have the event procedure below to run on a control on my form but I don't think I want to use it after all but don't want to delete it, how do...

I have a field in my database which contains 6 numbers ex: 123456. I want to break this number down, add another field and have one field 123 and the other...

Just wondering....IT department bags on access and pushes to change. thanks, Donna

Very new to Access. Forgive me for incorrect terminology. Working as a volunteer in a clinic setting and a software package is provided that uses Access to...