advanced microsoft access courses in london - Forms

The UK's most regular instructor-led training courses.
Training information: advanced microsoft access courses in london · Microsoft access courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Forms

David has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate David [5 posts] (2007 Feb 16 Fri, 10:03) Reply

I asked this question on Monday and have had no answer yet, can somebody please come back to me on this:

"I have built my tables and created a form based on these tables containing dropdown boxes as options for the completion of this form. How do I choose where the information on the form is saved?

ie I have filled in my form, on saving this I want it to save the data in a raw data table that I can then run reports off."

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 20 Mon + 21 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
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
2003	2009 Mar 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 14 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: forms

by - trainer Tom [20 posts] (2007 Feb 16 Fri, 13:28) Reply

Hi David

The form source is where the information information is saved ie the table field that you bound text box control is bound to or the option control you have selected. If you have a field called status and you have a combox box to change the staus then the combo box control source should be bound to that field. Then run report on query based from that table.

Hope this helps.

Regards

Best Training

· Microsoft Access Training Unleashes the Power of the Pivot Table
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Microsoft Access: Unleash the True Potential Today
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Access VBA Training Adds Power to your Databases

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips