Search results for query: *

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

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

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

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

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?

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

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

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

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

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