Connecting Tech Pros Worldwide Forums | Help | Site Map

Acess visual Basic

Newbie
 
Join Date: Sep 2009
Posts: 1
#1: Oct 1 '09
Am creating a search engine for an acess database and am having problems in giving some codes right,eg is how to give a right code for on click event on the form.i really need your help.

Newbie
 
Join Date: Oct 2009
Posts: 6
#2: Oct 2 '09

re: Acess visual Basic


in design view, if you right click on any of the components and go to 'properties', you have a drop down menu at the top where you can choose the components whose properties you wish to set. If you e.g. choose 'Form' and go to the event tab, you can see the various events for which you can attach some code. E.g. if you click in the 'on click' field, and click on the [...] button, and choose 'code builder', you can attach some code to this event.

Another way to browse the possibilities if you are already in the vba editor, is to type something like 'Me.some_field."; after the second '.' the editor brings up a list of the possible properties (most should have intuitive meanings). you can then check out a few of these in the 'help' search. To the the possibility on the form itself you can type 'Form.'.

hope this helps.
Reply