Recent content by SallyJenkins

Dang! it broke again. I have no idea why it seemed to work once and not after I restarted the computer.

Hurray!!! It worked. Here's the resulting statement that worked: DoCmd.OpenForm "ClientServicesInput", , , "[Clientid] = " & iContactID Thanks a bunch 1 and all. (BTW, yes, I know that array's are '0' based)

I hope I've posted this issue in the correct forum. ‘ Get the ID from the list box sContactId = Me.lstHusbLast.Column(2) ‘ Convert ID to integer iContactID = Int(sContactId) DoCmd.OpenForm "ClientServicesInput", , , WhereCondition:="Clientid =" & iContactID Please see...

It is the same PDF file. I believe it has to do with the difference between say an HP print driver and Xerox print driver. I've never had this problem before now, just since I have created the pdf's from a MS Access report; within Access. Here's the code. DoCmd.OutputTo acOutputReport...

It is just the image that resizes.

I have created a report that has our company logo printed in the upper left corner. The report is output to a pdf file. When someone opens the report with a different default printer from mine, the logo 'grows'. Is there either a different image file type I can embed into the report, or some...

I have created a main report that is grouped by account id. Within the group account ID footer section there are 3 subreports. The main report and subreports are printing the correct information. My 1 big remaining problem is how to print a conditional page break before the 2nd and/or 3rd...

Super Duper. I will give this a go later on today or tomorrow. Thank you sor the suggestions.

Thanks for the quick reply. I will try the debug and i WILL change the variable name.

I am using MS Access 2012 (MDB). My understanding is that my sqlstatement can be as long as 32,000 + characters. When in debug mode I can see the sql string and when longer the 256 chars it is cut off. Is there some secret switch I need to set to accept longer strings? Also I was getting an...

I'm doing my happy dance! :D I incorporated both suggestions into my code and it is working as designed. Many thanks. Do While Not rsEndStatSumActs.EOF strFundID = rsEndStatSumActs![FundId] strFilename = strPath & strFundID + "1101.pdf" stCriteria = "[FundID] = '"...

I have created a report that uses a table as its record source. I need to create individual pdf files for each fund in this table. There may be 2 to many pages of activity for each fund. Prior to opening the report I query the table to get distinct funid ids. I step through the query results...

I consider myself to be fairly knowledgable about Access. I've been using it for years. There is always something new to learn and that is what keeps things interesting.