Search results

That works perfectly. Thank you so much. I ran it on my computer and it ran about 8 minutes faster than the way I had it originally --and I have a good network connection. I'm sure it will save my co-worker even more time.

I would like to try the suggestion you gave about copying one file at a time and unzipping it. Unfortunately, I'm not real sure how to accomplish this. I feel very comfortable with writing VBA that deals with items within the database. However, when it comes to getting the database to run...

I have a question for you. I think I know the answer to the question, but my co-workers have asked me to ask the "experts" I know on the internet. With the assistance of several people on this forum, I created a database that would go out on a network drive and unzip over 2,000 files to a...

I have one more quick question. Is there a way to view this file after it has been created? My co-workers would like to have the query open on their screens after it is created. I tried commenting out the Close #1 line, but I still don't see the query when I do that. It says its open, but I...

That works perfectly. Thank you so much. I really appreciate it.

Is there a way to program a spreadsheet to copy a cell to a Text file and then save it with the extension .qry? I have a formula set up to create the text for a query. I currently have to take that cell, copy it to NotePad, then save it with the extension.qry. After that, I have programming...

Thank you very much for checking into this for me. Unfortunately, it is still doing the same thing. It opens the Browse dialog box, but it won't let me select more than one file at a time. Could it have anything to do with the fact that the folder originated on a SharePoint site? I tried...

Thank you :) Sorry, I forgot about the password.

Here is a copy of the database I am having trouble with. This is actually a different database than what was posted previously, but it is the same module. Thank you very much for your help. I really appreciate it.

I wasn't sure if it would help or not, but I am attaching snap shots of how the Windows Explorer looks when open from the database and when open from My Computer. I don't know if the difference in appearance is why I can't select multiple files at once or not.

I don't get an error message, it just doesn't let me select multiple files. Yes, I have the Report_Data folder on my C drive.

Could there possibly be a reference or something I am missing? My query looks like this: EXEC SIS_CALL_P When I try to run it, I get a message stating "ODBC--call failed. [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "EXEC" was found following "BEGIN-OF-STATEMENT". Expected...

I just got Windows 7 installed on my computer and now I am having a little difficulty with the File Operations module. It all seems to work fine with the exception of selecting multiple files at once. For some reason, now it will only allow me to select one file at a time. I haven't changed...

I created a Pass Through Query and typed EXEC and my procedure name (my procedure does not have any parameters). Unfortunately, when I try to run it I am getting an "Expected End of Statement" error. I tried adding a semicolon to the end of it, but still get the same message. What am I doing...

I have created several "pass through" queries in the last several years. However, I have just had someone ask me if it is possible to run an SQL Procedure as a Pass Through Query. The procedure they want to run is set up to run a query, save the results to a server, and then run another query...

I have a database whose back end is on an SQL Server. I have several buttons set up on the database to update the tables. My problem occurs when the database seems to want the connection refreshed for every table it is trying to update. Is there a way to refresh an ODBC connection through...

That was very helpful. Thank you very much.

If I could, I think I would like to have a table that houses the dates. That is the way they are doing it in the database they have now. One table shows all the quarterly, monthly, bi-weekly, and yearly dates. Then another table, storing the data on the machines, references this dates table...

I have a database that I am trying to create that will track maintenance required for various machines on the factory floor. Some machines need to be maintained monthly, some quarterly, some semi-yearly, some yearly, and some bi-weekly. I would like to set the database to automatically...

I can't believe it was something that simple. Thank you so much for your help.