Search results

Hi, I have a form that has 3 selection criteria, date from and to and staff member. I have allowed the users to not select a staff member which would select all. The value of these selections are passed into global vars, and i have a function that gets the global vars which are used in the...

Apologies all, it was the positioning of the save line. It works now, thanks all Nathan.

Hi, I have tried the following in the load section DoCmd.GoToRecord , , acNewRec DoCmd.RunCommand acCmdSaveRecord Me.txt_NHS_Number.SetFocus Me.txt_NHS_Number = 0 Me.txt_NHS_Number = vbNullString it still gives me a null in the UID field. Thanks Nathan.

Hi, I have created a database with the goal to move to a SQL Server back end when complete. Today i have moved the back end to SQL server. I have a form to add a new patient to my database. This form has the Patient_ID(my UID) bound and in order to force a Patient_ID, i set the focus to a...

Sorry I have a label Check_Form, before the if statement

*********** OPENING THE REASON FORM ********* If Me.txt_Activity_Status = "ReScheduled" Or Me.txt_Activity_Status = "Cancelled" Then glbActivity_ForReason = Me.Booked_Activity_ID DoCmd.OpenForm "frm_Cancellation_Reason", acNormal End If '*********** THIS JUST CAUSES A LOCKUP...

HI, I have a subform in my access form that has details of client visits and their status'. If i change a status to rescheduled or cancelled, i want a dialog form to pop up to allow the user to select a reason for cancellation/reschedule. I have done the form and set it to modal, but the...

Hi, I am currently working on a DB for a call centre. The call centre allocate resources based on the calls received, and create appointments in resources outlook calendars to do the appointments. This works fine. However, i need the meeting request to go from a central mailbox...

Hi I am using the following code to set a date and time for an outlook appointment created from an access db .Start = "#" & Format(dtDate, "dd/mm/yyyy") & " " & Format(dtTime, "hh:mm:ss") & "#" I have ran my code with a start time on 10am, 2pm and 4.30pm, but my code seems to put them in...

Hi, Thanks for your help. I have had a go at this before, and i think the general answer was that it cant be done. :) I have done it using a conditional formatted text box, to look like a button, based on a dlookup for the activty on that activity ID, returning a boolean response for its...

HI, Sorry about this. I have my main form frm_Main_View, and my subform sbfActivities. sbfActivities is the control name, not the form name. In the on current of the main form frm_Main_View, i have done the following Private Sub Form_Current() If...

sorry, that was meant to say DATE ACTIVITY TYPE 01/01/09 Email 02/01/09 Visit BUTTON 03/01/09 Phone

Hi, Sorry. I have put the following in the _Open section on my subform If Me![Activity] = "Visit" Then Me!Command21.Visible = True Else Me!Command21.Visible = False End If It shows the button for all. The activity type is also in the subform. DATE

Hi, thanks for that. I want this to happen at the subform open stage, and only be visible when the activity textbox in the subform is a visit. Will this do this?

Hi, I have a subform, that i wish to have a command button visible on when a control "Activity" is visit, i.e. if me.activity = "Visit" then cmdShowVisitForm.visible =true. This doesnt work. Is there a way of only showing the command button on the rows that only have a control equal to...