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 derfloh 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. Tazcat

    Access db VERY slow to load using desktop shortcut

    Just a suggestion: Try defragging your hard drive(s). I have seen performance issues with users running databases on their hard drive have problems just like you are describing. In almost every case, once they defragged, time to open improved dramatically, and errors on load reduced. Remember...
  2. Tazcat

    Need help with Secure FTP

    Hi everyone, I've already pulled 1DMF's wonderful code on FTPing files with Access (particularly liked the error handling routines, btw). But my problem is this: my company requires that we use SECURE FTP (SFTP) rathter than plain FTP. I've been searching all over the place, but cannot find any...
  3. Tazcat

    pulling data out of the ODBC connection

    thanks everyone for your feedback. it's begining to look like I am going to need to figure out how to make that API call work... unfortunately, I don't know to do that. [purpleface] So I guess I'm back where I started, unless anyone has some advice where I might go to teach myself API in a...
  4. Tazcat

    pulling data out of the ODBC connection

    thanks for the genomon, but I don't know enough about api calls to make use of this. I was hoping for an ADO solution to the problem, if you've any thoughts along that line? Melanie ~Tazcat2k~
  5. Tazcat

    pulling data out of the ODBC connection

    I've an Access frontend connected to a SQL backend. The SQL server prompts the user for their ID/password at log in. I need to write a function to capture the UID out of the ODBC connection string, and store it to a variable. For the life of me I can't figure out how to even get started on this...
  6. Tazcat

    DLookUp calculated control problem ONLY on other pcs

    Putting this one out there in the hopes someone can help. I've been through forums and faqs, msdn and microsoft support, all to no avail. Bare with me as I explain what's up. I am developing this db in Access 2003, but with default file format set to 2000. My users (mostly) are on 2000. This...
  7. Tazcat

    error with external database

    That was it!!! It even had the code to close the window if found. Thank you so much, Remou!!
  8. Tazcat

    error with external database

    Thanks Remou, those are all great threads. Unfortunately, they don't cover what I need. I need something that a) rather than working on a timer, works on command and b) checks to see if the active user currently has the other db open on the same system. It doesn't throw an error if...
  9. Tazcat

    error with external database

    Hi, I have a function from a command button, that opens another database from within my current db, runs a module there, and then closes it. The function itself works fine. Here's the problem: if the active user already has an instance of the reference db open, the function throws an error, and...
  10. Tazcat

    Append Query help

    BLESS YOU! You saved my bacon again. I can't believe I missed something that obvious... Stars for you! Melanie
  11. Tazcat

    Append Query help

    ...the SQL looked like this: INSERT INTO tbl_RecallArchive ( [Report Date], [Item Type], [Age Category], [#Items], [Current Value] ) Select * From (SELECT Date() AS [Report Date], stbl_tmpArchv.StockBond, tbl_tmpArchv.[Age Category], tbl_tmpArchv.[#Items], tbl_tmpArchv.[Current Shares]...
  12. Tazcat

    PERFORMANCE: make table query VS create table statment

    ...within 4 age categories. The SQL is thus: SELECT DISTINCTROW qry_FldRclls.StockBond, Mid([AgeCategory],3,20) AS [Age Category], Count(*) AS [#Items], Sum(qry_FldRclls.CurrentShareBal) AS [Current Shares], Sum(([CurrentShareBal]*[price]/IIf([sectype]="4",1,100))) AS [Current...
  13. Tazcat

    PERFORMANCE: make table query VS create table statment

    Thanks rac2. Perhaps I should have been a bit more specific regarding what I need to know. I should have said that I am referring to how to execute this from my code, not how to structure the query itself. Therefore, from a code perspective, which is the better method, performance wise? I will...
  14. Tazcat

    PERFORMANCE: make table query VS create table statment

    I have a situation where I need to update an archive table several times through out the day. To do this, I need to generate some temp tables to populate aggregate data to the archive. Basically, the user enters a bunch of new records, or alternatively, closes a bunch of existing records as a...
  15. Tazcat

    Append Query help

    Golom, can't thank you enough for the help! Worked like a charm. I had to add the additional columns to the table with blank values, but it still worked perfectly! Melanie
  16. Tazcat

    Append Query help

    Nice idea, thanks! I'll give it a try in the morning and let you know how it works. Melanie
  17. Tazcat

    Append Query help

    I have an append query that I use to create an archive table. The SQL is below: INSERT INTO tbl_RecallArchive ( [Report Date], [Item Type], [Age Category], [#Items], [Current Value] ) SELECT Date() AS [Report Date], smry_RecallsAging.[Item Type], smry_RecallsAging.[Age Category]...
  18. Tazcat

    modifying properties of controls 'wholesale'

    bless you both... solved my problem!
  19. Tazcat

    modifying properties of controls 'wholesale'

    hey there. not to beat a dead horse, but this thread is right on target with an issue I am having... I've read through this thread and tried several ways of getting this function to run, but my problem is I am playing with one property not mentioned above. I would appreciate any feedback at all...
  20. Tazcat

    Descriptions

    I modified the procedure, but now I'm getting an error "item not found in this collection"? Set con = DBa.Containers("Tables") 'read selected container objects and add to table For Each doc In con.Documents 'check if its a table Set tbl = DBa.TableDefs(doc.Name) On Error Resume...

Part and Inventory Search

Back
Top