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. dssjon

    acrobat javascript event code

    I have code that changes a fields value but it does not populate the field until the user clicks out of the field. i would like to populate it when the code runs. i believe xfa.event.newText is used for this but I have only found examples that use combo box's. Any ideas on how to do this...
  2. dssjon

    Prepopulate PDF with data Java Web Services

    Does anyone have any experience prepopulating PDF forms using java web services? I'm trying to map my return data from my web service to specific form fields in my pdf form. Any help?
  3. dssjon

    XML: How To Set Input Mask for Phone Numbers

    I'm using an XML Schema that defines data type properties that are used in adobe acrobat forms. The forms are automatically generated from the XML Schema. Some of the properties that I can define are length, type, min/max character restrictions etc, but I need an input mask as well so that...
  4. dssjon

    XML: How To Set Input Mask for Phone Numbers

    Anyone know How To Set Input Mask for Phone Numbers in XML?
  5. dssjon

    Duplicate records in Table

    It works, thanks!
  6. dssjon

    Duplicate records in Table

    I need to duplicate records in a table based on an ID# so I can expire the first copy and set the new records as current. I'm doing this because we cannot update records directly, we have to expire old records and update them using a duplicate of them. So I have a 'status' and 'completion date'...
  7. dssjon

    Data Access Page combobox issue

    I have a data access page that shows the record from a table in columnar rows. I would like for a user to be able to insert a new record and choose values for specific rows using the toolbar. Rows such as Vendor could be dell, HP, apple, etc. Whenever I have changed the text box to group filter...
  8. dssjon

    Bug in copyhere method!

    I can't overwrite a file even if I tell it to, the confirm file replace dialog always pops up and I have to click "yes to all" even though the int flag 16 is set to always say yes to all.
  9. dssjon

    Bug in copyhere method!

    Hello all, I'm using copyhere method to copy files and I want to overwrite existing files: objFolder_DESTINATION.copyhere objFiles_SOURCE, 16 The only problem is that there is a bug in the overwrite functionality in the copyhere method. Does anyone know another simple way to overwrite files...
  10. dssjon

    Access ActiveX Calendar Control

    Sorry, I never found the appropriate solution.
  11. dssjon

    Zip Files Function Help

    What would you suggest other than the built in windows compression?
  12. dssjon

    Zip Files Function Help

    Much appreciated but I am not allowed to install third party software in our intranet. We can't even use winzip.
  13. dssjon

    Zip Files Function Help

    Hello, I have a working zip function that zips all files in a directory into one zip file. I need the function to zip only files I specify from a record set that contains file path/name of text files. I have tried to call the function and pass in values from a recordset but once it creates the...
  14. dssjon

    Help with Recordset Case Statement

    Thanks for the advice. I will try it out.
  15. dssjon

    Help with Recordset Case Statement

    Indeed. I'm a newbie so I know there are probably glaring problems in my code. Here are the functions: Function UnzipFile(varFileName_SOURCE_COMPLETE As Variant, varFolderName_DESTINATION_COMPLETE As Variant) As String 'Arguments should be like "C:\TestFile.zip", "C:\TestFolder" 'Function...
  16. dssjon

    Help with Recordset Case Statement

    When I call unzipfiles or movefiles by themselves they work as intended. It's only when I try to use them in the case statement..
  17. dssjon

    Help with Recordset Case Statement

    I have source paths with file names and destination paths for example under source field: c:\test\files.zip under destination field: c:\test\movefileshere\
  18. dssjon

    Help with Recordset Case Statement

    Okay, I've changed the code to an If else statement but it's still broken. Is this reading the file extensions from the recordset properly?
  19. dssjon

    Help with Recordset Case Statement

    I am a newbie to Access and VBA and I'm having trouble finding how to determine whether a file is a zip or txt from a recordset, and calling the appropriate function for said files. Does anyone see anything wrong with this? Help is greatly appreciated. Sub Test_2(strTableName As String) Dim...
  20. dssjon

    SQL result from table to textbox - simple but need help.

    Hello there, I'm using =DLookUp("[Username]&'on '&[Date]","Lastrun") as the parameter for control source in a textbox to display a username and date on a form. The username and date is located in a log table named lastrun. Dlookup is returning the first record from the table but what I need...

Part and Inventory Search

Back
Top