Search results

Thanks both for getting back. My save code is (with a module): Dim strMsg As String strMsg = "Data has changed." strMsg = strMsg & "Do you wish to save the changes? " strMsg = strMsg & "Click Yes to save or No to discard changes. " If MsgBox(strMsg, vbQuestion + vbYesNo...

Fizzio, Thanks for replying. Unfortunately, the code does not preserve the records. The records are still locked. Any further help from the forum would be appreciated.

I have a main customer form set to DataEntry as I want a certain group of users to enter customer information, but not see the whole customer database once entered or whilst entering. The forms have a few additional forms linked by customerID. Some of these are opened from command buttons on...

This is associated to another post Office & Reemote Access but a different query. I have some forms set to DataEntry as I want a certain group of users to enter customer information, but not see the whole customer database once entered or whilst entering. The forms have a few additional forms...

Thanks Mike for your responses. Your help is appreciated. Apologies for any ignorance on my part, but I am still trying to get a solution to work. I have built a separate db for laptop users with forms to enter new customer details. These forms have 9 forms/subforms linked by Customer ID. In...

Thanks for getting back. After reading many posts, links and articles on replication, I feel this would not be the best solution. At the moment, to enter new information there is a main customer form. This holds some sub forms and forms which are linked to the customer form by customer ID...

We have a secured database which needs to be on a server so that is available for six users in our office. In readiness, I have split the database. I am planning to have the front-ends on the office PC’s and the back-end and workgroup file on the server in a shared network drive. Additionally on...