Recent content by goat

Table is TBLTABLEQUERY2 Field is EXP Criteria is FX

Hello, Really struggling to get DCount to work. I need a text box's control source to be the amount of records in a column on a table within a criteria. Please can you help ! Regards The Goatboy

Hello, Please can you advise how to paragraph in expressions I.e if I use X = "123456 123456" How can I get it to appear as 123456 123456 Also, how can I make the colour of the text blue ?

the row source type is table/query the row source is the title of the table

Cheers mate ! Looks like it would do the trick but for some reason my combo box is appearing unbound eventhough it is linked to the table. Because of this its saying that it can find the name in my name and address book. any ideas ?

see the test attached :)

Sorry dude, It won't let me attach it for some reason so I'll give you the code. Mailer1 module Public Function SendNotesMail(subject As String, Attachment As String, BodyText As String, SaveIt As Boolean, RtnRec As String) Dim y As Integer, z As String Dim X Dim recip(50) As Variant Dim...

Sorry to be a pain The database attached has a combo box and a button on the 'data entry' form. What I require is when the email address is selected in the combo box and the button pressed it sends an email. The email coding in the mailer1 module works fine however I am stuck on how to make...

Thanks for the reply, Can you convert it to MS Access 97 for me please, its coming up as an unrecognised database format. Many thanks

Hello, Please can you guys help me. It probably quite simple but I'm still a novice when it comes to Access VB coding. I am currently using the coding which, on the press of a button sends a mail in Lotus notes. This coding is all working fine but I want the MailDoc.sendto = to use the data...