Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Kunal

  1. Kunal

    Set button to send Outlook form (.oft)

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

    Set button to send Outlook form (.oft)

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

    Set button to send Outlook form (.oft)

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

    Change format of text in email generated by VBA

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

    Change format of text in email generated by VBA

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

    Convert an Access Object to ASP

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

    Convert an Access Object to ASP

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

    Change format of email text via code

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

    Search by date query via a form

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

    Search by date query via a form

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

    Search by date query via a form

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

    Search by date query via a form

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

    Search by date

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

    Search by date

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

    Query Criteria Problem

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

Part and Inventory Search

Back
Top