R
ryan.fitzpatrick3
I have a query where I make a table. It works fine but I get a prompt
on everything saying do I want to delete table, you are posting x
records, etc, is there away to bypass those message boxes, so it'll do
it automatically? Because I want to make a macro to run a qrytbl which
posts results to a table then run another qrytbl and another, i have
like 10 in a row that I want to pull. I want to leave on at night and
have it run during the night so when I get back in the morning it's
all done. Is this possible, and currently I have that access tbl dumb
into excel ( i know it's excel, but I need it this way). Is there
excel vba code to pull and trigger an access macro and dumb that qry
results into excel, or is the way I'm doing it the best way, which is
doing a qrytbl, and using vba in excel to pull that table into excel?
ryan
on everything saying do I want to delete table, you are posting x
records, etc, is there away to bypass those message boxes, so it'll do
it automatically? Because I want to make a macro to run a qrytbl which
posts results to a table then run another qrytbl and another, i have
like 10 in a row that I want to pull. I want to leave on at night and
have it run during the night so when I get back in the morning it's
all done. Is this possible, and currently I have that access tbl dumb
into excel ( i know it's excel, but I need it this way). Is there
excel vba code to pull and trigger an access macro and dumb that qry
results into excel, or is the way I'm doing it the best way, which is
doing a qrytbl, and using vba in excel to pull that table into excel?
ryan