access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Medium Priority · Version 2003

replyReply 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

For upcoming training course dates see: Pricing & availability

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

http://www.microsofttraining.net/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.

 

Please browse our web site to find out more about
ms-access-course and other Microsoft training courses.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard