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 Mike Lewis 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: *

  1. MarkWalsh

    Move Multiple Files to Various Folders (with varying criteria)

    That assumes that the file date will match the date used in the name, which may or may not be the case. The reports may have been run on a different date than the date their data is related to. Also, the date of the file might change if it is sent through email, or other ways. If the file's...
  2. MarkWalsh

    How to add grayed out text to a PDF text field

    Did you put the code in the field's 'Custom Format Script' or the 'Custom Calculation Script'? IF you put it in the calculation script, remove it from there, and go to the 'Format' tab, select 'Custom' from the 'Select format getegory' dropdown, then enter it into the 'Custom FOrmat Script'
  3. MarkWalsh

    How to add grayed out text to a PDF text field

    Clear the default value from the field, put the following in the 'Custom Format' field for every date field that you want to display the message for: formatFieldDefaultValue () And put the following in a document level script: function formatFieldDefaultValue () { if (event.value == "") {...
  4. MarkWalsh

    How to add grayed out text to a PDF text field

    Yeah, that's how my customer wanted his to work. Setting the Default Value puts that value into the field, you can clear the text field contents after you set the default, and it would do what you want, but if the user resets the form, it will put the default back into the field. You can put...
  5. MarkWalsh

    How to add grayed out text to a PDF text field

    Here's what I use. I set the default value for the field to be whatever instructions I want displayed (i.e. 'Enter a date here... xxxxxxxx'). Add the following code to the document javascript: function formatFieldDefaultValue () { if (event.value == "" || event.value ==...
  6. MarkWalsh

    Text spacing in textbox of PDF

    Under the 'Options' tab of the text field properties, click 'Comb of' checkbox and enter the number of characters the field will hold. This will space the characters to fit your field width. You will need to uncheck all other options to allow selecting the 'Comb' option.
  7. MarkWalsh

    Text spacing in textbox of PDF

    I can give you a script which adds a space between each character, but I'd guess that's not what you are looking for. There's also the 'Comb' feature which spaces each character out to fit X characters to the width of the field. You're going to have to be more specific about what you mean by...
  8. MarkWalsh

    Replace character in VBA Excel code

    The proper way to deal with single quotes in SQL is to replace each single quote with 2 single quotes e.g. sCOMMENT_TEXT = Replace(sCOMMENT_TEXT, "'", "''") This way, if you enter "Bob O'Brien" into a record, you won't end up with "Bob OBrien".
  9. MarkWalsh

    When Option Explicit is ignored

    >>Is that lazy or what? >Can't be; I do it too It must be; because I do it too. ;)
  10. MarkWalsh

    Anyone know how to get to Adobe Acrobat objexts using VBA?

    I have worked with Acrobat objects, but it's been a long time, and I wasn't doing any importing/exporting FDF files. Here's a link I found which might be helpful: http://www.vbaexpress.com/forum/showthread.php?t=28501
  11. MarkWalsh

    check if a shape is a textbox or contains textboxes

    Instead of trapping for an error, I would check the shape's type to see if it is a msoGroup, and only access the groupitems if so. For Each shp In Application.ActiveDocument.Shapes If shp.TextFrame.HasText Then 'Doing some actions 'This part is working well ElseIf shp.Type = msoGroup Then...
  12. MarkWalsh

    Form field returns $0.00 instead of blank

    Depending on how you are doing the calculation, you can achieve this in either the calculation or format scripts. Try this in the 'Format' script: if (event.value == 0) { event.value = '' }
  13. MarkWalsh

    Adobe Acrobat Check Box Problems

    if (this.getField('Checkbox Numbers').value == 'Off') { // Disable field this.getField('Numbers Font').display = display.hidden } else { // Enable field this.getField('Numbers Font').display = display.visible }
  14. MarkWalsh

    fit page when bookmarks are clicked

    Check the properties of the link. You may have 'fit width' as part of the page view for that link.
  15. MarkWalsh

    Problem with Running Two Loop statements within the same Macro

    It's still hard for me to understand what you are trying to do; so I guess it might be possible to reusethe variable in your inner and outer loop in certain instances, but even if it were, I would never do this myself - I'd always use a separate variable for the inner and outer loops. When the...
  16. MarkWalsh

    Problem with Running Two Loop statements within the same Macro

    Hard for me to tell, but are you using the same variable (n) as a counter for both loops?
  17. MarkWalsh

    Open Excel via MsgBox

    The code works properly for me - it only produces an error if the file is already opened. Otherwise, it opens the excel document. Are you absolutely sure the filepath is correct?
  18. MarkWalsh

    Open Excel via MsgBox

    Try this: stAppName = "excel.exe ""C:\Documents and Settings\Igawa\Desktop\temp.xls"""
  19. MarkWalsh

    Open Excel via MsgBox

    You most likely have to put quotes (not sure if it needs to be single or double quotes) around the filepath when you use it in a shell command.
  20. MarkWalsh

    Auto run macro and inserting text from txt file into powerpoint

    Powerpoint does not have an autorun capability for presentations (unlike other office applications which will allow you to autorun code when a document opens); it only works in a PowerPoint add-in, which must be loaded in the application. You have to initiate the macro manually (through a...

Part and Inventory Search

Back
Top