VB Forum / Database Access / August 2004

Can anyone help me?. After I install Visual Studio SP5 I get following error
message, when I try to use data control. I have Win2000, DAO 2.8.
jouni.kauppinenNOSPAM@kolumbus.fi
(remove NOSPAM from email-address)

I have a data report I want to use from Access that will be dispayed and printed when a user of my vb application needs to. I have the Access report setup to a query. This query's criteria is set to this "Like[]" which prompts me to enter a Customer# and then displays the right ...

I need to know what kind of field is in a recordset.
I dynamically load the fields in a recordset and populate a listview.
However if the field is a boolean True and False then I would like
not to see True or False in the listview but Yes or No.

I m creating app using vb and A2K.
I m  using dao3.6 reference for it .
app will run on different access db like A97,A2k,A2003.
Does Dao3.6 is supported by All these access db ?

Dears
I tried the following code to encrypt a string and then store at dBase file
through VB6 DataEnvironment, but dBase file encrypts it further before
storing the record therefore when I retrieve the data from dBase after

If I want to search for a substring within a field in SQL I use Like % for
Access I use Like * what do I do with Foxpro?
   Thanks for your help!!!

Hi all...
Please help me, I just want to know,
Is It a must that if we want to insert new record, we must rs.open and
select the record first?

I have a VB6 app which gathers a custom property value from a local MS
Access 2000 file. It compares the custom property value with the same
custom property in a master MS Access 2000 file on a network. Until
Access XP came along, this worked fine with those PC's running Access

Can I change the code come from using ADODC Data Control to
Dataenvironment so that it helps me to do the same work?
My original code is like below:(which sort the student names from a
class and list them in datacombo2 after a class in datacombo1 is

I have a database I have no control over I can only read from it. I am
trying to do a query there is a field that is text but had dates in it.
(date format is 00/00/0000) I would like to use a where statement or sort by
this field but the results are wrong. Is there a way to convert ...

 I am using VB 6, ADO 2.6 SP2, MS Access XP on Windows 2000.
 I am able to connect to password protected mdb using ADO connection string.
 On one of the VB6 forms, I have a data control and I get a error message
"Not  a Valid Password" for the code: Data1.Refresh.  I do not get ...

Hi ,
I am trying to connect to sybase using ADO connection string(MSDASQL)
, my password is have semicolon as one of the character , i guess due
to which connection string fails to open . Please advice  .

I just know a little about VB6, so I need you help!
If I want insert a null value into database through a variable, how can I
do?
I know in C#, there's a function convert to NULL (Convert.DBNull), is there

have a record set RS2 which runs this SQL query.. This query always
returns 1 row and 2 columns. The columns are always null(no data inside)
as the select query specifically does this.. I now want a statement that
does something like this:

i have a question...
can i use ado to load excel (i know i can do this part :-) ) but.. then it
checks what sheets are available and then ask the user witch sheet they want
loaded to the grid? ....