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!

Search results for query: *

  • Users: weeze2
  • Content: Threads
  • Order by date
  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

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

    VBA and Sametime

    Hi there Is it possible to Send Sametime messages from VBA?
  5. 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...
  6. 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...
  7. 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...
  8. weeze2

    { FORMDROPDOWN } Maximum length

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

    Setting Textfield with dropdown field in Word form.

    Hi I am trying to set the value of a Textfield in a word form with the value of a dropdown selectbox. I can do it with numbers, for example having Standard text of the field as "='bookmark'", but it does not work with text. Does anyone know how to do this? Thanks!
  10. weeze2

    Max. characters in MS Word Dropdown

    Hi there, There is only room for 50 characters in a dropdown-formfield (MS-Word)? I need to get 57 characters into a dropdown list but I can not see how that is possible. Can anyone help? Thanks!
  11. weeze2

    vba to set left table margin

    Hi How can one set the left margins og all tables in a document using VBA? I tried the record macro trick but inforuanately you cant move the table when recording :-( thanks
  12. weeze2

    Word opening in IE - How do I get back?

    Hi I had a word document that opens, play a macro and then window closes itself with: "ActiveWindow.Close SaveChanges:=False" Now I have a link from some HTML page that opens this Word document. The document opens inside the browser and I get en error when the macro tries to close with...
  13. weeze2

    Change bullet style in dot file with autotext

    Hi I am using a '.dot' that contains various paragraphs that are inserted into the document as Autotext with VBA. I have a problem that all the bullet formatting changed mysteriously since I made the template (from normal bullet to indentet text). I need to change the formatting for bullet...
  14. weeze2

    Auto BU

    Hi Does anyone know if there is some way with VBA to automatically make a backup of a Access DB a few times a day? Thanks!
  15. weeze2

    Mod....or Not

    Hi! I need to use the mod() function in Excel 2003...but I can't and keep getting errors. Is it maybe called something else than 'mod'? Thanks!
  16. weeze2

    inserting pagenumber as text

    Hi! How does one with VBA insert pagenumber/pages as TEXT. The reason i am trying to do this is because when unlinking all fields and shapes in the document, the pagenumber in the pagefoot is unlinked and all the pages gets the same "page"/"pages" value. Can anyone help...or have another...
  17. weeze2

    2 columns as one

    Hi Im not to well informed with when it comes to sql. Is it easy to join the contents of 2 columns into one? Something like this... Table: xx aa bb xx xx xx xx aa xx xx xx xx xx aa xx xx xx xx xx aa xx xx xx xx xx aa xx xx xx xx xx aa bb xx xx xx xx aa bb xx xx xx xx aa xx xx xx xx Query...
  18. weeze2

    FollowHyperlink limit?

    Hi! Does anyone know if there is a limit to the address length when using FollowHyperlink...for example: ActiveDocument.FollowHyperlink Address:=xxxxxxxx I am having problems passing long url's.
  19. weeze2

    VBA for [Shift][Ctrl][F9] when using mailmerge

    Hi! VBA for [Shift][Ctrl][F9] when using mailmerge: Can anyone help me? How can I get hold of the VBA code for removing mergefields from a document and replacing it with plain text - Like when you use [Shift][Ctrl][F9]? And a second part to the question - can one restrict the effect of this...
  20. weeze2

    Is there a "BeforePrint" for Word97

    Hi, is there a "BeforePrint" event one can use in Word97. Thanks

Part and Inventory Search

Back
Top