Recent content by NeilT123

I use the following code to send a number of reports to my printer. There are about 16 reports in total, I have reduced the code just to keep things simple. Private Sub CmdPrintFullNutriPlan_Click() 'Main Folder 'Soil Analysis Results for NutriPlan DoCmd.OpenReport...

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

I am using Access 2007 and the following code to generate and save a PDF. The PDF is automatically saved in the Sales folder but is there an easy way to open the "file save as"/ Explorer window (sorry not sure what it is called) prepopulated with the me.SaveAs as the file name so that the 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.

I have a form from which I print or PDF my reports and one button on the form I use creates a whole load of PDF reports using the code below. Most of the reports have code in the NoData which is fine for when the report is opened individually but this means that if I run the full code and a...

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.