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
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
