Recent content by Moore71

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