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...
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'
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 == "") {...
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...
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 ==...
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.
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...
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".
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
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...
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 = ''
}
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...
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.