Recent content by J_Orrell

Marked thread as solved, thanks for help

That worked for me, thanks! I had no idea there was a DoEvents command. :cool:

Afternoon folks. Apologies if this is the wrong subforum; as always in my case, this question could be either construed as a form question or a VBA question, for once I've stuck it in the VBA section. A button's On Click event on one of my forms runs a For...Next loop that I want to break out...

Thanks for your help guys, I'm sure I can cobble together a solution that works best for me from your suggestions.

Guys...quick question. I know how to export an Access query to a new Excel spreadsheet using the DoCmd.TransferSpreadsheet method, but is there a way to make a new tab in an existing spreadsheet and export it to that? If not, then my users are just going to have to put up with copying data from...

DOH!! Why didn't I think of that! Naturally it worked. Thank you!

Thanks for the ideas and the link. Unfortunately it doesn't work like that for me. Simple test of: Private Sub Form_Current() MsgBox "Hello" End Sub ...has the 'Hello' still appearing before the form is drawn. I can see I'm going to have to stick the code in a button-control on the form. It's...

Sorry guys, second question of the week :o I've got some code that I want to run automatically when the user opens a form. The code updates a progress bar control on the form, so I need the form to be fully drawn before the code runs. So far I've tried On Current, On Load, and On Open, all of...

@arnelgp thanks for your help, but fixed as per my post prior to your most recent.

Fixed it!! I am a blithering idiot. I didn't even think of mentioning that this was part of an ancient Access database that creates said spreadsheet using the 'TransferSpreadsheet' method from a query, and it was using the 'acSpreadsheetTypeExcel5' argument, and of course...

@arnelgp thanks for that, I have tried it. Although your code is neater than mine the two conditional formatting lines are just as much ignored in your code as they are in mine.

all that returns is a syntax error.

Struggling with something that should be obvious. I'm trying to open, format and save an Excel spreadsheet in the background from Access. Everything's working fine other than the conditional formatting lines. They don't return an error but they simply do not work for no reason I can figure...

Thanks for the very swift replies. I'm going to go ahead and mark this as solved. Unfortunately I cannot download Ranman256's tool for security reasons, but I can work with the Database Documenter, which I hadn't seen. I can see its outputs are quite verbose but exporting it and removing what I...

@Ranman256, unfortunately I'm using this forum from work and my employer (large UK government department) blocks the download of internet-based attachments to work PCs. @Ridders, thanks I'll have a look at that.