microsoft access courses in london

microsoft access courses in london - Forms

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 12 Mon, 09:24) Reply

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 Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Forms

by - trainer David gold contributer [428 posts] (2007 Feb 16 Fri, 13:53) Reply

Hi David

I hope you found all your Microsoft Access courses useful and again sorry for the delay in getting back to but as you can appreciate our trainers are very busy at the moment.

You will find that you post has now been answered, and it can be found at:
http://www.microsofttraining.net/post-1592-forms.html#1592

Hope this helps

David

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Why consider Access Visual Basic training?
· The Benefits of Certified Microsoft Training in Access
· Material covered on a Microsoft Access Course

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report