Recent content by Dachande11

Hello, I have been trying to find a way of searching through some records in Excel (test data in Data worksheet), and then displaying the results of the search in a list box. Whilst searching various sources on the internet I came across a partial solution which is shown on attached workbook...

Thanks for your constructive help there. Maybe I am just confusing myself but the idea is that I do a daily sales tracker and to start things off I need to have all the working days in a month. Now I could manually do this every month but I am looking to automate this report. So I have my...

Hello, I am trying to find out if there is a way for me to create a table based on a specific month. For example I might select January 2005, I would then want to create a table with all the days of that month included, so that I could then add specific data to each day. Is there a way that I...

I ended up setting the reports default printer to a PDF and then opening the report on a docmd.openreport, acviewnormal command, so that by default it printed to my documents. Thanks Mark

Hello, I had a similar problem. I was wanting to copy and rename a PDF as it was printed but had the problem of a file not being there to copy as it was still waiting for it to print. In the end I used the sleep function which I found on this forum and it works great, so long as I give access...

Thanks very much ghudson, that works great now. Mark

Hello, I am trying to copy folders within code and thought I had the answer in the following code which I found on this forum. Dim fs As Variant Set fs = CreateObject("Scripting.FileSystemObject") fs.copyfolder "C:\Documents and Settings\szymkm\My Documents\test", "C:\Documents and...

Hello, The code below copies files, and then deletes the original which effectively does what you require. You just need to pull in the information from your table, probably by setting it as a recordset and then pass the names over as variables. Dim strFileOldName, strFileNewName As String...

I have spent a day messing around with the Ken Getz code which deals with Win.ini and 5 different modules. This was a bit above me and I later found out that it might not be suitable for anything above Access 97. So my solution is below. I set the report to always print to PDF in My...

Hello, I have spent a day messing around with a similar problem. I too started looking at the Ken Getz code which deals with Win.ini and 5 different modules. This was a bit above me and I later found out that it might not be suitable for anything above Access 97. So my solution is below. I...

Hello, Thanks for your reply. I have run the report manually and printed it to a PDF file so I know that it does work manually, the link you gave me to the Ken Getz code is what I am using unsuccessfully at the moment. I really dont have a clue what I am doing wrong. Thanks again Mark

Hello I have been searching through this forum to find a way of exporting a report to a PDF file. I have found the answer and tried to get it to work but keep getting an error 2202 (you must install a printer before you print etc.). I was wondering if anybody knew what I was doing wrong as I...

Never mind I have gone about this a different way.

Hello, I am creating quite a complicated report and need to pull some information from a query for calculation purposes. I could use the Dlookup function but this would make the report slow and since the report is run and exported 400 times for seperate customers this would compound the...

Hi, I was just wondering if this solution worked for you as I do not quite understand what Harry is saying. Thanks Mark