This calculator (input2000.zip) is just what I have been looking for. I am designing a simple way to book calls into diaries for Financial Advisors. But allowing us to get the overview of all calls booked in to date.
The problem is as follows....
We use a form (client) see (db2.zip) as a data input form. on this form we have the ability to add the date we have arranged the appointment etc. This is stored in the table (customers) we can then mail merge letters confirming the appointment.
What i would like to do is add a button so the fields (Contactlastname), (factfindtime) and (postalcode) for the current record are updated into the diary automatically. This means the Factfind date record needs to be added to tblinput underinputdate as a new record, the rest of information needs to be consolodated into the same record in Input text. for more info on the calender please follow the link at the bottom of the screen.
when we then access the diary we can see under the relevant dates the clients surname and time of call and postcode
I Am sure this is a very simple piece of code that is needed but I just cannot get my head around it.
Please Help as my Good lady Is now not speaking to me as I have ignored her for the last 72hours
See the orig thread at:-
http://www.access-programmers.co.uk/forums/showthread.php?t=103747
The problem is as follows....
We use a form (client) see (db2.zip) as a data input form. on this form we have the ability to add the date we have arranged the appointment etc. This is stored in the table (customers) we can then mail merge letters confirming the appointment.
What i would like to do is add a button so the fields (Contactlastname), (factfindtime) and (postalcode) for the current record are updated into the diary automatically. This means the Factfind date record needs to be added to tblinput underinputdate as a new record, the rest of information needs to be consolodated into the same record in Input text. for more info on the calender please follow the link at the bottom of the screen.
when we then access the diary we can see under the relevant dates the clients surname and time of call and postcode
I Am sure this is a very simple piece of code that is needed but I just cannot get my head around it.
Please Help as my Good lady Is now not speaking to me as I have ignored her for the last 72hours
See the orig thread at:-
http://www.access-programmers.co.uk/forums/showthread.php?t=103747
