Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. xyzlook

    Prevent duplicating values for First Name, Middle Name and Last Name

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

    Prevent duplicating values for First Name, Middle Name and Last Name

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

    Query Parameters through a form

    ...Format ON qItems.fID = Format.fID) INNER JOIN [Language] ON qItems.lID = Language.lID) ON Type.tID = qItems.tID WHERE (((qitemsCast.iccID) Like '*' & [Forms]![fReportList]![txtActor] & '*' Or (qitemsCast.iccID) Like '*' & [Forms]![fReportList]![txtDirector] & '*') AND...
  4. xyzlook

    Query Parameters through a form

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

    Query Parameters through a form

    ...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 based on the two text boxes selected. Thanks.
  6. xyzlook

    Query Parameters through a form

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

    Query Parameters through a form

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

    Query Parameters through a form

    ...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 rephrase it for AND condition. Like "*" & [Forms]![fReportList]![txtActor] & "*" Or Like "*" & [Forms]![fReportList]![txtDirector] & "*...
  9. xyzlook

    Query Parameters through a form

    ...generate a query to display any combination of actor and director (Or actor and actor) from the table called CAST. I used these as a filter: Like "*" & [Forms]![fReportList]![txtActor] & "*" Or Like "*" & [Forms]![fReportList]![txtDirector] & "*" It does not work when I use AND in this...
  10. xyzlook

    Auto Populate a serial number in MS Access 2003

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

    Auto Populate a serial number in MS Access 2003

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

    Auto Populate a serial number in MS Access 2003

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

    Auto Populate a serial number in MS Access 2003

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

    Auto Populate a serial number in MS Access 2003

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

    Auto Populate a serial number in MS Access 2003

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

    Auto Populate a serial number in MS Access 2003

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

    Beginner seeks help with sub form and Auto List update

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

    Auto Numbering

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

    Auto Numbering

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

    Auto Numbering

    ...form now has 1. One hidden txtbox bound to the ProgramID from the tblDVD 2. One combobox called cboSerial based on this query SELECT Languages.*, Languages.Language, Languages.SerialNo FROM Languages ORDER BY Languages.Language; 3. Another txtbox [Unbound] called txtSerial has...

Part and Inventory Search

Back
Top