Recent content by AccessBug27

You would have to understand what the app does as to why its important no more than one user is using it. although other users can use it when it becomes available

I have an access app that is on a shared location on a network, but only want to allow a single user to open it at any time. On each computer I have added the /excl switch to the shortcut so they get the message to say its open exclusively by another user, but they still get the option to open...

OK, I see your point, although the application is to be used for our own purposes, not being distributed where different versions of access could be used. I probably will change it for consistency though Thank you

Actually it was a simple solution !! I discovered that hitting the PageUP/PageDown keys on the keyboard worked. I just simply wrote code to simulate the key presses Private Sub PageDown_Click() SendKeys "{pgdn}" End Sub Private Sub PageUp_Click() SendKeys "{pgup}" End Sub

I have created a continuous form, without scroll bars which limits the amount of records displayed. And using navigation buttons can move forward or back etc. I want to create 2 custom command buttons, page forward and page back. I need to find the record number of the topmost displayed record...

I have created a continuous Form, ie multiple records on the same form. But I want to limit the amount of records displayed on the form from the large table. Maybe have page forward/backward command buttons on the header or footer using VBA code?

Private Sub ComboARid_AfterUpdate() Set dbSAP = CurrentDb 'select reseller from entered reseller Id strSQL = "SELECT * FROM Resellers WHERE [ARid] = '" & ComboARid & "'" Set rstResellers = dbSAP.OpenRecordset(strSQL, dbOpenDynaset) ARidName.Value =...

I have an unbound Text Box that the user enters data into which is then used by VBA Code when a button is clicked on the Form. If I use TAB to exit after changing the data then the correct value is used by the code. However if it loses Focus, ie the Button is clicked, the old value is used...