Search results for query: *

I know that For Each Node In TreeView1.Nodes Node.Expanded = True Next will expand all nodes but I just want to expand a selected node. Any Ideas?

I do know how to do this with DAO, and I don't believe I can do this with ADO. Is there another way?

How can I prevent multiple instances of a DB from opening?

Would it be worth the effort to recode all DAO to ADO syntax(for databases that will be migrated for many more access generations)? Any performance benefits? When will DAO be dead?

How do you get a parameter value to pass through to a column value? The parameter is set though a DTS global variable for example (simplified example) Select ? AS TestDate, a.store_number, a.trans_number From transaction_master a Where a.fill_Date > ? I get a Syntax error or...

I need to extract the last 90 days worth of data from a DB2 database. I have ODBC drivers setup already and I can link in and get the data with a select query but it takes a long time. I was hoping a Access 2k Pass-Through query would speed it up, but I'm having problems with the SQL. I can...

I need to extract the last 90 days worth of data from a DB2 database. I have ODBC drivers setup already and I can link in and get the data with a select query but it takes a long time. I was hoping a Pass-Through query would speed it up, but I'm having problems with the SQL. I can get the...

I first posted this in the VBA Coding forum thread705-157603

How can I copy the image in an image control to a table.

I'm looking for a function that returns the colorindex of a cell. Something like =ReturnColor(A1) if "A1" is red then return 3

Does anyone know of any good third party Database Documenters. The standard Access Documenter is too wasteful.

What causes the MsysObjects.DateUpdate field to update? Has anyone come across this not updating even when updates are made to an object?

Is this possible, I know I can Import Toolbars from the Get External Data/Import Menu but I would really like to do this from code...

Let's say we have Form1!Form!Text1 I want to be able to call the Text1_AfterUpdate from Form2!Form!Command1. What would be the way to do this?

How could I Terminate a dos (or any for that matter) application using vb?

This is what I need to do 1. check for Directory (already done) 2. if it's not there create it (already done) 3. check to see if it's shared to "Everyone" 4. if it's not share it. This is on an NT4 box Most users are logged on as administator but some are not.

Is there a way I can programmatically compile all of my queries.

Are there any problems the conversion may cause. And what checks should be made before conversion?

How do I set the column width in a listview control?

How can I determine at what height(twips, inches, etc...) the cursor is at?