Search results

Hi all. I have forms A1, A2, A3... that contains subforms, and on these subforms I have textbox named Txt_ProductName It could be located at: "Forms!FrmA1.Form.Level1subA1.Form.Level2subA1.Txt_ProductName" (I assigned this string to Arg_str1) or "Forms!FrmA2.Txt_ProductName (assigned to...

Yes, user has permission to read/write to the folder. In this case, records are not being deleted since they are back in a while or back when we restart app.

Hi everyone My customer is evaluating my small Access project. Splited BE is on a network folder "\\data\accessDb\BE.accdb", Two users have their own FE on their desktop PC. These desktop PCs are joined to domain. Most of time, the system works fine as expected. About my app: + FE has...

Thank you. I have to convince my customer using window server then...

Hi all I am using shared folder on LAN to store BE file, but i saw this setting limit to 20 users only. My customer wants about 50-70 users install my Access app. What if there are 30 users opening Access app at same time? Is that possible to increase simultaneous users to around 50-70 user...

"L_TBLUSER_CURRENT" is on FE, and I also have a separate log in table that records users's login/logout on BE. "Remember me" is feature required by customer that I can avoid. Since each user has their own computer that dont share to others, they said they want "Remember me". Anyway, thank you...

Hi Pat Current user log (on FE) is only be cleared when user click on "Logout" button. Without logging out, next time they open the app, it will bypass login window (assume Remember me is ticked). So when user starting application, on AutoExec code, I do check: If DCount("*"...

Hi Pat Yes, that is more reasonable. I forgot about using Dcount... Code to set current active User Public Sub User_SetCurrentActiveUserID(loggedID As Long, Remember As Boolean) On Error GoTo ErrorHandler Dim rs As DAO.Recordset Dim DeleteSQL As String 'Just clear table first...

Thank Pat, Appreciated your suggestions. Yes, I understand about orphan record, and I have been trying to manage them like your guideline. However, in this case there is only one row in this table (this table locates in FE) to tell current logged-in user in this machine.

Yeah, it's exactly the point. My careless

Hi all, I want to clear CurrentID (long) to null (nothing) in table current logged User I thought it was simple SQL. UPDATE L_TBLUSER_CURRENT SET L_TBLUSER_CURRENT.CurrentID = Null; But I got error: "You tried to assign the NULL value to a variable that is not a Variant data type" My purpose...

Dear Pat Thank for your detail, I understand with Citrix and RD we are not sending any Access data but sending key trokes and screen. Where does this server locate? Will I need a VPS or I can use my local PC with static IP? Sorry for dumb question, but as mentioned before, I dont have IT...

It has about 30 tables and 40 forms. Unfortunately, I am not familiar with REST API, seem it is long way to go for me.

Dear all Currently, user1's local PC is still playing well "server computer" role. User2 FE hang up issue is not often and not critical. I think about VPS because of future system scaling, one day my company might expands 2nd 3rd offices in different locations... These days, I really can not use...

Dear all. My Access app has many form/report, so we never know which form/report user is opening. Therefore, handling disconnection event in every single form/report is nightmare. I dont have good IT background, I just tried to google about VPS. So my intension is: 1. Buy a VPS from service...

I was hope Access could have something like interrupt event to handle urgent/higher priority tasks. My company does not have "server computer". The user1 has always go to work early in order to get BE ready for other users :)

Dear all I have an Access app which splited BE abd FE within LAN. User1: FE + BE User2: FE only When user1 turns off his PC, therefore User2 FE has no BE and sometimes it causes Access app on User2 hang up. What could be the proper way to approach and handle this issue? I used to deal with...

Hi Josef Thanks for your help. Since your A2016 is also not able to open my A2010 accde file. I have narrowed down the cause, I suspected the A2010 accde file got problem itself, then I tried to install Office 2010 Pro Plus (The current one is A2010 Pro). Build accde with Access 2010 Pro Plus...

Hi Josef It is already uploaded in post#3. Can you try to run it with A365?

They are both 64 bits