Hello,
I have a situation where i have need 2 connections (one to Excel and one Access) to create a recordset.
I have no trouble querying these two sources separately. Typically I use a statement such as the following:
...
rsRecordset.Open strSQL, cnExcel, adOpenStatic, adLockReadOnly
...
in...
Thanks James, Reghakr and teknikal.
Other problems have forced me to return (temporarily) to win 95. I'll be sure to refer to your suggestions when i try this again.
Tallman
Hi,
I've updated a computer from win95 to win98 and i notice that the properties of folders don't have the default "sharing" option.
How can i turn this feature back "on" or is it simply not available for win 98.
thanks in advance,
Tallman
Hi DonRH,
(assuming you are working with a form and placing code in that form, also assuming that you are not getting any properties and methods after typing the name of you listbox)
select the listbox and check the "name" property (rt-click: properties). this will rule out typing...
Hi,
I'm using a DBGrid and under the properties for the DBGrid (property pages, Layout tab) I see a check box for Wraptext.
Can someone help me with the correct syntax to set the "wrap text" property to true (at runtime)?
(i've tried DBGrid.Columns(n).WrapText = True - didn't...
This is how i do it DTRNTR:
.caption is the column name on the DBGrid (DBGrid_Display)
With DBGrid_Display
.Columns(0).Caption = "Your Column Name"
.Columns(0).Width = 2000
.Columns(0).Visible = False
End With
Chris (Tallman64)
Hello Programmers,
I need help with a decidedly un-helpful Microsoft error message. My program is created with VB5 Enterprise Edition and uses a DBGrid, a Data contol and a few other standard components.
Most of my installations work fine, but on some machines, i get the following Microsoft...
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.