Search results for query: *

I created a basic Outlook form which has set recipients and text etc. Now I am looking to set a button to on click simply send the the form (.oft file) which is stored on a specific drive. However I am not sure as to how best to do this, I written various code to send emails with text and...

I created a basic Outlook form which has set recipients and text etc. Now I am looking to set a button to on click simply send the the form (.oft file) which is stored on a specific drive. However I am not sure as to how best to do this, I written various code to send emails with text and...

I created a basic Outlook form which has set recipients and text etc. Now I am looking to set a button to on click simply send the the form (.oft file) which is stored on a specific drive. However I am not sure as to how best to do this, I written various code to send emails with text and...

I have a code behind a button which on click creates a email and adds set text to the body of the email. Below is a cut down version of this. Now I'm looking to find a way to be able to change the format of the text i.e changing to bold, colour red, font Arial and underline. Now unfortunately...

I have a code behind a button which on click creates a email and adds set text to the body of the email. Below is a cut down version of this. Now I'm looking to find a way to be able to change the format of the text i.e changing to bold, colour red, font Arial and underline. Now unfortunately...

Hi, I have recently started to learn about ASP and how to go about converting my Access Database to ASP. Now I've found various third party table and query converters but have not come accross anything that will convert other objects such as forms, reports and macro's. I have tried convert...

Hi, I have recently started to learn about ASP and how to go about converting my Access Database to ASP. Now I've found various third party table and query converters but have not come accross anything that will convert other objects such as forms, reports and macro's. I have tried convert...

The following is a sample of a code I use to generate and send a email, it places the text into the body of the email itself as opposed to just an attachment. Now this all works fine but am now looking to jazz the email up by adding some formatting to the text i.e font, size, colour, boldness...

Hi, I just sent you a mail! Thanks, Kunal

SunTsu, Firstly I just want to thank you for taking time out to help me with my query problems, I very much appriciate it. I was wondering if I can pick your brain again. I just can't seem to get it right, I think perhaps I should have given you the full SQL I want to use as I have a around...

I have a query which I want to use to search for records by a date range. The following is a cut down version of the SQL I use. SELECT NewClient.[Date requested] FROM NewClient WHERE ((IIf([Forms]![MIS]![Start]<>&quot;(All)&quot;,(NewClient.[Date requested]) Between [Forms]![MIS]![Start] And...

I have a query which I want to use to search for records by a date range. The following is a cut down version of the SQL I use. SELECT NewClient.[Date requested] FROM NewClient WHERE ((IIf([Forms]![MIS]![Start]<>&quot;(All)&quot;,(NewClient.[Date requested]) Between [Forms]![MIS]![Start] And...

I have a query which I want to use to search for records by a date range. The following is a cut down version of the SQL I use. SELECT NewClient.[Date requested] FROM NewClient WHERE ((IIf([Forms]![MIS]![Start]<>&quot;(All)&quot;,(NewClient.[Date requested]) Between [Forms]![MIS]![Start] And...

I have a query which I want to use to search for records by a date range. The following is a cut down version of the SQL I use. SELECT NewClient.[Date requested] FROM NewClient WHERE ((IIf([Forms]![MIS]![Start]<>&quot;(All)&quot;,(NewClient.[Date requested]) Between [Forms]![MIS]![Start] And...

Thnaks for you suggestion, thing is that I need to be able to set the quiery to look at a combo box value on a form and if it says &quot;(ALL)&quot; then show ALL records whether it has a business unit or not. Would be greatful if you suggest how to modify your SQL to look at the form. Many...

Sorry just read your second post. I don't have any relationships set with this table anywhere in my DB. Thanks, Kunl

SunTsu, Thnaks for your suggestions, I tried it and unfortunately it did not work, I got the same results as I did with my SQL. It still seems to only pick up record where the business unit is NOT null, intstead of all records. I criterias some how needs to say if the combo box says...

I have a select query which has a number of criteria's which referance combo boxs on a form. The following is a cut down version of the SQL I use: SELECT NewClient.Name, NewClient.[Business Unit] FROM NewClient WHERE (((NewClient.[Business Unit])=IIf([Forms]![MIS]![BU]<>...

I have a select query which has a number of criteria's which referance combo boxs on a form. The following is a cut down version of the SQL I use: SELECT NewClient.Name, NewClient.[Business Unit] FROM NewClient WHERE (((NewClient.[Business Unit])=IIf([Forms]![MIS]![BU]<>...

I have a select query which has a number of crietia's which referance combo boxs on a form. The following is a cut down version of the SQL I use: SELECT NewClient.Name, NewClient.[Business Unit] FROM NewClient WHERE (((NewClient.[Business...