Recent content by pedroghuk

Can someone assist ...? I need to incorporate a way of showing the date, time and UserID information of the first person to input data to our patient referral Form. In addition, it would also be great to include the UserID of the last person responsible for updating the data? How do I go...

Good afternoon all Quick Question: We have a database which allows Users to input patient referral information. Is it possible for Users to search for patient referral data WHILST in the middle of inputting data for another referral? In addition, can anyone point me in the direction of a...

Good afternoon all Looking at sites around the web and in particular this Forum, my problem is not uncommon but there does not appear to be a simple, easy to implement solution. Quite simply, I want a Form to include a button, that when selected will only print the current Record and not all...

Thanks Sparks - please see my last post in this thread

Sparks Illness and paternity leave have resulted in my absence. Thank you for your advice. I accept what Pat Hartman advises; all the while, I wanted to try out your suggested solution. Please see that attached Test db. Where is the problem? In addition, do I assume that to turn...

Been away for a few days. I will trial the Form at startup method later this week - it sounds a reasonable compromise and solution! Thanks.

Thanks MStef The only issue is that I have a Security.mdw file in place which assigns Users to Groups. A shortcut to this file is used for Users (and me) to log into the Database. Using HeadwayShortcutBuilder I effectively connected the Security.mdw file to the Database. Using the...

Good afternoon I have had an unsuccessful search of this Forum for an answer … Can someone please assist me? I have a simple Form with a series of bounds fields on. These all relate to Table A. These fields are: Date Referred {which may be unnecessary?} Combo Box B which has values 1...

Advice and direction required … My User Account is part of the Admins Group. This Admins Group has Open/Run, Open Exclusive and Administer permissions to the Database and Administer privileges to all Object Types Every so often, I need to tweak, update or develop the underlying Database...

Spikepl Thanks. Interesting link but I don't want the form to close (it does at present when the message box is confirmed OK). I want the User to remain in the form until all three fields are complete. pedroghuk

Thanks to all. One further issue ... The following works: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Speciality = "A&E" And Len(Me.AdmittingPhysician & vbNullString) = 0 Then Cancel = True MsgBox "You need to fill in a name of the on-call Physician if you have...

Good afternoon all To date Bob Larson has been more than a tremendous help as I try to engage my dummy brain into MS Access mode!!! I have a problem opening a Form - something somewhere relating to a parameter or expr is causing an issue. In addition, I have a further issue relating to...

Thanks to all who replied. One snag, yes the OR operator makes sense, but one Event relates to Me.Speciality = "A&E" and the other to Me.Neuro_Oncology = "Yes"; two conditions with two messages. Would a bracketed OR work, i.e. ... (If Me.Speciality = "A&E" And Len(Me.AdmittingPhysician &...

To all Good afternoon. I have introduced the following check to effectively make the on-call Physician field mandatory: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Speciality = "A&E" And Len(Me.AdmittingPhysician & vbNullString) = 0 Then Cancel = True MsgBox "You...

Bob As mentioned in the MrExcel Forum, a huge thanks for all this help. Please keep the problem.zip file readily available (or Referrals_RevBL.zip)! I am trying to resolve a parameter issue that now pops up upon opening one of the main Forms! Regards. Gary