Search results

Hello, my computer was changed to the highest CPU and with operating system Windows 11. But now I face the problem that my autocomplete in the supplies input form is not working for the description of the items. What I mean is not working is not pop up to autocomplete, but in fact is working to...

I made 3 years ago my database with menu, and now I want to inspects again my report design, but since it was long I forgot how to directly by pass the menu and open my database. Also I want to check it in my laptop. But it seems the path to reach the backend is different, how can I correct the...

Hello, I created report with access 2016 3 years ago, I put the unit price in the Inventory item, not in the Price table. So any time I updated price, the report should show with the new price, but I found it no changed in the report it is till with the old price. Anyone can help me why it was...

Hello, my computer was changed with the new cpu and monitor, and my MS Access database that I developed with MS Access 2016 can no longer work with 64 bit. Anyone can help me how can I fix it?. The error message says. your database was created with Access 32 bit version, please open it with ms...

Hello, In case of the source of data is like in the attached for Mr. Y, the data for him is not only in his row, but below the row too. How can we make mail merge. If like Mr X is easy just pick up the columns in his row. Anyone can help me? Thank you 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...

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

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

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

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

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

Hello any body can help how to avoid duplicate supplies in one go of the data entry in the form? As you can see in the attached form, I want the user as he type the same supplies name there will be a massage saying " this is duplicate, please enter it in the next data entry. Thank you. Frank

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

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

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

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

Hello, How can we make it not to leave a field blank such as customerID from the Main form, before it goes to the sub form as I marked in red in the attached form. Because when we got in the sub form, I can not get back to the previous field ( CustomerID}. and get stuck, so I delete the...

Hello, can anyone help me how to make on the form : on Load, there is a message says" please do not use this form, still under development" the user press OK, then exit the form. Thank you for any help. Frank

Hello, attached is my switchboard menu. Is there any simple way to not allowing anyone to access menu no. 1 " New Items of supplies", Or just to allow User-3. I have the user table with the field "Users". Thank you for any help Frank