Helloo..
According to the attached DB sample.. i've created a mainform with a subform on the left side with many records and each record contain a field with button and on the right side a display panel, so that on pressing the buttons on the left subform another subform displays on the right...
Hey..
As you can see in the pic attached, this is a subform with totals end in a form..
Question is.. any idea how to pick up those 2 totals to perform calculations with them in the downward textboxes ?! like in the first box i would like to divide the [Invoice Amount] total by the [Quantity]...
Hey...
I've got a Form that contains a subform from a query of a table..
That Form limits the contents of the subform (datasheet view) with different things like date period and 4 checkboxes each one hold name of place (Alex,Aswan & Luxor).
SO, what i want to do is that when i check the checkbox...
Hey..
I've got a Form called "Invoices List" that contains a field called "Supplier" & on clicking on this field it opens another Form called "Supplier Details" with the related data..
What i want to do is to be able to open the other Form "Supplier Details" with no value without getting a...
Hey...
A Quick issue..!!
i've got a Form that contains Subform with an embedded Query that contains 2 tables only (Payments & Invoices) the Join properties between them show all records from payments and what matches it from Invoices where the joined fields are equal (Invoice no).. So, when i...
Hey ..
I'm looking for a secure user login system for my DB that has a Home form with 3 buttons: Invoices, Banks, Analysis.. each button has a macro that opens the form of the name on button..
So, i need to enable different users to login on the DB with different permissions.. like for the...
Hello ..
I've a Form that contains 4 subforms in datasheet view in which each Form is created from a table.
The 4 Subforms are:
1) Data : contains 'Serial' field in autonumber format.
2) Invoices : contains File no, Invoice no, Invoice amount & BL no fields.
3) Payments : contains File no field...
Hello,
I'm a new access 2010 user, and newcomer in this board too.. And, i'm hoping to find solution to my problems here !! :rolleyes:
Problem 1:
I'm trying to create a Banks form with subform of transactions.. so that when i change the Bank name and period in the main form the subform will...