Recent content by perfectchaoss

Whoops please disregard this post, the reason was that the order by criteria, was the same value for 74% of the items. sorry wasn't thinking.

SELECT TOP 5 PERCENT dbo_FormReportSS.UPC, dbo_FormReportSS.ItemDesc, dbo_FormReportSS.WhseNum, dbo_FormReportSS.PriceOnly, dbo_FormReportSS.CaseCost, dbo_FormReportSS.UnitsCase, dbo_FormReportSS.UnitCost, dbo_FormReportSS.[GM%], Sum(dbo_FormReportSS.LstWght) AS SumOfLstWght...

Success!!! I am going to begin using veritas to backup onto tape after my backup on the hard drive (it only takes 1.5 hours. I still have no idea why SQL server takes so long.

Alright!!! went on lunch and came back and it is finished. Took less than an hour, now too backup that up on my tape... thanks a lot guys, Joe

OK i cancelled my tape drive backup and am backing up on the Hard drive. I will keep you posted. Joe

Wow thanks for all the quick responce. I am backing up strait to the Local backup tape drive through SQL server. The server is fairly new (a little over a year)it is a dell 4600 with duel 2.4Ghz/512k Xeon processors. Im not sure what model the backup drive is, i will look into this further...

Hi I am Running SQL Server 2000 on Windows 2000. Backup started at 6:00PM and is still going at 10:00AM. My old backup was part of a "Database Maintenence plan" so i expected it to take some time. The new database maintenence plan is only a a complete backup to the tape drive...

check this post out, it sounds similar to a problem i was having. thread183-600595

Ken, Thanks for the quick reply, it gave me the message sub or function not defined. I may not have been clear enough in my original post. The Stored procedure is on SQL enterprise manager and the access database is on a client PC. Joe

Hi, I am trying to execute a stored procedure in the onclick event of a command button. I already have the stored procedure working, i just need to be able to execute it. Here is what i have so far.. RunDTS is the name of my stored procedure. Private Sub ImportNewItems_Click()...

OK nevermind, I guess that the Microsoft DTSPackage Object Library is only availible on computers that have SQL server installed.

I am trying to do the same thing (run a DTS package from VBA) It looks like the code above will work and I also found some similar code on the Microsoft website. However I can not find the "Microsoft DTSPackage Object Library" to reference. I tried going to tools then References, but...

Is there a way to program a command button to print a report with. 1. 4 pages per sheet 2. A select amount of pages (user defined through a input box or textbox) I have tried to set the print settings on the report and it seems that if i use a button they get reset. Thanks in advance, JF

If you are talking about a text box then... me.text1 = ""

Whoops sorry I messed up that link here is the right one: thread702-563930