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

    Can I use VB to create extended stored procedures?

    I want to create VB functions, make a DLL, and access the functions in T-SQL. Can I? Or must I use C++ (which I do not have).
  2. MikeDutcher

    how to turn off the optimizer?

    My query passes data to VBA through user-defined functions. I need to control the order that the columns are executed. I want them to execute from left to right. Based on the quote below, I suspect the Jet optimizer is changing my column order execution and thus my VBA public variables are...
  3. MikeDutcher

    Optimization

    My Access database links to ~43,000 record table on SQL SERVER. Extensive use of VBA, small tables read into arrays, complex array calculations (actuarial), public variables (retain info as query moves in and out of VBA), scores of functions. I'm optimizing the VBA (replacing IIFs with IF THEN...
  4. MikeDutcher

    large SQL table linked to ACCESS

    I am an actuary. My computer skills are concentrated in application development, bare bones in setting up systems. I have a million record ACCESS 2000 table. (I have many multi-million record tables coming down the road.) Others have said ACCESS unstable for large tables, get SQL SERVER. Now...
  5. MikeDutcher

    How to make linked tables READ-ONLY?

    I want to put common tables on a network database and have users link to them in their personal databases. I don't want the users to be able to change the common tables from their personal databases. Can this be done and if so how?
  6. MikeDutcher

    VB Input/Output

    I am learning VB 6.0. I have a file with 1 million, 600 byte records. The 600 bytes must be parsed into roughly 100 text and numeric fields. I am processing it as follows: Open "D:\FILE.TXT" For Input As #1 Do While Not EOF(1) cnt& = cnt& + 1 Line Input #1, in1$...
  7. MikeDutcher

    Should VB be my pc tool?

    I am an actuary for a state agency. Our database is about a million records. Until now, all processing has been done on a mainframe. The pc was too slow, the disk space too small, and the mainframe had the advantage of being there first. Now I have a pc with 512 MB RAM, 40 GB drive, 1+ GHz...
  8. MikeDutcher

    creating DLLs for Office

    I am an actuary, competent in app development but not by formal training. 15 years on the mainframe, pcs now strong enough to use instead. I want to create functions that I can use from Excel or Access. I have Visual Basic 6.0 and Office 2000. Here's how far I've gotten. Suppose the function...
  9. MikeDutcher

    Joining Tables using more than 1 field

    I have 3 tables: Table 1 Employer Code System Code Data Table 2 Employer Code Employer Name Table 3 Employer Code System Code County Code For all records on Table 1, I want the employer name from table 2 (so I Join Employer Codes) and the county code from table 3 (where I want to join on...
  10. MikeDutcher

    integrating Excel VBA functions in Access

    I have an Excel workbook in which I have written several VBA functions, such as, AnnuityCertain(Term,Interest) which receives a term (e.g. 5 years) and an interest rate (e.g.7%) and returns the annuity certain (e.g. 4.39). I want to be able to use this function from an Access database. I could...

Part and Inventory Search

Back
Top