Recent content by icezebra

  1. I

    SQL Query is making me tear what little hair I have left out.

    Fantastic. I did go searching, but did not come across that link... Works perfectly. Thanks.
  2. I

    SQL Query is making me tear what little hair I have left out.

    Anybody? Help!
  3. I

    SQL Query is making me tear what little hair I have left out.

    P.s. If you're suggesting that Excel is truncating the field, then yes, I'm aware that it doesn't... I'm thinking it's something to do with the Query, how I'm executing it or some hidden option in the database. iz
  4. I

    SQL Query is making me tear what little hair I have left out.

    Cheers, but it's not that unfortunately. I've tested it by entering in a continuous stream of characters into a memo field in the table "MainTable"... Approximately 1000 characters. When running the query and viewing the output in Excel, the corresponding cell only contained 255 characters...
  5. I

    Performing a spell check on the contents of a userform field (EXCEL)

    Open the form for editing, right click on the field you wish to spell check - go to properties - then to the "Event" tab. Double click the "On_Exit" box - [Event Procedure] will appear. Click the box with three dots inside that appears to the right. The VB Editor will appear. Use the below...
  6. I

    Text formatting in Lotus Notes

    You're sort of in the wrong place here...! I found a similar problem in Access, that I couldn't format emails programmatically. Until I went about it a different method and created HTML emails instead. Thus, in the text (or code) I was passing over, I could stick spaces in, change colours...
  7. I

    SQL Query is making me tear what little hair I have left out.

    Afternoon all. I'm running my own report on the database. This is basically a SQL query constructed depending upon options on the form. All works great and I have it saving to the person's desktop and opening in Excel automatically. I'm recreating the Querydef each time; So creating this...
  8. I

    Check Query Exists?

    Once again... much obliged. Cheers!
  9. I

    Check Query Exists?

    How would I do the same for a form? For Each Form in CurrentDB If... Doesn't work. Arrg. :D
  10. I

    Check Query Exists?

    Top stuff. That solves my problem perfectly!
  11. I

    Check Query Exists?

    How would I check programmatically that a querydef already exists. I.e. something along these lines: If Db.QueryDefs(strQueryDef).Exist = False Then Set QD = Db.CreateQueryDef(strQueryDef, strSQL) Else ..... and so on. It's the If line I'm interested in. strQueryDef is a...
  12. I

    Emboldening a string...

    Aha, very helpful! Thank you muchly.
  13. I

    Emboldening a string...

    This is where I'm at at the moment: If Who = "SSR" Then Dim mess_body, Email, boldmess As String Dim appOutLook, MailOutLook Email = "Me" Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook =...
  14. I

    Emailing within Access - 'From' Field?

    Ah, I wondered if that was the case. Thanks for your help.
  15. I

    Emailing within Access - 'From' Field?

    I have the following code: Dim mess_body As String Dim appOutLook Dim Email As String Dim MailOutLook Email = MPTM Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem)...
See more
Top Bottom