Access 2007 Help

jancemord, Oct 26, 8:14pm
Please see http://jzm.co.nz/Files//Images/Access. png. What I want to do is all the above fields I want them to add up in the total box - once this is done the other boxes should be easy. How could this be achieved.

gyrogearloose, Oct 26, 9:05pm
Press F1 for Access help, and then type in your question and press the search button.


bluedemon, Oct 26, 9:46pm
1 click on view, that will bring you into the design view
2 double click on "Total text box" it will bring up the total text properties box.
3 click Format and use the drop down arrow to find ???Currency???
4 click on ???data tab???
5 click on ???control source??? it will bring up a drop down arrow and three dots icon. "click on ???three dots icon???
6 that will bring you into Expression Builder
- once you inside the expression builder
7 click "=" and then choose the text box number you wish to add. from the "<Form> field" (each text box has its own number. )
eg =[text0]+[text2]+[text3]etc. . .

eg Slingshot text box should have a "number or name" to find that out you need to go back to design view and click on properties, that will show you the text box number or name.

have fun. . .

eurika, Oct 26, 9:47pm
Tried http://jzm.co.nz/Files//Images/Access. png. but no page. If you are summing differnent feilds the do it in a query for example in query design view enter "Field1+Field2+Field3&quo-
t;

jancemord, Oct 26, 9:54pm
http://jzm.co.nz/Files/Images/Access. png

jancemord, Oct 26, 10:05pm
Thanks Blue, I have entered = [Accounting] + [ACC Levies] + [Entertainment 50%] + [Slingshot] + [Assets] + [Fees] + [Cartage] + [Insurance 25%] + [Insurance] + [Lease] + [Materials] + [Mobile] + [Phone 75%] + [Power 25%] + [Subcontractors] + [Stationary] + [Rates 25%] + [Livestock] + [Repairs & Maintanance] + [Fuel] + [Travel] + [Vehicle]but I get told its to long. What do I do now?

eurika, Oct 26, 10:05pm
Ok you need to go into design view for the form. select each text box and search it's properties for it's name and take note. once you have found the names of all the text boxes you want to sum, create a new text box. Go to that boxes properties and find the field thats refers to the data source. Type in each textbox name with a plus sign between each. Been a while since i build a db so if that does'nt work the enclose the name of each textbox with quotes e. g "textbox name" good luck

mrtoken, Oct 26, 10:06pm
if you like, zip it up and send it to me, username @ gmail place, just leave a message when you have as i dont check that box offen

bluedemon, Oct 26, 10:27pm
hey it should all fit in. . . i have just tried to add 30 text box name in. yeah make sure each the text box name is correct. . . .

gyrogearloose, Oct 26, 10:47pm
My suggestion is that it would be easier to do this in Excel, rather than Access. You could just use the Excel SUM(. . . ) command, and adding new expenditure analysis would be much simpler. For example, if you changed from Slingshot to any other ISP, or added [Depreciation] or any other category, you would need to edit the Access code instructions that you are asking help with.

jancemord, Oct 26, 11:13pm
it is currently in excel - doing it for my aunty as she keeps on getting confused and deleting the functions - once I do it once I will have the hang of it

jancemord, Oct 26, 11:16pm
You have mail

mrtoken, Oct 26, 11:35pm
cheers, i will have a look at it when i get home (around 3)

jancemord, Oct 26, 8:14pm
Please see http://jzm.co.nz/Files//Images/Access.png.What I want to do is all the above fields I want them to add up in the total box - once this is done the other boxes should be easy. How could this be achieved.

gyrogearloose, Oct 26, 9:05pm
Press F1 for Access help, and then type in your question and press the search button.

bluedemon, Oct 26, 9:46pm
1 click on view, that will bring you into the design view
2 double click on "Total text box" it will bring up the total text properties box.
3 click Format and use the drop down arrow to find ???Currency???
4 click on ???data tab???
5 click on ???control source??? it will bring up a drop down arrow and three dots icon. "click on ???three dots icon???
6 that will bring you into Expression Builder
- once you inside the expression builder
7 click "=" and then choose the text box number you wish to add. from the "<Form> field" (each text box has its own number.)
eg =[text0]+[text2]+[text3]etc...

eg Slingshot text box should have a "number or name" to find that out you need to go back to design view and click on properties, that will show you the text box number or name.

have fun...

eurika, Oct 26, 9:47pm
Tried http://jzm.co.nz/Files//Images/Access.png. but no page. If you are summing differnent feilds the do it in a query for example in query design view enter "Field1+Field2+Field3&quo-
t;

jancemord, Oct 26, 9:54pm

jancemord, Oct 26, 10:05pm
Thanks Blue, I have entered = [Accounting] + [ACC Levies] + [Entertainment 50%] + [Slingshot] + [Assets] + [Fees] + [Cartage] + [Insurance 25%] + [Insurance] + [Lease] + [Materials] + [Mobile] + [Phone 75%] + [Power 25%] + [Subcontractors] + [Stationary] + [Rates 25%] + [Livestock] + [Repairs & Maintanance] + [Fuel] + [Travel] + [Vehicle]but I get told its to long.What do I do now?

eurika, Oct 26, 10:05pm
Ok you need to go into design view for the form. select each text box and search it's properties for it's name and take note. once you have found the names of all the text boxes you want to sum, create a new text box. Go to that boxes properties and find the field thats refers to the data source. Type in each textbox name with a plus sign between each. Been a while since i build a db so if that does'nt work the enclose the name of each textbox with quotes e.g "textbox name" good luck

mrtoken, Oct 26, 10:06pm
if you like, zip it up and send it to me, username @ gmail place, just leave a message when you have as i dont check that box offen

bluedemon, Oct 26, 10:27pm
hey it should all fit in... i have just tried to add 30 text box name in. yeah make sure each the text box name is correct....

gyrogearloose, Oct 26, 10:47pm
My suggestion is that it would be easier to do this in Excel, rather than Access. You could just use the Excel SUM(...) command, and adding new expenditure analysis would be much simpler. For example, if you changed from Slingshot to any other ISP, or added [Depreciation] or any other category, you would need to edit the Access code instructions that you are asking help with.

mrtoken, Oct 26, 11:35pm
cheers, i will have a look at it when i get home (around 3)

Share this thread

Buy me a coffee :)Buy me a coffee :)