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 Chriss Miller 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: *

  • Users: solun
  • Order by date
  1. solun

    Error in Find Duplicates query

    Actually, it worked pretty well - the data is surprisingly consistent b/c it's generated by the county (state??) election database and there are four fields for the street address alone (house #, house # suffix, complete street name, apartment). Thanks for your help! Heidi
  2. solun

    Error in Find Duplicates query

    I used the find duplicates query wizard and it gives me this error: "You tried to execute a query that does not include the specified expression " as part of an aggregate function." (Yes, that's simply a quotation mark in the error msg.) in SQL view: SELECT [Blossburg Active...
  3. solun

    Not sure how to structure this query

    Okay, I'm using this: SELECT A.BoxID, A.BinID, A.TicketID, A.BoxSerial, A.BoxDate FROM TicketBoxes AS A INNER JOIN ( SELECT Max(BoxDate) AS MaxOfBoxDate, BinID FROM TicketBoxes GROUP BY BinID ) AS B ON (A.BoxDate=B.MaxOfBoxDate) AND (A.BinID=B.BinID) ORDER BY A.BinID; Access will run it...
  4. solun

    Not sure how to structure this query

    Beautiful!!! Thank you!!
  5. solun

    Not sure how to structure this query

    I interpreted that as.... SELECT TicketBoxes.BinID, TicketBoxes_1.MaxOfBoxDate, TicketBoxes.BoxID FROM TicketBoxes INNER JOIN (SELECT Max(BoxDate) AS MaxOfBoxDate, BinID FROM TicketBoxes_1 GROUP BY TicketBoxes_1.BinID) ON TicketBoxes_1.BinID = TicketBoxes.BinID; ... which results in "Syntax...
  6. solun

    Not sure how to structure this query

    Ooops, I'm sorry, I need to know what BinID that each is. When I add BinID to the query, it gives me all the records b/c BinID is unique.
  7. solun

    Not sure how to structure this query

    Many thanks. I need to practice my SQL. :-)
  8. solun

    Not sure how to structure this query

    This seems like it ought to be simple, but I'm having trouble with it... Table consists these fields BoxID (index/autonumber) TicketName (Lookup to a list of names & types of tickets) BoxDate (manually entered short date when the box of tickets was opened) BoxSerial (manually entered serial...
  9. solun

    Speed problem... need diagnostic help

    Access 2000 on Win2KPro Backend lives on nice server, contains 23 tables with 3 to 600 records each (2100 kb). Front end lives on individual users' machines. The front end has 20-odd queries, 20-odd forms and three reports. Granted, the forms are very complex with min. 3 subforms each. For...
  10. solun

    Pass value from form to popup form

    Yes, that's the default cmd button wizard results, and yes, i've got the form set to continuous (checked, double checked.)
  11. solun

    Pass value from form to popup form

    okay, that makes nice new records with the proper LoanID with no error but doesn't show me the existing records with that loan id.
  12. solun

    Pass value from form to popup form

    okay, that makes nice new records with the proper LoanID with no error but doesn't show me the existing records with that loan id. i realized after I posted this that it was a forms question not a vba question, so i reposted there. i'm sorry. thanks for answering anyway.
  13. solun

    Resetting Global Variables

    Access doesn't really like having multiple users ... you should split the database so each user has his/her own copy of the forms/queries/other front items and the data all lives on the server in the backend.
  14. solun

    Pass value from form to popup form

    This seems like it should be so easy... I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID. This code gives me an error on the...
  15. solun

    Opposite of CDate()

    cstr( )
  16. solun

    Pass value from form to popup form

    This seems like it should be so easy... I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID. This code gives me an error on the...
  17. solun

    recordset holds values?

    I didn't think it was normal :-) Okay, here's code part 1: 'Get all loan records for this audit strSQL = "SELECT * FROM Loans WHERE [auditid]= " & aid Set rs = CurrentDb.OpenRecordset(strSQL) ' cycle thru loan records If rs.RecordCount Then x = 0 rs.MoveFirst Do While Not rs.EOF...
  18. solun

    recordset holds values?

    I'm using a recordset to run thru a bunch of records and evaluate various fields within each record. Access seems to be holding the value of fieldZ of recordA if recordB's fieldZ are not populated. Is this possible? And what can i do to clear it? Thanks, Heidi
  19. solun

    Suppress "You are about to append 1 row" msg?

    I'm using DoCmd.RunSQL (strSQL) to add rows to a table. I want it to not notify me that it's appending a row - it's really irritating and the table is specifically for these added rows. How do i suppress that warning? Thanks, Heidi
  20. solun

    insert into... recordset?

    ah, thanks! now, how do i account for the autonumber PK field "errorid"? or am I supposed to keep a counter going within my script? strSQL = "INSERT INTO errors VALUES ("errorid should go here & lid & "," & today & "," & ctapps & ", 1, 1, 1," & teststr & ")" Heidi I. Jones Ridgerunner...

Part and Inventory Search

Back
Top