Recent content by Dirtrider929

Thank you @theDBguy. I will check these out.

Yes, I have a full version.

I have a process that compiles pay reports for over 200 employees. These reports vary in size and get saved in PDF format and emailed to the users using an automated process monthly. Now with the current state of the world and everyone working from outside of the office I need a way to make a...

I moved the argument to before the Group By and you are correct, the names are StartDate and EndDate so I left them in as you wrote it and I am still getting an error. I've tried changing arguments, column names, month selections to get it to work but I must be overlooking something.

Query SQL code: SELECT MasterCalendar.Supplier AS Supplier_Name, MasterCalendar.Description AS Offer_Description, MasterCalendar.Offer, MasterCalendar.Start, MasterCalendar.End, MasterCalendar.Guidelines, MasterCalendar.Comments, MasterCalendar.[X-Recinded], MasterCalendar.RecindedDate...

No, I had a laps in brain function after working on this for so long and trying so many different things. After adding it to the proper place I get a syntax error.

Now its on the "Where". Did I do something wrong? WHERE DateSerial(Year([StartDate]), cboMonth, Day([StartDate])) >= [StartDate] And DateSerial(Year([StartDate]), cboMonth, Day([StartDate])) <= ([EndDate])

Getting and "Expected : end of statement error on "Between". WHERE DateSerial(Year([Start]), cboMonth, Day([StartDate])) Between([StartDate]) And ([EndDate])

This will give value to the months in between the two dates? Say I have a program that is available Jan 1 through May 31 and I use my combo box to select April as the month, will the code above populate the program as being available for the month of April?

Yes, I need it to tell me what month values are available between the start and end date values.

I have a combo box, cboMonth, on a form the contains the calendar month name and numeric values. I am running a query,"qrySLR_Master_Calendar", within the form, "frmSLR_Master_Calendar", that contains data including a "StartDate" and "EndDate" which could span 3-11 months. I would like to be...

I have one other step I would like to know how to code in reference to this topic. This worked great for what I needed with one caveat, it allows duplicate records to be created for the same [Offer_ID] in my table. How can I get it to look for an existing record using [Offer_ID] and open the...

I have some code that loops through a list box to add values selected to a table and it is getting stuck where I think it should be working, "For I = 0 To lstScan_Items.ListCount - 1". Can anyone point out where the error is? I have been stuck for a few hours. Private Sub...

I looked at the error message and it is as confusing as the message itself. Yes both files get created and placed in the proper location. I verified that the output of data and everything appears to be in the same delimited format as the old file. I then checked the order in which the file...