| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update prompt message
I have a spreadsheet which retrives data from Access database using ADO.
I got message to confirm update all the time, but the retrive data code is on button click. Is Excel smart to know that there is link database even the retrive code does not run? Can you just set the message off? Any information is great appreciated, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
update prompt message
Look up DoCmd.SetWarnings False in Access help - that will turn your warnings off be sure to turn it back though I think there is a UI version under tools options too. cheers Simon -- Simon Murphy ------------------------------------------------------------------------ Simon Murphy's Profile: http://www.excelforum.com/member.php...o&userid=26538 View this thread: http://www.excelforum.com/showthread...hreadid=398016 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prompt to Save Message | Excel Discussion (Misc queries) | |||
| help with message prompt | New Users to Excel | |||
| Message prompt in VBA | Excel Programming | |||
| Disable Message Prompt in VBA | Excel Programming | |||
| Deleting a Prompt Message | Excel Programming | |||
Linear Mode
