98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Medium Priority · Version 2003
Fri 23 Jan 2009, 16:13Delegate Ashley said...
Ashley has attended:
Access Intermediate course
Access Advanced course
Access
I run a macro that has to run make-table queries and then chart them in a form for a set of date parameters which are drawn from a field in a form. BASICALLY.. it pops up with alot of do you want to overright previous table.. are u sure etc.. is there any way of writing in a code to say answer yes automatically? Cheers
Wed 28 Jan 2009, 09:48Trainer Rajeev said...
RE: Access
Dear Ashley
Thank you for attending Access Advanced course!! I hope you enjoyed the course and benefited from it.
Normally the messages appear for safety reasons and ensuring that the user hasn't made the choice by mistake. It is mainly there for cancel the action if required.
I assume this is possible by entering VBA code but unfortunately I am not very experienced with VBA in Access so I'll pass on this post to one of my colleagues who may have more knowledge and experience with VBA.
If you need to know the content of our Access VBA courses as well as schedule then please refer to the following link:
Please note that it is a two day course!
https://www.stl-training.co.uk/ms-access-training-courses-in-london-2003-vba.php
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Tue 3 Feb 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Random samplingData is th key to a good database, therefore checking is essential. |
