Search results

SELECT SalesOrder.CustomerID, Customers.Customer, SalesOrder.SlsControlNo, SalesOrder.OrderDate, SalesOrder.IssuedDate, SalesOrderDetails.ItemCode, SalesOrderDetails.Notes, Inventory.Description, SalesOrderDetails.UnitPrice, Inventory.UOM, SalesOrderDetails.Quantity...

Hi Gasman, I do not understand why my combo can not extract customer to be put in the selection form, because my query will take it to filter the report to be printed, but below is the error asking to fill in the customer. Thank you for enlightening me Frank

Thank you Gasman, I am now at home, I will test it in my work location. Upto now, I have not been successful to make 2 kinds of link path, 1 in the office and one at home. Do you have any idea? Thank you Frank

Hi Sir...what is usually the problem if my combo does not extract the customer that I want to select like shown on the picture below.

Hello, I have already report selection by date for certain item supplies and then I will select by certain custumer/supplier, can I add the selection in this column of query? this: [Forms]![frmReportselection_ReceiptbyItem]![Combo_User] Thank you

In the office it uses UNC, I do not think it works at home. Frank

Thank you Pat, that is the way I had in my mind, but when I relink it in the office to the home path, Can I open it at home?. Thank you Frank

Hello, I keep continuing in development of my supplies database while it is going live. What is the best method to do it. I can do it in the office, but when I want to do it at home, the link path of the table after it was split, is different. What I had in mind, I export the link path at home...

I tried it Arnel, but it requested name showing this in the textbox: #Name Okay Arnel, it works for me now. Again thank you very much Frank

Thank you Ranman256, I will try it. Frank

Hello, This is my selection date in my query: Between [Forms]![frmReportselection]![txtstDate] And [forms]![frmReportselection]![txtEndate]. My question is how can we have date from the above txtstDate and the txtEndate, because in the report header I will put Report selected from txtstDate...

Jdraw, it is correct because you use google translation. I know google translator is good but we still have to recheck, because we can not translate word by word because Indonesian has a very simple grammar. Thank you Jdraw, any way what is your actual name. Thanks Frak

Is there any way to export my access report to excel. How can we make the external menu be available in print review. or can we make a macro button to export the report to excel? Thank you. Frank

Curious--- what is your native language? My native language is Indonesian Jdraw, but we immigrated to CA 7 years ago, and since we came here was not young, so is not easy to be fluent in English.

Beyond that, updating the quantity on hand and storing the calculated value is fraught with danger. The correct/safe way to manage inventory is to create transaction records. Then you sum the transaction records to get the quantity on hand when you need it. This gives you an audit trail and...

Pat, I believe you, the reason is because if it is still in the middle of the road, as you can see in the sub-form, if user key in the quantity, it will automatically update the Quantity on hand even though the record was not saved. And my quantity on hand is not formula, but replaced with the...

The doc man, can you give me the code on LostFocus event? to let not people leave it blank?

what is the code of a SetFocust Sir Thank you. Frank

I do not have this code on the before update event Pat, what do you mean. Is it pertaining to my case?. Thank you