Search results for query: *

Thanks for the example and link - I was not to clear on ADOX, but example made sense and I will try it

I am trying to convert some code in DAO to ADO in Access and I am having trouble with creating something similar to the CreateQueryDef command. Here is the code using DAO: Sub ExportExcel() Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Dim sqlstr As String...

Yes, I am writing two chunks of data consisting of 19 lines each to each page. Each page is 57 lines long. I had not tried it using the modulus, but I did get it to work finally. Your solution is much cleaner than what I came up with (as you can see) so I will probably switch to a check using...

Hello, I need to make a report using an Excel Macro that will write to a new page when the previous page is filled. I set up a For Loop to go through records in a dbf which will determine the number of pages to write out to. This is what I have written to test whether or not to go to the next...