Search results for query: *

Are there any tools out there that I can use to install all the requisite .dll's used in an .mdb file that I created. Right now I have an app with a coupld of .dll's that I manually register on the user's computer ... It hasn't been much of a problem as the number of users has been quite small...

I found the answer ... looking at some related code. you have to use: Set dbs = OpenDatabase(pName)

Thanks. However, I'm getting a type mismatch error. I have the path/name of the file set to a string variable (pName) and therefore rewrote Set dbs = "C:\db2.mdb" to Set dbs = pName and this is giving me the error.

I'm using Access 2000. I'm trying to set a connection to another .mdb file and programmatically set links to all tables in that file. If the second .mdb file is "d2.mdb" and located in "C:\" then how do I access the TableDefs collection of this database?

Thanks again!

do you mean that if i delete something in position 5 of a collection then whatever is in position 6 moves to position 5 but the counter moves to position 6 which now has a different value?

forgot to say thanks!

It worked! but why?

I created the following code to delete all linked tables in my database (Access 200): -------------------------------------------------------- Dim tbl As TableDef Dim dbs As Database Set dbs = CurrentDb For Each tbl In dbs.TableDefs If Len(tbl.Connect) > 0 Then ' Is a linked...

I've been taking classes at Stevens Institute of Technology (webcampus.stevens.edu for the online grad level courses). I've taken both on and off line courses (math and comp sci). The online school was rated the best by Forbes. prior to this I spent 1 1/2 years part time working on a diploma...

AnanthaP, thanks for the feedback. Already been to India on holiday. In some cases business is outside the power of pols to control, but they can still do a lot to mess it up. on a somewhat related note, france has declared the 35-hour work week to be a disaster...

Hi Dimandja, I haven't heard anything specific to the effects on outsourcing, just the general effects on the stock market and the overall unease (not sure if this is the right word) of investors' reponse to the results.

If you haven't been paying attention, you may have missed the fact that there have been some major developments in India during the past few days .... 1. Indians voted the current PM out of office; while a new gov't has not yet been formed, it will most likely be headed by the leftward leaning...

Is there a way to programmatically control how an Access 2000 app starts up and is there an event for it when it shuts down?

The app is for internal use. The problem isn't really the distribution, but more a matter of there being a lot of computations going on for which data structures would make it easier to do ... I've been doing some research (I googled "Why Use Data Structures") and have the following so far: 1...

I posted this elsewhere but was advised this might be a better forum for my question. I'm developing an App in MS Access 2000 using a lot of VBA. There is a lot of data manipulation and calculations going on and I feel that if used data structures such as Linked Lists, Priority Queues, Binary...

You are welcome. I have one question for all of you: Where do I learn those CEO skills? ;-)

data mining is more about developing a set of probabilities to hopefully increase the likelyhood of a particular set of actions. for example, if 70% of males age 25-35 buy beer A and the customer is a male age 25-35 then there is a 70% chance that he will buy beer A. Therefore, if you were...

all voting systems have problems, even paper based system (and not just because of dead voters). all voters have an id, their SSN (this also prevents illegals from voting). After the vote a statistically valid random sampling could be done to verify that the votes were valid (and catch dead...

I've taken a few grad classes in comp sci, primarily in alogorithms / design logic. Plan to take more and may even end up with a degree. Although my work experience is mostly vba with Access and Excel, and in school we use c++, I feel that the theory has helped me to become a better...