Search results for query: *

Thanks, all. RPG

Hi, Is it possible to get the line number of the module where an error occurs? I'm working on an e-mail error routine to keep me posted of things like date, time, user, etc. Does anybody know a good reference for making useful error trapping reports? I'd appreciate it. RPG

Thanks all. My MIS is an ace. Totally broke the mold, but we're migrating servers, so sometimes things are missed. Anyway, jebenson's suggestion helped. Turns out the home office switched servers, too, and for some reason our username was left off. I really appreciate your help. RPG

Hi, I have an FTP program that's suddenly not working. My MIS says that everything is fine, but I suspect something was changed that he's overlooked. We still receive FTP data from the parent company, but when I try to connect I get a return value of "0" which throws the program into an error...

Hi, I make a backup of the "live" database to test new VB programs on, but for some reason whenever I make the test DB, it doesn't transfer the primary keys and ID properties for any of the tables. What am I missing? Thanks, RPG

Hi, I found this neat set of code that let me read an HTML file as a collection of recordsets. I was wondering if anybody knew how to read an MS Word document the same way. I need to dump some schedule data from MS Word into SQL. It's tab delimited. Appreciate the help. RPG

Hi, We just switched over from the old DBS to a new one. Using VB6, we changed all the addresses accordingly. All of the computers can now connect to the new DB except for one. The one lone computer, the admin asst's, she can't connect. Any Ideas? Thanks, RPG

Hi, We just switched over from the old DBS to a new one. Using VB6, we changed all the addresses accordingly. Everything seems to be going fine except for one lone computer, the admin asst's. She can't connect. Any Ideas? Thanks, RPG

FYI to anybody who should have a similar problem in the future: the firewall client wasn't configured correctly on the secondary machine.

Hi All, I have an FTP transfer program that works fine on my primary computer, but doesn't work on the secondary. I keep getting an "Err: 6" message. Is there something I need to change or have MIS change? Thanks for the suggestions, RPG

Hi, I figured out how to copy databases, but for some reason the primary key definitions aren't being transferred. Anyone know how to do that easily? I need to make annual archives. PlantData exports to PlantData2001 PlantData2002 PlantData2003 Etc. Thanks, RPG

Hi, Not sure if this is the right forum, but I need to know how to basically duplicate and export databases and sort them by year. So I want to take "PlantData" and create PlantData2001 = all 2001 records PlantData2002 = all 2002 records PlantData2003 = all 2003 records I figured out how to...