access vba - Formula bar

Resolved · Low Priority · Version Standard

Formula bar

Anies has attended:
Excel Intermediate course

by - delegate Anies [2 posts] (2007 Dec 13 Thu, 08:58) Reply

how do i get the formula bar?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	5	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: formula bar

by - trainer Pete platinum contributer [803 posts] (2007 Dec 13 Thu, 16:25) Edited on 2007 Dec 13 Thu, 16:26 Reply

Hi Anies, Thank you for your post, In answer to your question;
The Formula bar should be displayed by default, however if it is not showing you can switch it back on by; Click on the Menu Command Tools, Options and in the View Tab you will see a radio button for the Formula Bar, click in this circle to select it, Click OK and your Formula bar will be displayed. I hope that helps, best regards Pete

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access: Unleash the True Potential Today
· Take an Access Course to Learn About Relational Databases
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access Beginners' Training: Getting to Grips with Databases

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