Search results

I will search for it Frank

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

The Auto find on the issued form was some times work some times not, could it the API should be ajusteed? Frank

always need to relink the BE when I am moving from test to production at a minimum. Yes Pat, that.s what I did to make it working again. But on other thing, tha auto find was no showing up on the form item discripton of the good. Do you know why.?. Thanks Frank

Thank you, I will try it

Thank you Jun, I will try it

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

ok the IT people already reinstall the Old Access in the old cpu, and it works now. In the new CPU, they said even though they installed the old access, the system itself will reupdate it with the new one overnight., that is why the next day it could not work. Thanks everyone for your help. Frank

I already have access 2016 on my computer installed, but I still can not open my program, do you know why

Thank you DB

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

That is why Trevor I want to modify the excel file by putting the period total in line with the name, how can I make macro to do that in my worksheet. Because there is like 800 people that I want to modify, because I want to compare their donation in 2023 to their donation in 2024. Thank you...

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

what about the field for the quantity balance of Inventory, is it calculated field, or a saved field. Thank you, Frank

Yes Pat, I have a transaction method, and 2 databases for the 2 Warehouses. Each transacion for a users will create a new Id, this good for trancking it in the reports. On other things price of the supplies should be in other table right. On thing I forseee how can We make the last price will...

Hi Pat, although One database and One Tablie for all inventory. If there is a transfer of supplies between the warehouse, we still need to key in them right. And my qustion is whas is the name of field of the quantity to be input, because let’s say in warehouse A (the big warehouse) it is in...

With this structure, I still do not know how can I make it, if the same supplies item let's say paper towel was running out in Warehouse B (small warehouse) in the front of our housekeeping office, and I have to move from WArehouse A ( the Big warehouse in the leftside of the rightside of the...

Yes it is not an auto-number, and also for the price, in the input form in Warehouse A, there is a calculated field to show price per EA, then when I add manually the new product, I put that price for the price per EA. So I can say my Unit Type are only 2, CASE and EA. But I still interested in...

In this 2 databases we have the same product_ID and descriptions. In Warehouse A, for purchase in other than EACH (Cases) and in B is purchase in EACH. if Housekeepers request in Cases, we take it from A, and we posting it in DATABASE A, if in EACH we take it from B. another activity is to...