Search results

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

Yes the implied queries are triggered by a batch job and called from the scheduler and the User/Account has the appropriate permissions. The job and output are working properly. The files are created and placed in the proper location.

I do not know that defining the SPEC would be the issue since it worked for the last 4 years until today, that is unless the object library updates changed that.

The files compile and are placed in the designated location correctly by the job on the network. When a remote used "Syncs" their application to the server copies of the files are downloaded to the local client. At the end of the "Sync" the local client application imports the text files to a...

I have a program that builds a text file from a query and places it on the network for download. There are other users who have a different application that when a button is pressed they pull in the text file and it automatically imports the txt file into a table. Well overnight this process...

I would like to add the "Month" of the information queried to my file name at export if possible. I included my current code and an example of how I would like the title to read. DoCmd.TransferSpreadsheet acExport, 10, "tblStarzIncentivePayoutExport", "C:\StarzExports\Incentive Payouts" & " " &...