Search results

What does SKU stand for Pat. Now I am thinking how can I modify my database while it is already go live. This is my input form for supplies out. To indicate warehouse, I should add the field in the sub form at the very left inventory sub form?. But I still be having a problem on the quantity...

Yes, I think I need to learn this approach "the smallest Unit of the product". Could you explain more on this approach. For your information in fact we have 2 warehouses beside the office, at the back and in front of the office, therefore I have 2 ms Access database for Warehouse A and for...

I think the relationships to be used here are all One to Many, Is n't?

Then if needed you can have a conversion table which tells you how many units per case of a unit. How can I relate the inventory ID with the conversion table Frank

Hello, right now for our Inventory system, I have not found solution to the disability of MS Access to handle multi unit of measures. The way I do now is to create 2 Databases. For the big ware house I call it Warehouse A, where we receive supplies in cases, 1 database. And in the small...

No Pat, just like three location within the church. The problem I do not know how to convert MS Access database to SQL. So the best option maybe to build a LAN, but It could be very expensive for the church. Thank you for your advice Frank

No Pat, I do not have the relinked code, I appreciate if you could give the codes to me. On other things, Since our church has different storage, can I ask you about Server. How can we install the server system. We have internet in our church, but from the computer monitors/clients to the...

Thank you for your advice. Frank

I want to make the same database for our church. Can I rename my database with the other name, then I start developing it fit to our church need. What things to be considered for front and back end. Usually all VBA that refers to the previous name should be changed? Thanks for any advice. Frank

Hello, I tried to make my inventory database multi languages by trying to recall back what I made (Church membership database)by the help of community in UtterAccess. I tried to search if this is the form but none, so I guessed that this is the language or VBA Call FillFormLabels(Me.Name) Am...

Yes you are right, that is what I did. Thank you for your help. Frank

Yes London, the only thing I was curious, why if I print review, nothing was truncated, but when I print in pdf, some was truncated, and some looked good.

I have Ver. 2016 Joseph, I do not have that feature in my version. Frank

Hello, Some date fields are not shown in report when we print it, while in the print review/ display are shown well. Can anyone help me how can I solve the problem?. See attached. Thank you, Frank

Yes but if there is a significant change in table and relationship, don't you think we should combine first then we revisit our design? Thank you Frank

I want modify my database that is already go live. What is the best way to recombine the split database, because I want to change the structure to have a table for A company name, and also I want to make it a multi languages. Thank you, Frank

Thank you MajP, this one works. I missed something on the first try = (Format([Forms]![frmReportselection_ReceiptbyItem]![txtstDate],"MMM, DD, YYYY") & " to " & Format ([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY"))

I tried your suggestion MajP, but It did not work. Did I miss something here?: = & Format([Forms]![frmReportselection_ReceiptbyItem]![txtstDate],"MMM, DD, YYYY") & " to " & Format ([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY")

Thank you, I will try it Frank

Hello, I want to change the format of the text column in my report. The content of the text is this: =[Forms]![frmReportselection_ReceiptbyItem]![txtstDate] & " to " & [Forms]![frmReportselection_ReceiptbyItem]![txtEndate] but It can not work, it always show this format mm/dd/yyyy, I want it to...