Search results

Hi, Sorry to as this question. Is it possible for a standard A4 page invoice be reduce to print in a small thermal printer with vba code I am asking this because everytime I have to deploy my desktop App to a client, I will have to setup the thermal printer manually and if it's not a thermal...

That's exactly what I did here, but when the 2 users updates the same item(s) at the same time, the program freezes So I am looking for a walk around this issue, I don't know if there's a process to keep one user waiting when the other user is already engage with the process or maybe recordset...

Yes shared the front end by making individual copy That's what I did

YYe Yes it's a shared front end while the back end is split (and the 2 users connect to the same back end)

I will do that now please

This was what I used before. But the problem here is there are 2 users, and when they run the same process from different PCs, one sometimes freeze especially when the same product is selected at both end

So what did I left out please?

This is the whole code used -------------------------------------------------------------------------------------------------------------------------------------------- Dim dbs As DAO.Database Dim rs As DAO.Recordset Set dbs = CurrentDb Set rs = CurrentDb.OpenRecordset("SELECT tblItem.QtyAvail...

I think I thin the error is posting is in OpenRecordset I don't know maybe improper variable declaration or something like that , I guess Please check through and give me the right way (syntax) to present the code Thanks

Hi, I am trying to write a code into my small application but it keeps throwing errors when I compile it (Type Mismatch) Below is the exact code throwing error at .OpenCurrentdb: Set dbs = CurrentDb Set rs = CurrentDb.OpenRecordset("SELECT tblItem.QtyAvail, tblItem.UnitSale...

Well thanks for your explanations so far The whole idea of update this or that is based on the fact that it is an inventory application I have the customer table whose account must be billed The Product table must be update (Items purchased/ordered should be deducted from the stocked quantity)...

That's just what I did. My problem is that sometime the query does not update and sometime it does. Then whenever 2 or more users are engage in the same item, the system freezes until one closes without updating

What I mean is that I created a Query of about 4-co-joined tables being updated simultaneously from the sales form or table with a criteria from the table matching the criteria on the form. About 6 different field/column are being updated in a row All I need is the correct syntax to do this in a...

Yes since it's in a multi-user environment The users always run into locking issues when they seems updating the same thing in a split backend. So I decided that using recordset with (.Edit) will resolve the issue

Hi, I am having a problem update multiple tables that are joined together in a query. I want to update them with recordset in a multi-user environment Please can someone show me the correct synthax to do that? Thanks in advance Moore

Hi, Please a quick one here. I have an app that is shared by 2 user (splitted BE/FE). Everything was working fine until I discovered that it's becoming too slow and so I upgraded the windows from 7 to 10 pro. My puzzle now is that the same access app that was working is now locking up after on...

Hi, These are what I did to have my Access Application speedup: I opened the backend while the frontend were all closed, I Repair and Compile the Backend as manually, I re-indexed most fields that required search, IWorked on my physical lan connections and,Installed ManageEngine_OpManager to...

Thanks I have gone through the links sent to me and I am so grateful indeed because they all contributed to my search. I have sort out the issues The application is relatively fast again now

Please what do you mean by persistent connections?

Hi, I have a solution being used by 2 users on a Lan/Wlan. Initially there wasn't any complain until recently they are complaining of too slow activities I went there to check and you need to wait minutes for one process to perform I change selecting Items from a ComboBox traditionally to using...