Search results

  1. Graham T

    Sending multiple (separate) e-mails based on results in query

    Further to this problem.... I have just tested this on my machine at home and find that there does not appear to be a problem with the code involved. It loops through each record of the recordset and places each records details in a new e-mail. It also allows me to use the command again...
  2. Graham T

    Sending multiple (separate) e-mails based on results in query

    Attachment Here's the example !!
  3. Graham T

    Sending multiple (separate) e-mails based on results in query

    I am trying to send separate e-mails for each record in a query, one e-mail per row of the query. The following code is what is being used and this is what is causing the problems. The code writes the results of various fields into the body of the e-mail (strEMailMsg) as text and not as an...
  4. Graham T

    Printing parameters on report

    Hope this helps.... Which luckily it did !! Graham
  5. Graham T

    Flashing Textbox/Label when Time Expires...

    Thanks Doc_Man I will look into this to see what I can do. Graham
  6. Graham T

    Printing parameters on report

    How to Print Parameters onto your report: If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and...
  7. Graham T

    Expression in Form Caption?

    Steve In the forms On current event try setting the Forms Caption Property. Something along the following lines: Private Sub Form_Current() Form.Caption = "Transactions : " & [AccountName] End Sub HTH Graham
  8. Graham T

    Input masks

    Look up InputMask Property in the Help Files and this will give you an idea as to what characters you can use. Graham
  9. Graham T

    Flashing Textbox/Label when Time Expires...

    If I have a Text Box containing Time Out (txtTimeOut - ShortTime format), can I have this flash if the value in time out is Less Than the Current Time. This should be so the user can visually see that the time has expired and the record will need to be updated. I know how to make a label...
  10. Graham T

    Query Parameters Printed on Report

    How to Print Parameters onto your report: If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and...
  11. Graham T

    Has anyone used Computeach?

    Try the National IT Training Centre for MCSD or MCAD qualifications. I would be very wary of anyone who “guaranteed” you a job in today's climate.
  12. Graham T

    Date Parameters on a Report

    How to Print Parameters onto your report: If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and...
  13. Graham T

    Assign Result of SQL Statement as a string to a Text Box or Label

    Thanks Rob Tested it and it does the trick.... I just wondered if there are any other approaches to this, other than DCount? Graham
  14. Graham T

    Assign Result of SQL Statement as a string to a Text Box or Label

    I have the following SQL statement that gives me a count of reviews: SELECT Count(tblReviews.lngReviewID) AS CountOflngReviewID FROM tblReviews GROUP BY tblReviews.strISBN_Number HAVING ((tblReviews.strISBN_Number)=[Forms]![frmLINK_Book_Author]![strISBN_Number])); I would like to display...
  15. Graham T

    Can anyone explain....

    Thanks Jon Much appreciated. Graham
  16. Graham T

    Can anyone explain....

    Whilst looking for a solution to a problem today, I came across a couple of topics by Pat H and Jon K and managed to cobble together the following: Select OrderNum, OrderDate FROM Order_Lines AS ol WHERE (SELECT COUNT(*) FROM Order_Lines WHERE UserID = ol.UserID AND OrderDate > ol.OrderDate) +...
  17. Graham T

    photo display

    Peter How to include a bound picture on form: While it's possible to actually store the images within the database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of overhead as well. This overhead is the information...
  18. Graham T

    Setting Default field value for telephone number.

    neileg Thanks for the reply. It would not be a problem to store this as another field, although again I still would not be able to set a default in the way that I would initially have thought possible. I could create a new table as a look up table as such and store an ID associated with the...
  19. Graham T

    Setting Default field value for telephone number.

    Thanks for the reply Robert. Although the user will still have to enter the dialling code. What I am after is that the default dialling code be available, and they would then just have to enter the number. Thanks Graham
  20. Graham T

    Setting Default field value for telephone number.

    Is it possible to set up a default field value that will display 01457 for a telephone number field. I have tried using the text and number data types, but it always removes the leading zero. TIA Graham
Back
Top Bottom