Search results for query: *

My Table “Cast” has these fields: cID (PK), cFName, cMName and cLName The form I am using to update this table is called fCast. I would like to prevent entering same name twice. I have used the following code to prevent entering same Title twice which is working. But I am not sure how to...

I have a Form where there are various combo boxes. These combo boxes are used as references for the parameter of various fields in a query. A command button opens a query with the parameters selected from the form. I am having problem with two combo boxes which pulls data from the same table...

I have developed a database for my CD collections using ACCESS 2003. I have several tables including these: 1. tblCategory: a) Easy Listening, b) Jazz, c)Country etc. Each category is uniquely given a 2-letter abbreviation; for example EL is for easy listening, JZ is for Jazz, CL for classic...

I am a novice user of Access. For past several weeks I have been trying to develop a Database for a CD collections. I am running into a couple of problems. TABLES: (not all tables or fields are listed here): 1. tblSongs: List of Songs (SongID / Primary Key PK; RecordingArtistID / Foreign...

I have created a database for my DVD collections. Since I have DVDs in different languages, there is a "Language" table with a LanguageID, Language fields. I have a Detail form where I would like to add a serial number field which will have both text and number. For example, if the DVD is in...

Hi! I am a beginner user of MS Access. So far created a time tracking DB for project hours. It records hours spent by staff, generates managerial reports for project hours and several other employee specifice reports. I need to create a Purchase Order (PO) Managment DB. My Objective is to...