Getting nr of records before executing

[Johny]

Hello,

I'd like to retrieve the number of records of a make_table query before executing the query. Kinda like manually opening the query in design mode and changing the view to dataview then just look at the total numbers of records.

Anyone?

 

[edtab]

How about creating a select query with all your required parameters then
via a msgbox, using Dcount() and the select query as your domain, pop up
the number or records on the screen, then ask a question, whether to
proceed with the maketable query? If the answer is "Yes", run the maketable
query, else, exit sub.

Caution - I haven't tried this, but I think it will work.