Search results

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.

All I'm trying to produce some system documentation for one of my databases, and I'm struggling to find out how I can get Access to export (or even print) basic manifest information for the tables. For example, when you open a table in Design View, I'd like to be able to bulk-export at least...

Good grief why didn't I think of that. Haven't tried it yet but obviously it will work. Sometimes you just need someone else to point out the bleedin' obvious to you! :banghead: Thanks

Hi guys, Sorry it was difficult to know if I should post this to forms or modules. I have a VBA module which imports data from a CSV file into an import-buffer table. When the data has been imported into the buffer table, the code uses docmd.openform to open a form which shows all the data in...

Thanks. Custom function it is then.

Guys you usually come up trumps and save my bacon so I'm hoping you will again. I'm trying to write a query that will validate a field in an existing table. I want the query to show where any of the 412,000 records fail this strict validation: AAnnnnnnA ...where A is any letter A-Z and n is a...