Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel query
I have 2 sheets in a workbook that import data from an access on refresh. One
works and the other one doesn't. I keep getting "disk error". I would like to delete the query and start over. How do I do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel query
hi,
are you using microsoft query???? if so then right click the query range and click data range properties. on the property box, at the top, uncheck "save query definition" chick ok. you will get a warning about permanently removing query. chick ok. gone. non reversible. Regards FSt1 "Oldjay" wrote: I have 2 sheets in a workbook that import data from an access on refresh. One works and the other one doesn't. I keep getting "disk error". I would like to delete the query and start over. How do I do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel query
Thanks that deleted the query but when I tried to setup a new query and got
to Save query I got an error message "The MS Office access database engine couldn't find the input table "mdb.substrates" Make sure it exists and that it spelled correctly. It look to me that it should be looking for "substrates.mdb" but I don't know how to change it "FSt1" wrote: hi, are you using microsoft query???? if so then right click the query range and click data range properties. on the property box, at the top, uncheck "save query definition" chick ok. you will get a warning about permanently removing query. chick ok. gone. non reversible. Regards FSt1 "Oldjay" wrote: I have 2 sheets in a workbook that import data from an access on refresh. One works and the other one doesn't. I keep getting "disk error". I would like to delete the query and start over. How do I do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel query
hi
not sure what method you are using but if you go through the menu to create the new MSQ... declare your data sourse ie mdb, xls, other and from there you should be promped to brouse to the data base. once selected, it should show the the available tables and the available fields after that. regards FSt1 "Oldjay" wrote: Thanks that deleted the query but when I tried to setup a new query and got to Save query I got an error message "The MS Office access database engine couldn't find the input table "mdb.substrates" Make sure it exists and that it spelled correctly. It look to me that it should be looking for "substrates.mdb" but I don't know how to change it "FSt1" wrote: hi, are you using microsoft query???? if so then right click the query range and click data range properties. on the property box, at the top, uncheck "save query definition" chick ok. you will get a warning about permanently removing query. chick ok. gone. non reversible. Regards FSt1 "Oldjay" wrote: I have 2 sheets in a workbook that import data from an access on refresh. One works and the other one doesn't. I keep getting "disk error". I would like to delete the query and start over. How do I do this? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel query
I already did all of that. Ihe error comes after I have finished all the
items in the wizard and click export to excel or Save query "FSt1" wrote: hi not sure what method you are using but if you go through the menu to create the new MSQ... declare your data sourse ie mdb, xls, other and from there you should be promped to brouse to the data base. once selected, it should show the the available tables and the available fields after that. regards FSt1 "Oldjay" wrote: Thanks that deleted the query but when I tried to setup a new query and got to Save query I got an error message "The MS Office access database engine couldn't find the input table "mdb.substrates" Make sure it exists and that it spelled correctly. It look to me that it should be looking for "substrates.mdb" but I don't know how to change it "FSt1" wrote: hi, are you using microsoft query???? if so then right click the query range and click data range properties. on the property box, at the top, uncheck "save query definition" chick ok. you will get a warning about permanently removing query. chick ok. gone. non reversible. Regards FSt1 "Oldjay" wrote: I have 2 sheets in a workbook that import data from an access on refresh. One works and the other one doesn't. I keep getting "disk error". I would like to delete the query and start over. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
Disabling 'Cancel' option when saving work (Yes/No/Cancel) | Excel Programming | |||
Cancel button to cancel the whole macro | Excel Programming | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming | |||
cancel query refresh - vb | Excel Programming |