L
Legacy 3234
Guest
I am pretty good at Excel VBA but not too well versed in Access vba.
I have a form. I set up a button on the form (using the wizard) to run a macro.
The first thing the macro does is run a make-table query.
If the query is going to paste more than 65536 records to the table, I need to display a message and exit sub. I've searched far & wide and have no idea where to begin. Can anyone offer some advice?
I have a form. I set up a button on the form (using the wizard) to run a macro.
The first thing the macro does is run a make-table query.
If the query is going to paste more than 65536 records to the table, I need to display a message and exit sub. I've searched far & wide and have no idea where to begin. Can anyone offer some advice?