Search results

Thanks anyways for checking and for sharing the code.

Thanks again. I may be doing something wrong. I get the error screen attached. This is the code modofied with actual folders: Dim intLoop as Integer Dim strFolderPathNames (1 to 3) as String Dim strAnswer as string intLoop(1) = "\\tbstp\R2W\Admin\Watch" intLoop(2) = "\\tbstp\R2W\Admin\Work"...

Thanks. I'll ive this a try. If you have some free time, could you show me the example of the other scenario where the file names are not sequentially numbered like above? I really appretiate you taking the time to reply. Thanks!

I appretiate the explanation, but could you provide me with an example of how to call tha function many times? Also, your examples of the results is exactly what I'm looking for. I may pull some more folders, but I just want to see which ones had files inside of them.

Hi guys, I have the code below that a friend gave me, but I need to change it to check multiple folders. Can you please provide me with some help? I need to do something like an elseif so it can check folders: "\\tbstp\R2W\Admin\Watch" "\\tbstp\R2W\Admin\Watch2" "\\tbstp\R2W\Admin\Watch3"...

Thanks guys. I agree with what you have said here and I guess there isn't much we can do about it. Have a great one.

Tried that. Doesn't work. I get "Type mismatch: 'exists'" error 800A000D This is the code now: dim objFSO, Dir, f1, f, fc, strSourceFolder, strDestFolder, strlOOKFile, strlOOKFolder if exists("\\tbstpabc\D\ftp1\") then 'Constants Const OverwriteExisting = TRUE 'Global variables...

Hey guys, I have this piece of code which works fine to pull the files from the remote server if the server is available. However, this server is taken down several times a week for back up and maintenance. My problem is that when this script runs and the server is down, I just get a "Path not...

Thanks guys. I found the answer. I got it to work by doing this: dim objFSO, f1, f, fc, strSourceFolder, strDestFolder, strlOOKFile, strlOOKFolder 'Constants Const OverwriteExisting = TRUE 'Global variables strSourceFolder = "\\tbstpgw3\D\ftp1\*.FLG" strlOOKFolder = "\\tbstpgw3\D\ftp1\"...

Tried it, but for some reason it does not work. Maybe I'm not incorporating it right. This is the code I have. dim objFSO, strSourceFolder, strDestFolder 'Constants Const OverwriteExisting = TRUE Set objFSO = CreateObject("Scripting.FileSystemObject") 'Global variables Public Function...

He guys, I have a quick question regarding a code I wrote. I need to copy some files from one server to another every day, but some times they script starts running before the files are available and that is causing the script to fail. Could someone help me troubleshoot this code to enable it...

Thank you for your help. Using your code and some other online sources, I found the right combination. For those using Sybase IQ, this is what the code looks like. Select column_name From sys.systable inner join sys.syscolumn on...

Wow, that was quick. Unfortunatelly, it does not work. I tried runnign it and it didn't work. I get the following error. "Error: Syntax error or access violation (State:42000, Native Code: 0)" If it helps. I'm running on Sybase IQ. Thanks for your help so far.

Hi team, I'm looking to get a code that I can use to list the fields inside a table. I am in the process of converting all our tables to views so that I can better maintain it for the users and give it more functionality without the users having to link to many tables. The problem is that some...

I think I got it. Just in case anyone else is asking themselves how this would work in Crystal. This is what you need to use inside your select editor. {your field} in WeekToDateFromSun This will give you the current weeks data. There are a whole bunch of formulas in ther to pull various date...

Hey guys, I have a weird report that is not working in Crystal. Now this runs fine in straight SQL, but for some reason I created a command in Crystal and it gives me all kinds of errors. Is there any way of doing this in Crystal? Even if it is in a different way. select a.ID_, a.Person_...

Hey guys! Thank you for your suggestion, but unfortunately I downloaded the software and tried all the steps given in the page and when it finished scanning it did not find the hidden partition. what could they have done in Dell to hide this so good and why? I decided to even pull out the hard...

Hey guys, I have a very interesting question that I hope you can answer for me. I have a Dell XPS 410 with a 320 GB hard drive and back when I got it, I decided to format the computer and remove Vista since I hate the OS. The issue is that I was going to format once again to install a newer...

Shouldn't you be able to use dateadd(yy,-1,getdate()) from the command section? Let me know if that works.

Hi all, I am looking for a way to build a form like the attached into a website that I can share with users without the need of them installing Access on their PCs. I have provided a snap shot of the form as well as a sample data base. The form will allow the user to add their tech number one...