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 derfloh 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: qqp
  • Order by date
  1. qqp

    Looking for ideas on how to create an estimating form that would have a header and details under it

    Great minds think alike, that's exactly what I did and it works like a charm. Thanks Duane!!
  2. qqp

    Looking for ideas on how to create an estimating form that would have a header and details under it

    I'm trying to create an estimating form that would contain 2 continuous subforms. The goal is to make it look similar to this (created in Word) Some bids are simple, just a few details, others are more complex like the attached. Right now I have a main form bound to the Bids table, and 2...
  3. qqp

    Query criteria from form

    Well this works: (note, I removed a comma between acviewpreview and ssql. sSql = "SELECT * FROM masterquery WHERE topersonid IN (" For Each Lmnt In ctlList.itemsselected sSql = sSql & ctlList.ItemData(Lmnt) & "," Next sSql = Left(sSql, Len(sSql) - 1) & ")" 'Remove Last comma and single...
  4. qqp

    Query criteria from form

    But it' not working for me. I am getting a syntax error at this line: DoCmd.Openreport Forms![FMainMenu]![FReports].Form![ReportName].Column(3), acViewPreview, , sSql Thank you!
  5. qqp

    Query criteria from form

    Thanks for this combo! I'm getting a syntax error. When I debug.print I get: SELECT * FROM masterquery WHERE topersonid IN (5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19, 20, 23, 24, 28, 32, 38, 41, 44, 45, 50, 52). If I use this directly in the query it gives me the correct data. Can you...
  6. qqp

    Query criteria from form

    I just tried using the Salesperson ID (number) to no avail. If I enter it directly in the query (IN(8,50) I get accurate results, if it's in the text box on the form, I get no data. Even though it's exactly the same. Thanks again Andy!
  7. qqp

    Query criteria from form

    The list boxes allow for multiple selections, and I have a "Select All" button for each listbox too. The text box shows the selections like this: John Doe or Steve Smith. At first I had the IN statement appended to the chosen items. I didn't have any luck with that either. I just tried it...
  8. qqp

    Query criteria from form

    Hi everyone! I am attempting to use a parameter form to create the criteria in a query behind my report. The form contains several fields and 6 multi-select list boxes. The list boxes fill their respected text field properly. In my query, I reference the text fields in the criteria like this...
  9. qqp

    Need my msgbox that warns user of missing criteria to stop the rest of the code from running

    Hi! I have a filter form to run a report, there are 2 reports that can be printed. Summary and Details. Right now on the summary button, I have put a code to be sure selections have been made in both list boxes (used for the report filter) and it will pop a message telling the user they need to...
  10. qqp

    Next incremental number using the current date

    Yes I did! Thank you so much. I used a modified version of what you gave me (the shorter version), and WALA! You're a rockstar! Peace.
  11. qqp

    Next incremental number using the current date

    Thanks Andy! I'm working on it! Fingers crossed!
  12. qqp

    Next incremental number using the current date

    Sorry Andy, I posted before I saw any questions. "I am (probably) wrong here, but I see 07 as July (current month), 20-20 as current year 2020, and 01, 02 as consecutive Project Numbers for July 2020 ponder", the example was literally for July 20, 2020. So the first project for the day would be...
  13. qqp

    Next incremental number using the current date

    Ok, now I get 1 for the first record of the day, and no incremental number after that, only 1! AH! Private Sub Command102_Click() Dim vDate, vRet, vNum, vOrder Dim i As Integer DoCmd.GoToRecord , , acNewRec Me.CreateDate = Date 'DoCmd.RunCommand acCmdSave vDate = Format(Date, "mm-dd-yy") vRet...
  14. qqp

    Next incremental number using the current date

    I currently have a query to get the last number for the day. SELECT LastSettingID.LastOfUniqueID, LastSettingsQuery.MaxOfSalespeople, LastSettingsQuery.MaxOfMFGs, LastSettingsQuery.MaxOfProdGrp, LastSettingsQuery.Projects, LastSettingsQuery.MaxOfBidders, LastSettingsQuery.MaxOfStatus...
  15. qqp

    Next incremental number using the current date

    Hi! I'm trying to set a project number in this format 07-20-20-01; 07-20-20-02, etc. I've got it where it will now start at 1 on a new day, but it won't increment to the next number. Using this: Private Sub Command102_Click() Dim vDate, vRet, vNum, vOrder Dim i As Integer DoCmd.GoToRecord , ...
  16. qqp

    Recall last settings function

    Thanks Andy! I don't think I've used the split function before. I'll give it a shot!
  17. qqp

    Recall last settings function

    Sure! I have a list box for Salespeople, the multi select is set to Extended. The filter uses OR between names. For my own sanity I have a text box underneath the list that shows me the actual criteria, just using it until I have everything working properly. I don't use said text box in the...
  18. qqp

    Recall last settings function

    One more question, some of my fields are multi value fields, how should I store them and recall them? Thanks again!
  19. qqp

    Recall last settings function

    Thanks guys! That's kind of what I was thinking as well! Stay well my friends!
  20. qqp

    Recall last settings function

    Good morning! I have a form (ReportParams) that supplies (criteria) values to various reports. End user would like to be able to recall the last values he used. I have no idea how to make this happen for him. Do any of you? I thank you in advance for any insight, and hope ya'll are having a...

Part and Inventory Search

Back
Top