Search results

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

I am getting an error message when printing a 2 part report. It does not appear until I have already printed the first part and I am ready to print the second. I have 6 users and all seem to experience intermittently with the exception of 1 who it is constant. The message is as follows; "There...

I am looking for a good book either print or preferably downloadable ebook that explains how to use Access 2013/Office 365 and Share Point together. Any suggestions?

I am getting a error about a 65,000 limitation for export. Does anyone have a work around for this? I read about changing to export without formatting but I do not think I have it being formatted at all. I included my code below so you can see how I have it set up. Private Sub Form_Open(Cancel...

I have recently taken over a DB that is supposed to export tables out to excel. When I run the code it stops at "Dim exApp As Excel.Application". I have included the code below if anyone can help. Option Compare Database Option Explicit Sub ExportData_Sheet_Intermed_A() On Error GoTo...

I am trying to split the year into thirds instead of the quarter. I will be needing to set the criteria to only show me the previous year from the current year. Can this be done in one query?

Does anyone know how to set up a trimester query instead of a quarter? DO I need to do it in VBA or can I do it as a criteria? I am trying to query historical data into previous year trimesters. Jan-Apr, May-Aug, and Sept-Dec. Any help or suggestions would be greatly appreciated.

Hello everyone. My name is David and I am from Phoenix Arizona. I am relativity new to Access and have taken some classes but ultimately I am one who learns by doing. I have used this forum many times and finally decided to join. Looking forward to reading some helpful threads and participating...