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...

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...

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, 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...