Inserting more items in a form (1 Viewer)

aym

Registered User.
Local time
Today, 03:01
Joined
Aug 20, 2017
Messages
40
Good morning to you all
I design a database that contains the following fields in MS Acess:
1. Items in combo
2. Quantity
3. Unit price
4. Total

I will like to click on a button that will enable me to insert the field above like this
1. Item. Quantity. Unit price. Total
2. Item. Quantity. Unit price. Total

Grand Total. TOTAL
continously and it should give me the grand total.
Thanks for you usual assistance
 

June7

AWF VIP
Local time
Today, 02:01
Joined
Mar 9, 2014
Messages
5,423
Have you built a form?

Textboxes can have expressions to do calculations.

This is really basic Access functionality. Have you studied an introductory tutorial book?
 

vba_php

Forum Troll
Local time
Today, 05:01
Joined
Oct 6, 2019
Messages
2,884
I design a database that contains the following fields in MS Acess:
1. Items in combo
2. Quantity
3. Unit price
4. Total

I will like to click on a button that will enable me to insert the field above like this
1. Item. Quantity. Unit price. Total
2. Item. Quantity. Unit price. Total
to get records to show up vertically, one repeated after another in a form, just set the default view to "continuous" in the properties. to get a [total] field, write a query and add a field with a statement like:
Code:
table.quantity * table.unitprice
Grand Total. TOTAL continously and it should give me the grand total.
perhaps something like this in a textbox's control source property (textbox located in the form footer)?
Code:
=dsum("total","queryNameHere")
Have you studied an introductory tutorial book?
agreed. but I would recommend u google ur litter heart out and search ms access online forums for FAQ pages and stuff, NOT read a book.
 

Galaxiom

Super Moderator
Staff member
Local time
Today, 21:01
Joined
Jan 20, 2009
Messages
12,849
perhaps something like this in a textbox's control source property (textbox located in the form footer)?
Code:
=dsum("total","queryNameHere")

Better to just Sum the Total field from the form's recordset with a textbox in the form's footer. It saves running the same query again.

Code:
=Sum([Total])
 

aym

Registered User.
Local time
Today, 03:01
Joined
Aug 20, 2017
Messages
40
Thank you for your respond, I will work on it. Thanks
 

aym

Registered User.
Local time
Today, 03:01
Joined
Aug 20, 2017
Messages
40
Post Re: Inserting more items in a form
Thank you for your respond, I will work on it. Thanks
 

aym

Registered User.
Local time
Today, 03:01
Joined
Aug 20, 2017
Messages
40
Better to just Sum the Total field from the form's recordset with a textbox in the form's footer. It saves running the same query again.

Code:
=Sum([Total])


Pls how do I continue to Add item, Qty and Unit price maybe by clicking on a button called Add Item. So by clicking on the button the following should be display: Items (Combo), Qty, Unit Price, and the total. Thanks
 

mike60smart

Registered User.
Local time
Today, 10:01
Joined
Aug 6, 2017
Messages
1,899
Hi

Can you upload a zipped copy of your Database?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:01
Joined
Oct 29, 2018
Messages
21,357
Pls how do I continue to Add item, Qty and Unit price maybe by clicking on a button called Add Item. So by clicking on the button the following should be display: Items (Combo), Qty, Unit Price, and the total. Thanks

Hi. You could try this. Go to design view of your form and add a button using the wizard and select record navigation, go to new record.
 

Users who are viewing this thread

Top Bottom