Search results

Hello! I have one report I'm trying to run through VBA that will output 500 territories in own PDF (so 500 PDFs when done). Help needed with error saying "Too Few Parameters". Here is what I have for my VBA...any help you can offer is GREATLY appreciated! Function PrintReports() Dim sql As...

I have a DCount Ranking query that worked fine last week and with this week's data came up with a glitch. Here is my DCount statement in the query: Rank: CInt(DCount("*","qry_YTD_Territory_Totals","[Total]>=" & [Total])) Here is my result which you can clearly see is not a tie. Any assitance...

Currently I have five separate reports setup in Access 2010 (that are running off of five separate queries). Since they have different data/fields, I was unable to combine into one query & one report. However, I print each to PDF and then combine using Acrobat Pro. Is there a way to combine in...

I created a VBA module called Module_1 and wanted to have my form button run this when clicked. I have a Command_11 button and went to On Click > Event Procedure > Code Builder. What do I enter there? When I copy my VBA code in, that doesn't seem to work. Any help is much appreciated!

Hi everyone and Happy 2013! I just started this week on the Access Forum and everyone has been so helpful! I've been using MS Office for most of my career and have spent plenty of time using Access. I'm new to SQL and VBA just this past year, though.

Hello everyone! I’m new to the Access Forum and was hoping someone could help me. Although I’ve been using Access for many, many years, I am a beginner with VBA. I found a web forum that referenced how to print multiple .pdf files from only one report. My report has 102 AFO_NAMEs, so I’m...