Search results

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...

Indeed, that's what i did exactly .. !! And as i said, it's giving this error !! :/

Here's what i wrote in the textbox of the main form.. =[Forms]![Subform Invoices for Data]![AvgTransferred] Where: [AvgTransferred] is the textbox in the subform that contains the Sum() function.. Check the pic attached to see the error that i get .. :c Hint: i've changed the subform view to...

Thanks for your willing to help me in this situation.. Actually i've found 2 ways for doing that.. 1st one: Was your way.. but here i've to write the Sum() function in the footer of the subform, then refer to it in the textboxes on the main form that's including the subform.. i could write the...

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]...

I would really appreciate that .. Here's a Sample of the DB Form load on opening

The thing is that the table & the query DOES NOT contain checkbox field.. They contain a text field names [Place] that has values of "Alexandria,Aswan & Luxor" !! And in the form i want to only show records that it's [Place] field contain value of Alexandria (for example) on checking the...

Actually i didn't get what you said, did you mean that i have to enter code into the subform's recordsource of certain field that limits data to the value of the checked checkbox ? if so, then can you tell me how to write this code ?! O.o

Well, i don't want to make "Filter".. i just want to show only the values of the checkboxes, cause filter can be edited in the subform itself without using codes. So, yes i want a code for the value of the Alexandria checkbox if it's true or not (means when it's true the value = "Alexandria"...

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...

But there's no 1 to Many relationship between those 2 tables ..!!

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...

Yea, but it must be a user with no edits and admin with edits not all users with edits.. :/

Well, i saw many Login Samples but all of them i can enter the design view and edit it.. but i liked a sample was posted here in the Sample Database under the title 'IT Audits' that blocks everything even for the adminstrator (hidden the navigation pane, ribbon & the design view and other...

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...

That's so easy, here's a ScreenShot of the relationships.. :)

I really tried many times to upload a sample of my DB but that's hard cause all my DB samples are more than 2 MB - even in ZIP formatting..!!! Also i can't insert a link to an uploaded file since my posts didn't exceed the 10 posts .... :/ So, what else can i do than explaining and showing...

Well, table level contains so many relations, but i just need to set relations between the 3 subforms (Invoices, Payments & Analysis) by using the 'File No.' field with the 'Serial' field in the subform (Data).. Also these codes didn't work with me.. !! :/

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...