Search results for query: *

TheAceMan1: Thanks for taking the time to help me. I added the suggesed code to the Before Update event of my form called sfCast but it allowed me to enter a duplicate name. What am I doing wrong? Here is the entire code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Cri As...

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 solved my own problem. In the event someone else could find this helpful, here is what I did. 1. Created a query (qCast) filtering a form for the fields (txtActor) and (txtDirector). 2. Created a second query (qCast2) based on the frist query (qCast) restricting to no duplicate item. 3...

dhookom: thanks. unfortunately I am not an expert on DAO statements. The skeleton SQL that you provided is all but Greek to me.

dhookom: I understand what you are saying. In my case, Product IDs could be any two numbers. How do I capture this criteria in the WHERE clause? WHERE OrderID In (SELECT OrderID FROM [Order Details] WHERE ProductID IN (1,2) GROUP BY OrderID HAVING Count(*) >1); It could be any two numbers...

MajP: Here is the SQL of qTEST which is working. Perhaps this will explain my statement a little better. Please note the second the WHERE statement which I believe is same as what you suggested. If my understanding is incorrect, please let me know. Thanks. SELECT qitemsCast.iccID...

dhookom: Here is the info you requested. Thanks for looking at my problem. Tables: 1. Cast: cID (PK), cFName, cLastName 2. Items: iID (PK), iNo, iTitle,... 3. ItemsCast: icID (PK), iccID (FK for cID), iiID (FK for iID). Table 1 and 2 are joined on each side of Table 3 Sample Report I...

MajP: I have exactly what you suggested. My field name is [iccID] the criteria of this field is written as below and it is working. I just need to know what will be the correct expression in my criteria to pull data where does a matching txtactor and txtdirector exist. In other words 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...

fneily: I will try what you suggested about the primary keys. Thanks. My apologies for being 'polite'. No hidden agenda was there nor did I intend you to be "laughed at". I regret all of it. Secondly, I addressed your name to make it easier to identify the person to whom I am directing...

Dear fneily: Thanks again. 1. tblArtists ArtistID - Auto Number ArtistName - Text ArtistAbbv - Text Sample data 1 John Denver JDA 2. tblMusicCategory MusicCategoryID - Auto Number MusicCategoryName - Text MusicCategoryAbbv - Text Sample Data 1 Easy...

Dear fneily: I sincerely appreciate your patience with me. You are in correct profession. I was able to create a concatenation of EL.JDA. using IIF statements. But that's because I knew MuscicCategoryID 1=El and ArtistID 1 =JD. This is cumbersome and not feasible. BEcause there are more...

Thanks again. If I have 20 CDs by John D, I will have to work a little harder to find the correct place for this CD on the shelf using dates. (please note, John D is not the actual singer on my collections. I have CDs from other parts of the world where I have CDs by a singer that exceeds...

Thanks for your suggestions and guidance. But keeping the serial numbers as EL.JDA.08/12/2008.102 does not tell me exactly where that CD will be stored on my shelves. All it says that it is in Easy Lisenting and it is by John Denver and that I have a total of 102 CDs. What does the date do...

Thanks for your response. I am sorry for not being very clear in my questions. First of all, please understand, I don't have any formal training on Access, I am learning as I go. Count me as a novice. txtSerialNo is a text box It's not a primary key I am not sure what you meant by...

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...

NOTE to Andy Baldwin: Did you get a chance to send me an example of DLookup function as you wanted to? Here is what I have: A Language Table (tblLanguage) with 3 fields 1. LanguageID (Col 1) Auto 2. Languages (Col 2) Text 3. NextSerial (Col 3) Text I have a Data form called frmDVD which...

Ian, Thanks again. Well, I was able to make the txtbox and cbobox work. But the cmd button was another story. As I click on it to “save”, I am told, “you cannot assign a number to this object” Whatever that means. Two other issues: Q1. =(cboserial.column(1))+1 txtserial's control source...

Dear Ian: Here is what I gathered. On my tblLanguage, I need to add another field with number property to record the serial number for each dvd. So far this is how tblLanguage looks 1. LanguageID (Auto) 2. Language (Text) 3. SerialNo (Number) frmDVD is based on tblDVD. This form now...