I guess I was hoping for a "magic bullet", but it looks like either memory or performance has to give.
Based on the sets of data I will be working with, I think I need to lean more towards keeping the memory usage down.
I've been toying around with the idea of using some sort of black list as...
Interesting idea, but the only problem I see with using linked lists (or a hash table) is that I lose the advantage of the small memory footprint of BitArrays.
Hi Everyone!
Does anyone know what the most efficient technique would be for implementing a RemoveAt procedure that functions on a BitArray?
I will be working with BitArrays that have on average around 100,000 indexes and will need to perform a large number of RemoveAt operations.
My end goal...
Hi All!
We have a Windows 2003 server running the File Server service. We've setup several shares and have about 10 Windows 2000 clients connecting to the server. We are setup as a domain and are running DNS.
When a client navigates to a share via the "My Network Places", directory listing...
Hi everybody!
I know how to create ActiveX UserControls and DLL's. But my question is, how do you create an ActiveX UserControl that can be bound to a field in Microsoft Access?
For example, say I create an ActiveX UserControl project in VB 6. I draw a text box on the control, Text1.
What...
Well,
You could do this through VBA by opening a connection to your second db from the first and then using an SQL INSERT INTO statement. I don't have the exact code in front of me, but it is possible...
Good luck!
-Andrew
It's not very elegant, but:
1. Open Database A.
2. Open Table 1.
3. Press Ctrl+A to select the entire table.
4. Press Ctrl+C to copy the entire table
5. Open Database B.
6. Open Table 1 (in Database B).
7. Go to the add new record line at the bottom of the table.
8. Select Edit->Paste Append...
It really depends on what you want to browse for....
Also, I don't think there is a completely code free solution, but I'm sure some people here can give you a "copy and paste" solution depending on what you wish to do...
Good luck!
Andrew
Hi!
I have a database that uses several forms, all of which have their Popup property set to Yes and their Modal property set to No.
I want to be able to detect when a user leaves one form and enters another form. However, when the popup property is set to Yes, the GotFocus and...
I also would be grateful to anyone who can post a solution to this problem. At this point, I would accept a scripting, vba or third-party plugin/application solution!
Thanks!
Andrew
Hi everyone!
I was wondering how in VBA for access you can detect when the user clicks a command button while holding the control key (CTRL). I imagine this will have to be done in the command button's Click event, but how do you detect if the Control key is being held down while this event...
Nevermind - figured it out.
For those who want to know:
In VB goto Tools->References... and make sure the "Microsoft ActiveX Data Objects Libray" is checked. I am using A2K, so I'm not sure if it is different in other versions.
THanks!
Hi,
I am trying to use ADO instead of DAO for recordset operations, but everytime I try and declare an ADO recordset, I receive the message, "User defined data type not defined."
Here is the code:
Dim rst As ADODB.Recordset
Any ideas? Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.