Search results

Thanks, pbaldy! Was pulling the current date last week, but got the DLookup working today in my VBA code. This was awesome...thanks so much for the help!

If I wanted to add the date to my pdf name and pull that from another table, how could I add this to my code? It is a table called "PC" and the date is "M_Date". Thanks again! Function PrintReports() Dim sql As String Dim db As Database Dim rs As Recordset sql = "SELECT TERRITORY, CODE...

SOLVED: Function PrintReports - "Too Few Parameters" ERROR OMG, I can't believe I overlooked that when reviewing my code. One of the underscores is actually a dash. Thank you so much!

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

Wow, that was really beyond my vba knowledge. Might take me a while to work through, but thank you so much for the reply!

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

Thanks for the clarification! I see what I did now. I had it saying Private Sub and then Function (with my copied code), so obviously I only needed the Sub part. I deleted the unneeded code and it runs perfect. Thanks for pointing me in the right direction!

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!

Me too!!!!

Yes, I couldn't get that to work and then it ran fine without it.

Function PrintReports() Dim sql As String Dim db As Database Dim rs As Recordset sql = "SELECT AFO_NAME FROM AFO_CODES" Set db = CurrentDb Set rs = db.OpenRecordset(sql, dbOpenSnapshot) Do Until rs.EOF DoCmd.OpenReport "Rpts_by_AFO", acViewPreview, , "[AFO_Name]='" & rs![AFO_NAME] & "'"...

Thank you all for your help! I was able to troubleshoot with your help and some other posts. Have a great day!

Welcome to the forum!

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.

There are no nulls but tried it anyway, still getting the #type! error. Thanks anyway for the suggestion!

Thanks, RuralGuy...that solved my sql error! However, I am back to running 102 reports with #Type! error. To answer the other post on what am I trying to do, I have one report that is 197 pages. It is grouped by AFO_NAME and under each group is a list of team members. I wanted to print this...

No, that was not a typo...so thanks for the help! I made that changed and now I get a popup box that says "Enter Parameter Value: sql". Is something wrong with my SELECT statement because of that error?

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