Recent content by Sam8932

Yep we tried that. For now we've created a work around where we bypass creating the excel file. It works fine this way but it's still confusing as to what's going on. One thing I should have mentioned in the beginning is that this app ran fine with the same scheduled task until the server was...

lameid, thank you for the responses. Yes the bat file works. No drive mappings are being used. All files are put on the same directory that the DB resides on.

No I am not logged in when it runs. The account I have the scheduled task set up under has administrative privileges.

I have a scheduled task set up to run a .bat file that starts a macro in an Access DB. The DB pulls down files from an SFTP server and then loads them to a table. I then export them to an excel file and save that file to a .csv file to be loaded to another SFTP server. When I run the .bat file...

Well I knew I needed to use the shell command jackass. What I wasn't sure of was how exactly to do it as far as passing in command line parameter. And you didn't really help much with that did you. I didn't realize it was SO important to you that you get credit for helping me.

I figured it out. I've created a self extracting zip file (which is an .exe file) code: Dim strFilePath As String Dim strZipFileLocation As String Dim strUnzipLocation As String Dim strZipFile As String strFilePath = GetDBPath strZipFileLocation =...

Thanks for the reply fumei. I am using a Shell command to zip the files. If the users had Winzip installed on their computers there would be no problem. What I need to do is extract the files to different locations on the users PC and I'm not sure how to do that. As far as passing in...

I used Winzip to zip up files that we need to send to many users in different locations. The file created is an .exe file. These users do not have Winzip installed on their computers. Is there a way to run this executable winzip file on the users machine with VBA code? Hopefully I've given...

I graduated last spring and I've only been programming in VB for a couple of months now. I had a class in college but never worked with grids this extensively. I don't understand what you mean when you say "capture the key". I want to be able to allow the user to select multiple...

Anyone?

I've been off of this project, but I'm back on it now. I'm still hoping someone can tell me how to delete multiple rows with a datagrid. I've gotten this to work with the flexgrid, but this application is so big and complex that when I change the datagrid to a flexgrid it causes too many...

Thank you CajunCenturion. That worked great. Now I need to be able to allow the user to change the values in the text box and have those values change in the flexgrid(which I've been able to do) and have the new values be saved to the database(this is what I can't figure out). The values...

Thanks Cajun.

I could really use some help with this one. I would appreciate any advice I can get. Thank you. Sam

I should maybe explain better what I'm trying to do here. I have 5 text boxes and a flexgrid on my form. When the user selects a row on the flexgrid, I want the values in that row to show up in my text boxes. I hope this is enough info. Thanks, Sam