Search results

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

Attachment Here's the example !!

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

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

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

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

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

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

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

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

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.

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

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

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

Thanks Jon Much appreciated. Graham

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) +...

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

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

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

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