Search results for query: *

Nevermind... I just figured out that one of our admin guys changed the ip address of the data destination computer. What's strange is that in the connection properties, I specified the connection as \\pcname\directory ... and like I said above, I'd execute it manually and it'd work fine. But...

I created a dts package about 2 weeks ago that takes data from a table and puts it into an excel spreadsheet. Then I scheduled it to run as a job every 15 minutes. Everything has been running fine since then until yesterday afternoon. Now, I can go in and manually execute the package just...

I am new to crystal reports. I have to create an invoice report for someone and I've managed to create the basic guts of it with subreports. However, I need to feed into the sql query of these subreports certain parameters so it knows which records to grab. Also, when displaying some of the...

Okay, I've got to create an invoice for a customer and someone on a message board told me that crystal reports is the best way to do this. So, I've tried playing around with it a bit, but from what I see, it looks like I have to create one big query that spits out the results on the form...

Ah, you're right. But unfortunately, that was not the problem. Thanks for pointing that out though. However, I'm still getting the same exception occurred error.

I have the following code... sqlTmp = "Select EducationComment, RelocationComment, Resume, Comments FROM dbo.JobSeeker JS WHERE (Downloaded = 0) AND (AgencyID = '" & session("agencyID") & "') AND (JobSeekerID = " & userID & ")" set tmpRS =...

I haven't worked much with VBA, mainly just VB and COM and I need to assign the text in a word doc to a variable. Does anyone know how I can do it without saving the doc as a text file, opening it with the file system object and readall the text into a variable. That seems like more work than...

I've got about 15 different tables in sql server 2000. I have to convert these tables to fox pro tables. I was told to check out dts, which I have, but it just doesn't seem like it will do what we need it to do. The problem is that we need to have a program that runs through a table of our...

Well, I'm having a tough time learning finding DTS tutorials that are aimed at pure beginners. And also, I do not have existing fox pro tables. I need DTS to create the tables for me. Can you offer any links to sites with tutorials for beginners about DTS and this subject matter? Thank you.

I have to take data from a sql server table and create a fox pro table out of that data and then zip up that table for download. Does anyone know how to do something like this? Thanks.