Search results

Hi I was wondering if anybody could help me with this. I have a form with that contains the fields appointment date and appointment time. I would like to know if anybody could help me to create a script that opens up an outlook calendar (if possible be able to select the caledar that is opened...

Thanks Thanks Ken That was great worked well Thanks Marcus

Hi Was wondering if anybody could help with a select case statement I am using to validate a form This is the code Dim myclinic As String Dim myfname As String myfname = Me.txtFirstName myclinic = Me.frmClinic Select Case myfname Case Is = Null MsgBox "Please enter a first name", vbCritical...

Thank you Many thanks for that, has done the trick Marcus

Hi Was wondering if anybody was able to help me with this. I would like to be able to filter records on a form using another form, where the user is able to type in values in order to select the records to display on the other form. I have a number of fields Surname date Clinic post code...

Thanks Many thanks for your help, will give it a try now Thank you marcus

Hi I have the field fullname in my database which is in the format Mr John Smith What I have been trying to do is to extract the Mr then the John then the Smith into 3 separate columns. Can anbody help please? Thank you Marcus

Thanks Hi Thanks for your help, that worked just as I needed Thanks Marcus

Hi I have a query in Access and have the following expression Quarter: ((DatePart("q",[DateEntered])+2) Mod 4)+1 To workout the Quarters (UK style) for financial years. I would like to have this as a public function that I could just call like the DatePart() function. Please could anybody...