Search results

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

I already have find as you type but still not work. Thank you, Frank

Yes the situation is not all the supplies description have the starting # Thank you, Frank

Hello, I noticed that any supplies description of our supplies starting with "#", e.g "#15 Citra Cide" This will not be auto find, so we have to scroll down and search on the combo window. Anyone can help me why, and how can we solve the problem?. Thank you Frank

HI Arnel, In reference to Pat's comment about RI ( Referential Integrity) in my database, I want to try to change the control name to be "txt_ItemCode". But since my database is already go live since Mar 2021. What do you think that I am so careful in order not to have a problem on my database...

Thank you Gasman. I am more understood now, the different between the field and the control. Frank

Thank you Arnel, it works perfectly. I did it on my testing database. Thank you very much Frank

As simple as that?, will it not confused because the name of the form field is the same as the name of the table field?. Thank you, Frank

Hi Arnel, I have a question, maybe because It was too long, 10 years ago I never touched anymore the MS Access VBA. so I forgot the naming convention. In my case now, the name of the field of Form, I made it as Itemcode, that should have been txt_ItemCode. So now the name of the field of the...

What do you mean Pat by Don't forget to also set RI