Search results

The person has 4G RAM and yes custom fuctions are used.

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?

Thank you both for the reply. I took the suggestion from another site and linked a blank spreadsheet directly to the query for export. I will try both of your suggestions so that I have them for future reference.

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

Sub or Function not defined on "ExcelCodes". I do not know what this means in order to define. I have search with no results exSheet.Cells.Range(Chr(64 + LEFTMOST_COL) & HEADER_ROW,ExcelCodes[/COLOR][/U][/B](NoOfCols + LEFTMOST_COL - 1) & HEADER_ROW).Interior.Color = VBA.ColorConstants.vbMagenta

Forgot to check the references. Got it. Thank you Cronk

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

Thank you both. Trying to get this Access thing figured out.

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