Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by weeze2

  1. weeze2

    ActiveX Microsoft Web Browser on Access Form

    Hi I have a ActiveX Web Browser on Access form. The code to load the url is: Public Sub Form_Load() Dim strURL As String Dim objIE As Object strURL = "xxxx.html" Set objIE = Me.WebBrowser0.Object objIE.Navigate2 strURL End Sub Is it possible to access the document objects...
  2. weeze2

    Mail Merge VBA in Office 2007

    Hi, hope somebody has seen this before We have some Word documents that when opened do a mail merge. Since we upgraded to Office 2007 there has been an error. The documents have some add on templates to import some ribbon buttons. When you merge more than one document at a time you get an...
  3. weeze2

    VBA and Sametime

    Hi there sorry, yes I was talking about Lotus Sametime :-) Does anyone know of a way to connect and send a message with Sametime from for example Access with VBA? Sort of like the Notes SendMail VBA funktion that connects to a Notes Database and sends mail - but instead connects to Sametime.
  4. weeze2

    VBA

    Hi there Is it possible to send Sametime messages with VBA? Cheers and thanks
  5. weeze2

    VBA and Sametime

    Hi there Is it possible to Send Sametime messages from VBA?
  6. weeze2

    Mergefield help

    I did not know one could use * in the IF expessions. Thanks!
  7. weeze2

    Mergefield help

    I solved it with the COMPARE keyword. COMPARE expression1 operator expression2
  8. weeze2

    Mergefield help

    Hi Is there some way to test part of a string in an "IF THEN ELSE" mergefield? - Sort of like a Left() or substring function but for mergefields. { IF { MERGEFIELD fieldname } = "qwerty" "y" "z" } For example if fieldnames length is unknown, can one test for "qwe" to give y and "qwerty" or...
  9. weeze2

    calculating holidays

    Hi Is there a way to calculate holidays in JavaScript The VBA below does that by calculating Easter and then adding or subtracting some days to get to the rest. I have tried to convert the code to JavaScript - the easter calculation works but the other holidays does not. Is it possible to...
  10. weeze2

    Case sensitive replace

    Thanks, just what I was looking for!
  11. weeze2

    Case sensitive replace

    Hi. The code below replaces "AAA" with "BBB" in the document. How can I avoid replacing "aaa" with "BBB"? I have tried Option Compare Binary but without results. I could not check for lowercase inside the With either. **************************************************** findx = "AAA" replacex...
  12. weeze2

    Setting Textfield with dropdown field in Word form.

    Thanks it works great with REF's
  13. weeze2

    { FORMDROPDOWN } Maximum length

    Is there a way to get more than 50 chars in an { FORMDROPDOWN } item?
  14. weeze2

    Setting Textfield with dropdown field in Word form.

    :-) Ok What I am trying to do is: The value of a { FORMDROPDOWN } field must be written to multiple { FORMTEXT } fields in a document. Example: In a letter a user selects "I" or "We" from the dropdown and the text changes throughout the document to I/We. I can do it with VBA but I am hoping...

Part and Inventory Search

Back
Top