Recent content by Good Looking Bloke

Thanks. I did that. Last month the same report ran. I reloaded the same data that ran fine and guess what? Error 5941. This is real test as the data is loaded the report run. The next set of data loaded overwrites the previous data etc.

Well, I am confused, however, the issue is fixed...at least for today. I am confused because although I added a fix, the fix isn't used in the code. What I mean is, I modified to the below: With doc.Tables(doc.Tables.Count) .Select If .Columns.Count <...

Yes I think this is pages width How I read the code, is it is opening a word document from Access and manipulating the properties of the word document. I did a tiny bit of word code years back but it was with bookmarks and forms inside word. Never manipulated it from Access. I am simply last...

As I said this is not my area. I am not following what you mean by this? I also don't understand why it has been working and suddenly decided not to? Thanks

I am helping with a word manipulating Access app written by someone the company lost contact with. This is not my strong area at all, however, most of the time I can sort it out. It's been working well for a while now. Then in the last week, it's suddenly spinning odd errors. Some I have simply...

Thanks I think this the way to go. Bit more work but still thats the way it is. Was going to have issues later pushing this out to merge with other data anyway. Thanks

I would love too...lets all write to the federal government and ask them to change their report...If fields are too long I guess I will have to ask the user to manually transcribe :(

Easy way to learn SQL...Download SQL Server community license is free. Start trying to build stuff - maybe take a udemy course for $12 when on special and learn by doing. After a bit of head scratching and a bit of a learning curve I found it kind of intuitive as long as I think about it long...

I wouldn't do it this way. Try something along the lines of Public gcn As New ADODB.Connection Public Sub cssOpenConnection() 'Open connection With gcn If .State = 0 Then .ConnectionString = "Provider=SQLOLEDB;Data...

Thanks for the suggestion. I have already attempted to merge the questions to generate the headers as in the SQL statement [tlkupSurveyGroup].[Group] & " " & [tblSurveyQuestion].[Question] AS CTHead, however that is what is causing the odd outcomes. I know I cant replicate the excel sheet I am...

I have an automatic again now...Every day I wish I hadn't bought it and had gone the manual route. There is something better with manuals

Sorry what does this mean? Are you wanting the user to change the order of data presentation or the printing order or something else?

This is proving elusive at best...hair removing is probably a better description. I am mucking with a 'survey' I don't actually think it is, but its what its called, so lets stay with that description for the discussion. In Excel the survey data is presented: There are other complications but...

Would passing the workbook in and set on that work?

I am not bad as a hack in Access, however outside it I get very lost very quickly. I have been using some code to export various data from Access to Excel. This is in my Access module: Dim wbook As Object Dim createExcel As Object Dim Wsheet As Object Dim fieldIdx As Integer Dim rowIdx As...