Hello Jim :D , Very sorry sorry not to replay earlier - however I am in the middle of moving house and have been doing several trailer loads of Furniture to our new humble abode. :\
Iam amazed at the thought and construction that you have put into this project! It is well setup and has answered several questions that I have had in respect to other things like copyright notices etc and author details pop-ups etc which I love very much....
Weise
Last Activity: Jul 13 '10, 11:47 AM
Joined: Jun 14 '10
Location:
-
-
This is Great News! Thank you very much. I believe that alot of people will benefit from these samples as I have seen many questions and 1/2 answers on the web in regards to different less functional methods to cater for this problem.
this one has already by far superseded the many forums I have visited and as is with my last query here I was able to overcome other such problems with the help of members of this board , which I am also...Leave a comment:
-
Thank you Jim , for a well thought out and in depth explanation into this problem. Also for the sample which you have comprised for me above. A++++
The Query is awesome and I like the way that you have used a separate table for the compilation of the output email to be sent.
in respect to not using outlook as the application for sending the email and using instead the SMTP service , this would be advantageous indeed!. ...Leave a comment:
-
Send Email based on Query?
Hello again , well I have pretty much completed my project but have a small problem in regards to sending email's based on a Query.
I have a Query that returns results based on due date. This is working fine.Problem is I would like all records that contain an email_address to be sent a custom email using the fields from the query. for Example the Query returns
Title: Mr
FirstName:BOB
Lastname:Jones
ExpiredDate:1/1/10... -
Leave a comment:
-
Sorry M8 , was late last night and I had read your post but was adamant that I had the right Control :| Thank you.Leave a comment:
-
Hello SmileyOne :D, Thank you for your help on this one I Greatly Appreciate it.
and for your efforts I do not mind sharing this Database with this forum to help others in the same predicament as myself.
if you open the database and run the VehicleForm then update the NewWarrantDate field the NextwarrantDue field will be automatically updated afterwhich clicking on the [update] button transfers the NewWarrantDate over to the vehicle...Leave a comment:
-
Updating Mainform(SubForm1 from (SubForm2) )
Your Question was:
Hi there, I have a small Problem which I cannot resolve and am wondering if you could help me. Basically I have 3 Forms Names ClientForm/VehicleForm & JobForm.the MainForm is ClientForm which has the VehicleForm embedded as a SubForm of ClientForm.the embeded VehicleForm also has an Embedded form called JobForm. All forms are updated in order from Left to Right ClientForm>Vehi cleForm>JobForm .
... -
Ok I have found the solution Thanks to Bob Olston from allexperts.com.
Bob replied with the following;
As I told you previously, you can refer to a control on a form that is the top level form via this syntax
Forms!>formname >!<controlnam e>
So if NewWarrantExpir y is a control in the Vehicle form, you can update it via
Forms!Vehiclefo rm!newwarrantex piry = me.newwarrantda te...Leave a comment:
-
Appended
Bob Olston from allexperts.com replied.
ANSWER: To reference a control on the Main form from a subform:
Forms!MainFormN ame!ControlName
YOu could also use
me.parent.contr olname
---------------------------------------------------
However
Iam getting a number of errors trying all different ways to implement it
Also I have attached a Second image...Leave a comment:
-
Iam Having a similar problem and am trying to think how i can get around this. My scenario is thus; Iam building a DB for a friend who owns a garage. Basically they want a DB that can track all clients/vehicles & warrant of fitness/service Dates which will then lead to emailing / posting reminders to their customers when a new Warrant/Service is Due. I have setup Employee/Client/Vehicle/Job Tables for this purpose and have created relationships...Leave a comment:
No activity results to display
Leave a comment: