Search results for query: *

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

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?

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

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

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

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

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

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

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

I have figured out how to move files from the database current project path to another directory but I need help moving files to and from a directory that the user will specify in a table named tblPath. The user will simply enter a directory name in a field such as "c:\test" The goal is to use...

I need help adding file names from a directory to a listbox. Any help?

Hello, I was wondering how I can make a textbox fill with text when I click an option button. Also how could I make a listbox fill with data from a table. Right now I use which doesnt work. Private Sub Option20_GotFocus() Forms!PLU!List29.RowSourceType = "Table/Query"...

I'm trying to find out how to execute a SQL Server DTS package from Access. If there is a way, I would appreciate any feedback about how to do that. Thanks!

Hello there, I am new to Access VBA and I am curious if there is a ActiveX control available (or something with similar functionality) that actually allows scheduling activities in an access form. For instance, it would be nice for the user to see an interface similar to an outlook calendar...

I need to figure out how to edit this code to work for multiple zip files, not just a single hard coded file. I could call the unzip method multiple times on a list but I can't figure out how to retrieve the file names from a listbox in order to call unzip on the file. Any help out there ? :)...

I am trying to reference a value from a listbox as a string so that I can use that as a filename in a sub. I need to unzip all the file names that I have in a table, I am using that tables rowsource data in a listbox and from the listbox I want to copy the filename and use it in an unzip sub...

I need to know if it is possible to unzip files using VBA in Access. I am retrieving a file location from a table and I need to unzip the files before I move them into another directory. So far I have found out how to call the winzip application, but we do not use winzip in my office so I need...