Search results for query: *

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

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

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

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!

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

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!

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

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

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

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.

Thanks Andy! I'm working on it! Fingers crossed!

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

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

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

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

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

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

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

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

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