microsoft+access+training - VBA

The UK's most regular instructor-led training courses.
Training information: microsoft+access+training · Microsoft.access.courses · VBA courses London UK

Resolved · Low Priority · Version Standard

VBA

Suman has attended:
Excel VBA course

by - delegate Suman [1 post] (2007 Aug 24 Fri, 09:37) Reply

Is it possible to produce a form which allows another person to select items from a drop down menu of lists, charts,tables,etc/

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	7	book now	£345	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: VBA

by - trainer David gold contributer [428 posts] (2007 Sep 5 Wed, 12:17) Reply

Hi Suman

Yes this is possible, however I am not sure if you will be able to select data from a chart. But for all the others, you will be able to write some vba code that will enable you to achieve your goal.

Hope this helps
David

· Access Database Optimization: First Normal Form
· Learn about Subqueries in Access Courses
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Microsoft Access 2007: New Features
· Why a Microsoft Access Course Could Change the Way You Do Business

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips