Search results

  1. E

    Suggestion on managing priorities in a form

    The only way I can think to do it would be to first test if the new record has a duplicate priority. If it did, you would need to run an update query which selected all records with the priority >= the priority in the new record, and update the priority field to priority + 1. You could then...
  2. E

    Populating Dates

    Use a Left Join. Right Click on the link between your two tables, click on join properties, and choose Include All records from 'Date' table and only those records from 'Employee' table where the joined fields are equal.
  3. E

    Traumatized by killer NESTED IIFs

    So your code could be reduced to: =[R1] & ("-" + [requestDetails]) & ( " / " + [R2]) & ("-" + [requestDetails2])
  4. E

    Searching equal records

    Create a new query. Add CUSTOMER and PERSONAL. Link P_LastName to C_Lastname (and any other fields that you want to be equal). Bring down whatever fields you want in the new table. Change your query to a make table query, and run it.
  5. E

    Multiple selecton in ListBox

    Put a Breakpoint on the line where you are testing to see if strCriteria = "All". See what strCriteria actually is, and go from there.
  6. E

    Traumatized by killer NESTED IIFs

    Also, you might consider using + instead of &. The difference is that + does not propegate nulls. For example, If I had two fields, FirstName and LastName, and LastName = "Jones" and FirstName was null: [LastName] & ", " & [FirstName] = Jones, [LastName] & (", " + [FirstName]) = Jones Can...
  7. E

    Recordset Query

    Can you describe what the code is doing, and how you need it changed? You said you are close, but you do not indicate what it is doing.
  8. E

    search from form

    Oops - just re-read your post. My method would work if you want the user to be able to search mulitple fields for different text... Colin's solution is perfect to allow searching for multiple fields for the same text.
  9. E

    search from form

    Well, you could enter the name of the field in the tag of the control. Then, you could create a loop that would go through all controls on your form, check them for text, and if found compile your string. Something like this: Dim Ctl as Control For each Ctl in Me.Controls If Ctl.Value <>...
  10. E

    Tracking Training

    I'm not sure what kind of training tracking you are talking about, but the following site has tons of free data models. One might work for you. http://www.databaseanswers.org/data_models/index.htm
  11. E

    Using access query in visual basic?

    What don't you like about this way? While there are always several ways to do things in Access, this is certainley the easiest, and requires no VBA (which other ways would).
  12. E

    Update Query

    That should work. What field type is AR_Invoice.InvoiceDate? Can you put a stop in and see what SQL123 evaluates to? That may help determine where the probelm is.
  13. E

    Help with SQL code

    Is it because you typed tlb instead of tbl?
  14. E

    Open form on two combo box values

    Try this (I'm assuming the criteria are for Integer fields): strFilter = "intprojectyear = " & strYear & " And [intprojectjobno] = " & strJobno
  15. E

    Want to add query result in a form

    Why don't you base your form on the Query that includes the Rank rather than the table? Then you'll be able to add Rank easily.
  16. E

    Calculated Field from Form to Table

    I'm not sure what the question is?
  17. E

    Using access query in visual basic?

    You can try using DLookup. outbox = DLookUp("Expr1", "newSerial") It looks like you just have one value in the query, but there is an optional third part of DLookUp which would let you set criteria.
  18. E

    Update Query

    Try using: Format(Dated, "DD/MM/YYYY") instead of just Dated.
  19. E

    Select Second Highest Value

    Thanks for your efforts! I wasn't sure if there was an accepted way to do this or not. The reason I need to do this is to compare the newest data with the second newest data for changes... never had to do that before. Thanks again!
  20. E

    Select Second Highest Value

    LOL - I have no idea! Maybe that's why I thought it looked goofy. I sort of just tried a bunch of things until it worked. I took out the Distinct and changed it to top 1 and it looks good... thanks for pointing that out!
Back
Top Bottom