Search results

  1. B

    VBA Enable TextBox with ComboBox Selection

    Compressed Version of what you currently have. PROBLEM: I do not see your design here. Any way you can screenshot your form layout, and maybe give another description of what it is that you wish to do? Also, something that might show your problem is the red highlighted sections below...
  2. B

    DCount with multiple createris

    janith Could you copy your whole code snippet in [CODE] [/ CODE] braces for us please? =]
  3. B

    DCount with multiple createris

    I was far too entertained with createris!
  4. B

    How to create .HTMLBody tables for Outlook Email

    <td style="text-align: left">
  5. B

    How to create .HTMLBody tables for Outlook Email

    Not sure what your question is looking for exactly, but this is how you format tables in HTML <table> <tr> <td>Field Changes</td> <td>Project Address</td> <td>On Hold</td> </tr> <tr> <td>strControlName</td> <td>strProjectAddress</td> <td>strApproveStatus</td> </tr> <tr>...
  6. B

    Word Sentiment Value Tables

    FYI, This turned out to be a really cool and informative project for me. I've been able to query my set of 5,000 incoming emails and come up with a spectrum between positive neutral and negative emails. The results seem to be effective, even with a small table of un-tuned word sentiment values...
  7. B

    In dire need of help!

    Thank you for your guidance, this is the query that worked out for me. =] SELECT mail.ID, mail.subject, mail.body, Sum([sentiment_score]*[count]) AS Score FROM words INNER JOIN ( mail INNER JOIN mail_words ON mail.ID = mail_words.mail_id) ON words.ID = mail_words.word_id...
  8. B

    In dire need of help!

    My brain is not in any way allowing to me do SQL today. This is the most simple task, but I accept the fact that Mr. Brain says NO and that NO means NO! :banghead: Could I get some help with creating this query. Results: mail.id, mail.subject, mail.body, SUM(words.sentiment_score)...
  9. B

    Reducing Code

    Really.... at the same time hahaha
  10. B

    Reducing Code

    This could be off because I don't know how you're trying to append the same variable. Let me know if you need changes. COMPACT Dim i As Integer For i = 0 To 19 vg = IIf(Me.Controls("Toggle" & i).Value, IIf(vg = vbNullString, Me.Controls("Toggle" & i).Caption, vg & " - " &...
  11. B

    Word Sentiment Value Tables

    You're awesome! Haha I did add these words to my seed already as well :P
  12. B

    Word Sentiment Value Tables

    I'm not looking for frequency, I'm looking for sentiment values. Positive / Negative word scoring. With that said, thank you for your information as well =]
  13. B

    Word Sentiment Value Tables

    Just a cool piece of information to share: The fourth most used word in my 5000 emails is Please =]
  14. B

    Word Sentiment Value Tables

    https://www.cs.uic.edu/~liub/FBS/NLP-handbook-sentiment-analysis.pdf If you're interested in the subject. This is a great read so far.
  15. B

    Word Sentiment Value Tables

    Thank you for your consideration and time for finding the wiki page. I've been researching and reading up on it a lot for the past few days. Would be a fun project I think :P
  16. B

    Word Sentiment Value Tables

    Hello! I've been playing around with the Outlook.Application object, and have come to the conclusion that I would like to play with sentiment scoring emails by indexing every use of every word. The only thing I'm missing is sentiment values. So, that leads me to ask if any of you have come...
  17. B

    Testing if App exists

    http://stackoverflow.com/questions/30841320/activex-component-cant-create-object-for-outlook-vba
  18. B

    Testing if App exists

    try On Error GoTo ErrorLabel ErrorLabel: MsgBox err.Description
  19. B

    Testing if App exists

    try “Outlook.Application”
  20. B

    Combobox changing data problem

    This post is just for our eyes. I'll take a look at it after my meeting. Private Sub City_Town_NotInList(NewData As String, Response As Integer) Dim TmpQuestion As String ' Temporary storage for the question Dim TempCity As String ' Temporary Storage for the City data...
Back
Top Bottom