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.
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...
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...
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
Hello,
I was using a datagrid and had my text boxes bound to it. I switched to a flexgrid to allow the user to delete multiple selections. How can I(if I can) bind my text boxes to the flexgrid? Here is the code I was using for the datagrid.
'Bind the text boxes to the data provider
For...
Thanks to all of you. You all have been very helpful. I got the FlexGrid to work. But CCLINT now has me interested in seeing if I can do it with a DataGrid. CCLINT can you you give me more info/code on how to do this? I'm not familiar with this event. Thanks again.
Sam
Thanks johnwm. I'm able to select multiple records and delete them from the Hierarchical FlexGrid by using MSHFlexGrid1.RemoveItem i, but I need to also delete the records from the database. I'm not sure how to do this. Any suggestions? Thank you.
Sam
Thanks guys. I probably should have put this in my first post. To alleviate the potential for locking errors that occur from adding records and updating after each record is written, I pass an array by reference to a sub that adds each element using the .UpdateBatch method. How could I...
How can I make a progress bar to keep track of data being updated to a database? Can I put it on the form or would it be better to use a splash screen in some way? Any help on this would be greatly appreciated.
Thank you,
Sam
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.