Search results

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.

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,

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

Hi, i'm working in a stock database that contains (Items,Stocks,Procurements,Sales,and Transactions) tables, the attached image explains the relationships between the previous tables and the properties of each table, in my database the item can be stored in more than one stock, and the stock can...

hello all, can i write or change the relationship between tables in sql format in the access program, if i can from where? thanks with regards,

hello guys, can you tell me how to use dlookup function to retrive a value from more than one table. i'm looking forward to hearing from you, thanks with regard,

hello guys, i want to prevent the stored data; thats mean if somebody wants to update the data he click on a boutton then he can update ,otherwise he can't update can you help me please? thanks with regards,

hello guys, I have done stock program in Microsoft access. I created a table with name Items. That table contains itemNo (the primary key). , itemDesc. , unit , and price attributes. Also I created a table with name Sales which contains sales's invoice No (sInvoiceNo) (the primary key), date...

hello guys, i have a query that shows the balance of each item, here is the query SELECT Items.itemNo, Items.itemName, Items.type, Items.unit, Sum(Transactions.qtyIn) AS totalProcurements , Sum(Transactions.qtyOut) AS totalSales,totalProcurements- totalSales AS balance FROM Items INNER JOIN...

hello guys, i have a form that is called items, and it contains a field that is called itemNo and the type of this field is number. i want to do my own constraint which prevents the user to enter a number that is previously existed. i need your help please many thanks to you, bye