Search results for query: *

...I also use the following repeated code to send the same reports for PDF 'Header DoCmd.OutputTo acOutputReport, "rptMainNPlanHeader", "PDF Format (*.pdf)", "" _ & "x:\Nutrifocus\NutriPlan Holding Folder\" & Me.[AccountNameLbl] + (Format(Now(), " ddmmyy")) + " - " & "1 - Header.pdf"...

I have a text box on a report with control source =[ProductName] & " - " & [ProductComment] The font colour of the text box is blue and font size is 14. Is there any way to retain that formatting for [ProductName] but have [ProductComment] in a smaller red font?

sxschech, I was able to do what I wanted using the Call the standard Windows File Open/Save dialog box but I didn't really understand how the code was working. I tried your code as I wanted to see how it works. First error message was stFileName didn't exist. I presumed stFileName has to be...

Thank you for the reply. I don't really understand what is going on but I have been able to do what I wanted based on using this http://www.mvps.org/access/api/api0001.htm

...On Error GoTo ErrorCode Dim MyReportName As String MyReportName = Me.txtReport.Value DoCmd.OutputTo acOutputReport, MyReportName, "PDF Format (*.pdf)", "" _ & "x:\Sales\" & Me.SaveAs & ".pdf", True Exit Sub ErrorCode: If Err = 2501 Then Exit Sub 'ignore error if user...

I have a subform which I use for data entry and editing. There are two tables which are potentially updated and the query behind the form is: SELECT tblSoilAnalysisResults.AnalysisNumber, tblSoilAnalysisResults.FieldCode, tblSoilAnalysisResults.DateOfAnalysis, tblSoilAnalysisResults.LabRef...

That works. When I get a chance I will have a look at MajP's suggestion to avoid the error rather than trap it. Thank you both for your help.

...cropping year then don't print manure charts If intstore2 = 0 Then 'Header DoCmd.OutputTo acOutputReport, "rptMainNPlanHeader", "PDF Format (*.pdf)", "" _ & "x:\Plan Holding Folder\" & Me.[AccountNameLbl] + (Format(Now(), " ddmmyy")) + " - " & "1 - Header.pdf" 'PLAN DoCmd.OutputTo...

I am using the inbuilt PDF creator in Access 2007 to generate some of my reports however some of the files sizes are quite large. If I use a website such as http://smallpdf.com/compress-pdf to compress the file it always manages to reduce the file size sometimes quite dramatically. Are there...

Hi 1DMF, both front end and back end are in Access 2007

Thank you for the responses. I can understand that a query reduces the record set and also that using code is easier to test but as my DB is not huge and I have not seen any discernible performance difference between the two methods I think I will stick with the query route as it is a bit...

After much googling I have found 2 ways to create a dynamic search form which works for me. In the first method the search box on the main form updates a hidden text box on the main form which is then used in a parameter query to fill the sub form. In the second method the code behind the...

Yes that works for me, the spacing and positioning of the commas are all good and it now handles single values.

You were correct, it was a single value.

OK, thanks Duane, just trying to get ready for the week so will have a look tomorrow night. The strange thing is that it was all working, or so it appeared yesterday.

Unfortunately I am now getting a run time error 5 message Invalid procedure call or argument and debugging highlights these 3 lines strConcat = Left(strConcat, _ intLenB4Last - Len(pstrDelim)) _ & pstrLastDelim & Mid(strConcat, intLenB4Last + 1) Any suggestions please as to what to do next?

Thank you PHV. I have given a star to dhookom for his original code and I have tried to give you 2 stars for taking the time to help me through this but I think I can only give one. Thank you

Thank you PHV, almost there. That code works except that it cuts the last letter off the customers name before the "and", i.e if there are 3 customers it cuts the last letter off the 2nd name, if there are 4 customers then it cuts the 3rd name and so on. Have you seen this before? Any...

OK, so I deleted the old module, went to Duane's link and copied and pasted the text into a new module and compiled it, with no errors. Ran my query, which works but the result is still "Customer 1, and Customer 2, and Customer 3, and Customer 4" which has too many ands and an extra comma. I...

Hi PHV, unfortunately that takes me back to the "wrong number of arguments" error message.