Search results for query: *

can anybody point me in the direction as to be able to make report and form appear on the same vie and be able to see text selected in form appear in report as sentences like word depending upon what is selected. Thanks all help greatly appreciated

Please help. Still looking

Hi Everybody, I have multiple appointments set for a person in outllok over time . The way I set this is by code from my form where the appointments are added based ona date and it generates; 4 future dates as 3 month appointment; 9 month , 1 year and 2 year. All this takes place with a single...

Thanks Cajun a lot. your code worked word to word. But remeber I had also asked if there was a way to put other things in the subject portion apart from SSn as it would be weired that it only show some numbers. i think it would be good if I could also see the patient name and phone number with...

This is the working code only for the three month box: Private Sub AddAppt_Click() On Error GoTo AddAppt_Err Dim dteTemp As Date dteTemp = Me.DateEnrolled Me.DateEnrolled = dteTemp Me.Threemonthappointment = DateAdd("m", 3, dteTemp) ' Save record first to be sure required fields are filled...

Thanks for this post, I was able to use the microsoft fix to get the values in outlook but Now i want to get multiple appointment times based on a single date and they are in the future with 3, 9 and 12 months increment. So the problem is how to insert all the values in their respective...

Thanks a lot Tom and Cajun it was a great help and when i fixed the code it took care of the date error, so now it works great but now let me bring two other things if you guys can help with. 1. You see that in the code 5 messages above I have two command buttons for sending to outlook the...

this is the portion of the code that i posted earlier with the modification and u already know the error as above Private Sub AddAppt_Click() On Error GoTo AddAppt_Err Dim dteTemp As Date Me.DateEnrolled = dteTemp Me.Threemonthappointment = DateAdd("m", 3, dteTemp) ' Save record first to be...

Hi Tom tried ur suggestion and inserted the code before the Send to outllok code in the comand button it does enter the date and send it to outlook at the same time but now it's changing the date in DateEnrolled to a date in 1899 and the threemonthappointment date to 3 months ahead in the year...

Hi there, This is the complete code i have presently on my subform: Option Compare Database Dim cboOriginator As ComboBox Private Sub AddAppt_Click() On Error GoTo AddAppt_Err ' Save record first to be sure required fields are filled. DoCmd.RunCommand acCmdSaveRecord...

It still doesnot work

Dear Watson, I am still looking for it to work but has not worked so far. thanks

Its not the control source but the default value for the threemonthappointment and ~+270 for the ninemonthappointment. That is how i achieved it before when the field was on two different forms and I dinot need the requery macro as the value always defaulted to the value in the DateEnrolled +...

Hi Cajun, i am sorry that is what i mean.

I donot know what the control is for the form I created the form seperatly and puuled it into the Demographics forms, So i understand that becomes a subform and when I click on properties on the main form I get Subform/subreports: Visits. Also the name and control source both show the same name...

Thanks Dear Watson, 1. The names are correct as i see it. 2. The command button is not for pulling the date function but to add the dates to outlook oncethey show up in their respective fields. 3.The command button is also on the subform named Visits which is on the main form named...

Hi Cajun, I ahve also tried this: =[Forms]![Demographics]![Visits]![DateEnrolled]+90 but it doesn't work now and neither does Tom's remedy . I am desperate for the solution. Please help

I do not do tab out of that field instead i have a button to add the appointment date to outlook and that waht i click when the date shows up. Which it has not so far. Let me also explain to u what the date enrolled field is like its a date\time field with a combobox feature which on the mouse...

yes now they are and yes how they appear.

Dear Watson, tried your suggestions but it didnot produce any results. I included the code as provided on the after update event. it reads as: Private Sub Date_Enrolled_AfterUpdate() Dim dteTemp As Date dteTemp = DateAdd("m", 3, [Date Enrolled]) Me.threemonthappointment = dteTemp End Sub Any...