Recent content by AbsoluteAccess

Which records are you wanting to delete. The ones from the main database after you archive them?

Have you you tried putting the extension on the file name? Eg DBName.accdb

I have a fair bit of automation working with a particular site from Access 2010. Most of it is working perfectly except for the onChange event for a selection box. I change the value with: ie.Document.all("StandardGameCountSel").Value = 18 The value is updated but the event...

Weirdest thing. After fighting with this for a good part of the day and getting nowhere, it seems to have fixed itself. I hate it when that happens because it's always nice to know you fixed it and it will work unconditionally. Thanks anyway.

What data type is the lesson number in the table. Is it a number or text? Post the sql for your query.

What is the error you are getting?

Would a msgbox do the trick for you? eg if msgbox("Would you like to add another?" & vblf & _ "Click Yes to add another or No to continue.",vbyesno+vbquestion,"Add Another?") = vbyes then 'Do something Else 'Do something else End if

Thanks for the reply but I don't think the column widths has anything to do with my problem. My problem is that in the first row, I have the text displaying vertically. The spacing between each letter is quite wide so instead of the row being around 2-3 cm in height, it is 5-6cm in height. In...

I am exporting data to a new Excel spreadsheet and everything is working ok except for the formatting on my first row. I am setting the orientation to vertical and am not having any luck with getting the text spacing correct. It is too big. This is my code: Dim xlapp As Excel.Application...