Search results for query: *

We've started using SQL analysis services to manage a result set of over 1.5 million records, and it works very fast. The trick for us was putting the data in a cube, and basing the pivot table on this data. We've been using MS Excel, and I'm not sure if an Access pivot form can have a...

This should do it... SELECT i.id, i.program_id, i.sku, c.product, c.upc, i.controlled_funds, i.approved, i.buyin_expected, i.buyin_actual, i.item_cost, e.customer_num, Sum(e.qty_ordered) As Qty FROM (items_on_programs i LEFT JOIN excsales e ON i.sku = e.sku) INNER JOIN catalog c ON I.sku=c.sku...

Making the recordset type of the query 'Snapshot' should prevent any changes being made to the data.

An unusual solution I found while looking thru CodeHounds.com was arrived at by Dan Jinks and Paul Mazaika. They found that by setting it up as follows, no hidden instance of excel is created: Dim objXLApp As Excel.Application Dim objXLBook As Excel.Workbook Dim objResultsSheet As Object...

I wanted to record this tip for histories sake. It's an issue I struggled with for years, but finally happened upon a discussion between Paul Mazaika and Dan Jinks occurring late September, 2001, at Codehound.com, which answered the issue I'd been experiencing all along. Basically, I'm...

We've made a simple Access 2000 help desk database on a shared drive: user's call, a form is filled in, and tech's enter the details into the call-tracking form. What's happening is on occasion the calls the techs enter into the database disappear, even after printing the call sheet. The...

I've seen a lot of folks asking about the error 429 occurring while trying to create the first instance of an ActiveX component, but I am receiving this error during the processing of specific workbooks created through Excel automation with VB6, while many others, using the same code, work fine...

Thank you for your reply. I wound up looking into the Header switch, which was set to XLGuess because that's how the macro recorded. After checking the docs, it turns out the behavior was reasonable, but Excel's guess was wrong, it thought the first line was a header line. Problem solved by...

I'm encountering a problem that I thought I never would. I've used VB6 to create and make adjustments to Excel 2000 workbooks for budgetting purposes. At this point, I've been asked to sort items on the Summary sheet to a specific order. The routine I use to do this works for some sections...

I'm finding a remaining open instance of excel in my app, but it is created after I try and copy an excel worksheet. After many changes, I'm still lost on what the solution is to stop the new instance of excel from opening. Code: Sub ... xlwb.Worksheets("DETAIL").Activate Set...

Oh, I tried this sub, and it kept failing!! Ya know what was wrong with my VB app??? I had set Break on All Errors in the options, and, (duh!) it broke!, and the app crapped out yet again when it reached the sub!!.. Thank you all for your code and assistance, trying to find the answer to...

Thank you for your response, Dreamboat. There is no VBA or macros occurring in the background, nor macro warnings on this particular file, tho others I onpen and make, have macro warnings which are displayed. I was able to easily re-create the issue with a different file, making me wonder if...

Hi All, I'm trying to figure out why, after saving a document with a "Normal" view in Word 2000, it's not possible to change this behavior. Each time I open the document after that point, it always opens up in Normal view, even after saving it repeatedly in a different view. What...

If the tables aren't too large, perhaps importing them into Access, making temp tables of them and assigning index, and running the reports from there? I think it might take less time to perform and could be done with modules or macros. HTH, Drew

Doesn't it just figure... The data turns out to have an occasional double quote in the hundred thousand records...Just my luck.

Lol, answered my own question Chr(34) or a double set of quotation marks will do the trick...can I star myself for my answer? jk

Thank you, Mark, your explanation makes a lot of sense. In constructing the SQL string, would I use something like : strCommand = strCommand & " VALUES (" & vbQuote & new_third_Rec.status & vbQuote strCommand = strCommand & ", " & vbQuote & new_third_Rec.bldgid & vbQuote...

Hi All, I'm trying to perform a VB6 Insert to an Access database of text data, but have run up against a snag. Some of the data has embedded commas, and SQL is getting consufed by them. The executed SQL is like this: INSERT INTO tbl_TCLEASES (status, bldgid, leasid, occpname, contname...

As a secodnary follow-up, it turns out one of the things which was a problem was her network user.dat file got corrupted somehow. Deleting the file made that problem disappear...Ford knows why... Drew

Thank you for your thoughts on this problem. Today I learned that the problem was a rights issue in the Netware we are using, and she only had Write permissions on the directory. When she was given all rights, the problem disappeared.