Recent content by grad2009

thank you very much, i will see the link

hello all, i wrote this function in a click event of a boutton DoCmd.OpenReport "customer_account", acViewPreview, , "[nam]='" & Me.Combo4 & "'" can i add another condition beside the one in the function. In other words, the last partion of the OpenReport function (condition) could be more...

hello guys, In my stock database, i created a form that contanins the customers names in a combobox and a button, when i click the button it shows a message with an address "Enter Parameter Value" and ask the user to enter the customer's name. the code bellow is the code that is in the...

hello all, I used (AS) to change the name of a field in a qurey but it did not changed. However, for the calculated field when i use (AS) it is ok. Is there any way to change the name of the field in a qurey. Thank you very much.

:) Thank you all, Thank you JamesMcS, Thank you vbaInet. you are really helpful. Now it is ok. Thank you again :)

Thank you vbaInet very much for your explination. yes they are. sure here it is SELECT Customers.customerNo, Customers.customerName, (totalPayment.totalPayment+totalSales.totalSales)-totalReceived.totalReceived AS customerBalance FROM ((Customers INNER JOIN totalPayment ON...

I am sorry, which question? sorry, I can't understand what do you mean?

Thank you vbaInet for your fast reply. There is no value in fieldb, but there are some values in feilda and fieldc.However, there are no results.

Thank you all, the substraction operation [Total] - [Subtotal] is done ok, but when i tried to do the adding operation Fieldc-(fielda+fieldb) there were no results. naina's answer is complex. are there any easy solution please? Thank you again

Hi all, I want to create a query. In this query I want to add two values and substract the result from a third number but i can't do that. I used the mathmatics operators(+, - ) but it does not work. are there any functions can do that? please help me. Thank you

hello guys, I have a form that contains of a field of (list type), I want the value of the list based on a query, this query is based on a value that entered by the user in another field in the same form. Can you tell me how can i do this? regards,

thanks with regards,

thanks alot Mr. B i did what you told me but when i open the form in the in the form view it appears as a blank page ( i mean the textbox doesn't appear in the view).

hello guys, i created a form with the form design then i dragged the text box tool in it, after that in the Control Source property of the text box i chose one field from an existed table, then when i open it in the form view this message (#Name?) in the text box. can you tell me what's the...

Am I clear or there is a problem can you help me please?