Search results

Thanks Pat, What (if any) of the other settings should be considdered? Regards

From experimenting with on current and using.... If me.field = "Y" then Me.AllowEdits = False end if This doesn't work and I can fully edit records.

Presuming this would require some VBA code set on "On Current"?

Sorry yes. Backend on a NAS drive. Front end Local

Hi All, I currently have a small Access DB and looking for best practice settings in a multi user environment (20 users). My current settings are... Default Open View = Shared Record Locking = No Locks Other Options (which I'm unsure if relevant)... OLE/DDS timeout = 30 Refresh Interval = 60...

Hi, I have a field called "Status" and if this is set to a certain value (e.g Awaiting Approval", I want to prevent users from locking a row out and making changes. The reason for this is that managers routinely run update queries which set various values if they approve the input and if users...

Hi Goh, Sorry, I didn't pass enough info. I fully understand the function of record locking, but looking for a work around under my circumstances. These being that I have developed a form that a user can build up multiple payment rows (which are saved in a temporary table). Once happy the user...

Hi, I have several update queries that run to update various parts of my DB in a multi user environment. Problem is that when a user is in a record the query wont update that record due to record locking. Can anyone please help with a work around for this. Kind Regards

I found this which brings up the glass flat bed scanning option. ****************************************** Private Sub Command0_Click() Dim comDialog As WIA.CommonDialog Dim img As WIA.ImageFile Set comDialog = New WIA.CommonDialog Set img = New WIA.ImageFile Set img =...

Bob your a genius! The name was called Text117 the record Source was Policy_Ref_Num. My bad programming but all works fine now. Im not great as this VBA I just muddle through. Massive appreciation. Frost

Hi Bob, Its part of an e-mail button on the form that works fine apart from not returning this one field. It returns other fields of the same type. I've tried dropping the "Let" from your suggestion but still not working. Its also definitely the control name of the field. I've copied it...

Hi, I am confused... I have the following simple variable assignment... Dim PolRef As String Let PolRef = Me.Policy_Ref_Num But when I run my code I get "Invalid Use of Null" and PolRef is set to "" This field is populated however, so I'm confused to why I cant set my...

Hi there, Can anyone assist me with this problem. I want to create a button on my form that when pressed will scan my multi page document (ADF) from my Epson WF-3540 and save it as a specified file name and folder. Many thanks in advance, appreciated.

Thanks for the reply. All working now.

Hi, Thanks for the reply. Do you mean just type Do Events right before the docmd.... Do Events docmd.sendobject? What does that do?

Hi there, I am new here and an not great with access. I do manage to stich code together to achieve my goals. Below is my code to send an e-mail from within a form using outlook. It all works fine apart from the fact my access system is essentially locked out whilst the New E-Mail Window is...