Recent content by henniec

Good day, I am not sure if you are trying to copy all the records of a query to a spreadsheet in Excel. There is an easier method and more effective than the one you are using. The whole section you use to transfer data to Excel can be reduced to few lines by using .CopyFromRecordset. You need...

Thanks for all the replies. MajP was right with the Alt/printscreen. I tried ctrl/printscreen and it obviously did not work. This method dates back to atleast Access 95 where I used it for the fist time. Setting the property to popup release it from Access that enables ALT/printscreen to...

Good day, In Access 2003 there was a method to capture a form and paste it into Word with out the need to do any crop work in Word. Only the form was captured and not the screen. Is there a similar method in Access 2007? Thank you. Hennie

Hi. I received this one line fuction several years ago to zip a file. If you can export your table to a file using something similar to the first function and then use the second function to export it to a zip file. I export the table "sample" to an XML file and then to a zipfile...

Hi, With all the problems you had with this code, can you create a query that would give you what you need? I cant remember what solutions I found regarding your last "error 91: Object variable or With block variable not set". I found in many cases its far easier to create a make table query...

Hi Pat, I think PHV gave you the information you need working with one worksheet and I do believe your code is working. Below I added some additional information should you need to work with more than one worksheet in a workbook. For some projects I have about 10 worksheets and it become...

Its a pleasure. I think you will find there is less hassles. I assume all the other declarations has been done Use it as a With objSht (your spread sheetname). Hennie

Hi Pat, Why don't you declare a recordset and the set your record set eg. Dim rs As Recordset Do the necessary to open your Excel file and set the Worksheeet. Set rs = db.OpenRecordset("output_query_1", dbOpenSnapshot) And then use the function .Range("A2").CopyFromRecordset rs I...

I change everything to numbers as I mentioned yesterday and it seems to work. Will in the future run the dates as numbers and only in the final query or report format it as a date. Thank you for your input and our discussion around the date. Hennie

I do understand the conscept of the date. The fact remains if that if you need to do an average based on a day you cannot do it on the day value. The day value must be a whole number as the decimals change with every second. The same is true if you need to extract data on an hourly basis...

Thank you for your replies. Here is the sql. SELECT Ozone1.SampleDate, Ozone1.SampleTime, Ozone1.CCW, Ozone1.Tempering, Ozone1.LPSW12, Ozone1.LPSW34, tblOzone.[ORP-1&2], tblOzone.[ORP-3&4], tblOzone.AuxSW FROM tblOzone RIGHT JOIN Ozone1 ON tblOzone.SampleDate = Ozone1.SampleDate; Date is...

Good day, I have a query where I link two queries as a one to many. I have done similar queries in the past and every now and then I would find one where it would only give data from one table or query and not the other. I have tried different scenarios and still the same thing happens...

I experience the same type of problem but it does not make a difference if I use a sql in code or the actual select query. When I change the query into a make table query and set the table as the recordset I can carry on with the rest of the work. What would make the difference? Nothing has...

I think you are approaching the table or form from the wrong direction.Wat you need to do is create two different tables - one for the store and one for the city. For each store and city you need a Primary ID number. In other words two fiels for each table eg IDStore, StoreName and IDCity...

Thank you. I will try and see what happens.