Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DreewToo

    Pivot form - 200, 000 rec's - faster?

    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...
  2. DreewToo

    help, need to add data from another table to this query

    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...
  3. DreewToo

    Restricting query from edit

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

    Aughhh! Opening then Closing Excel in App - Excel remains in memory

    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...
  5. DreewToo

    OLE Automation Error using Excel 2000 and VB6

    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...
  6. DreewToo

    Disappearing records

    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...
  7. DreewToo

    Error 429 while creating specific excel 2000 workbooks

    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...
  8. DreewToo

    Sorting difficulties

    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...
  9. DreewToo

    Sorting difficulties

    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...
  10. DreewToo

    Aughhh! Opening then Closing Excel in App - Excel remains in memory

    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...
  11. DreewToo

    telling if MS Access is running

    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...
  12. DreewToo

    Default view bug?

    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...
  13. DreewToo

    Default view bug?

    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...
  14. DreewToo

    Using Multiple Fields to Create Unique Key

    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
  15. DreewToo

    Trouble with commas and quotes in a SQL Insert statement

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

    Trouble with commas and quotes in a SQL Insert statement

    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
  17. DreewToo

    Trouble with commas and quotes in a SQL Insert statement

    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...
  18. DreewToo

    Trouble with commas and quotes in a SQL Insert statement

    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...
  19. DreewToo

    Help! MDB 97 App. locking when a specific user logs on

    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
  20. DreewToo

    Help! MDB 97 App. locking when a specific user logs on

    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.

Part and Inventory Search

Back
Top