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!

Register Log in
  • Congratulations derfloh 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: duGly
  • Order by date
  1. duGly

    Displaying a Color Picker Dialog Box

    Thanks, Skip. You have replied to many of my posts in the past and I always appreciate your help. I'm actually looking for something more generic, though. I'm not trying to change the font, but select a color. I want to use this for table background colors, textboxes, etc., so it needs to be...
  2. duGly

    Displaying a Color Picker Dialog Box

    I am using VBA in Word 2003. I want to display a dialog box to allow the user to select a color, like the one displayed when you choose More Colors from the Font Color drop-down button from the toolbar. I could not find one among Word's Built-in Dialog Boxes, and VBA's help files failed to live...
  3. duGly

    Digital Certificate discarded when template assigned

    Good question, Gerry. A document created from a template is not automatically signed with the digital certificate, even if the template is. However, if a signed document is copied, the copy retains the signature. Since I'm not about to distribute my digital certificate to my clients, I thought...
  4. duGly

    Moving items from one list to another - error handling problem

    It needs to go in the click or change event handler for the list box so that it runs each time the user changes the selection. [banghead] — Artificial intelligence is no match for natural stupidity.
  5. duGly

    Digital Certificate discarded when template assigned

    The attachment of a template to the document is done programmatically based on which template the user chooses. So it will always be done on another computer than my own. [banghead] — Artificial intelligence is no match for natural stupidity.
  6. duGly

    barcode Scanner code needs to be inside an Access application

    How involved is the VB code? VBA is very similar to VB, just with less bells and whistles (i.e. objects, functions, methods, and valid keywords). If the code you're trying to export is basic enough, it might just work straight out of the box. [banghead] — Artificial intelligence is no match...
  7. duGly

    Moving items from one list to another - error handling problem

    Something I like to do is disable controls altogether rather than show a MsgBox. For example, in the event handler for your list box, you could add the following code which enables the command button only if one or more entries are selected in the respective list box: cmdMoveSingleEntry.Enabled...
  8. duGly

    Digital Certificate discarded when template assigned

    I'm using VBA with Word 2003. I have a project signed with a commercial digital certificate (from GlobalSign). The problem described below happens when I modify the document on a computer other than my own. When I change the template attached to the document (either manually or...
  9. duGly

    Changing a language

    My best solution would be to have the language preference stored in a field in some table, accessible by an option button on a form. Then create an Form_Open or Report_Open event handler for each form and/or report that needs to be translated. In the open event, set the captions and/or...
  10. duGly

    VBA String being truncated to 255 characters

    Have you checked the value in cell Range("E" & I)? Perhaps there is a rogue value that is wiping out your string. I don't know; just thinking out loud. [banghead]— Artificial intelligence is no match for natural stupidity.
  11. duGly

    Style not linking to ListTemplate

    OK, I've done some more work on this. It still isn't working, but I think I have identified the problem. Now I just need a solution. Once again, what I'm trying to do is set the NumberFormat, NumberStyle, and StartAt properties of my ListTemplate. I'm using VBA in Word 2003. I have tested and...
  12. duGly

    VBA String being truncated to 255 characters

    Mike, When stepping through your code, at which line of your code does the string become truncated? [banghead]— Artificial intelligence is no match for natural stupidity.
  13. duGly

    VB for applications Grab data from another worksheet in Excel

    Actually, as Skip pointed out, selecting or activating are NOT necessary. In fact, that is what causes the screen flash. Selecting and activating greatly slow down the code. It is almost always preferable to assign the values directly, rather than selecting or activating. Also, there is no...
  14. duGly

    How do I deploy macros?

    Naz, Unfortunately, there is no way to programmatically change the security setting in an MS Office app. Actually, I suppose that's fortunate, because doing so would allow any hacker to destroy your computer by disabling your security setting before allowing the malicious code to run. However...
  15. duGly

    VB for applications Grab data from another worksheet in Excel

    I like Skip's solutions. You can also avoid using the variable altogether (and make your code shorter) with the following single line of code: Sheets("Sheet1").Cells(Row, Column) = Sheets("Sheet2").Cells(Row, Column) Or, if you have the cells named, [cellName1] = [cellName2] [banghead]—...
  16. duGly

    AddToRecentFiles not functioning

    Cool! Thank you so much! [banghead]— Artificial intelligence is no match for natural stupidity.
  17. duGly

    How Do I Automate Adding Hyperlinks to a Word Document?

    I'm a bit confused, Peg. Perhaps we're referring to two different things when we talk of the Project Explorer. The Project Explorer I refer to is a window within the VBA window. As I mentioned, it is traditionally on the left-hand side of the window, unless it has been moved. If it has been...
  18. duGly

    How Do I Automate Adding Hyperlinks to a Word Document?

    To add code to the Normal template: 1) Open VBA 2) Open the Project Explorer (Ctrl+R), if it is not open already. (By default, the Project Explorer is located on the left-hand side of the VBA environment, unless it's been moved.) 3) Select "Normal". If you wish, click on the + sign next to...
  19. duGly

    Incompatible Type? Filesys.FileExists(txtPath)

    What application are you writing in? Is filesys an object variable? If so, what type? [banghead]— Artificial intelligence is no match for natural stupidity.
  20. duGly

    Difference between two dates

    I like PHV's solution. TIA, the reason you were getting an error code is because the DateDiff function requires date values, while you were passing it strings (minDate and thisDate). Actually, since you did not explicitly dim minDate and thisDate, they were, by default, variants. But when you...

Part and Inventory Search

Back
Top