VB Forum / Database Access / March 2005

i am doing project on vb. backend is ms-access. i want entire project along
with database on cd.pls any one can tell me how to do that.
thank u
arpana

I have been entering data from surveys into an Excel spread sheet. Each
respondent may have up to twelve types of problems that they will have
written something about. I have created a separate column for each
row.This is what it looks like (if you get my drift).

This is quite long-winded, so please be patient. I appreciate it.
I have an all pure-code database application.
The way I load all the fields' data into the various controls is in
the MoveComplete event.

Ok, here is the dilema....
We have CSV files that are in UTF8 or UTF16 format, so they have a BOM at
the beginning of them.
How would you get the MS Text Driver to read these properly?  There is

I have some subs which take connection objects as parameters
Public Function RunSQLSelect(ByVal dbConn As ADODB.Connection, ByVal sSQL As
String) As ADODB.Recordset
       On Error GoTo ErrorTag

Just curious... I'd like to have a list box that contains all the rows in a
particular field of a table, and by selecting a particular entry in that
list box, the cursor changes the current record to the entry indicated.
I'm thinking I need to...

I am trying to insert a string in my access 2003 database in a memo field.
The problem is that this string may have any kind of characters because it is
an IT knowledge base, so many people will try to insert there how to solve
problems with source code, queries, etc. Is there a ...

I have an access database that stores employee timings by date.
At the same time, I have a form that queries this database.
On the form I use a DTpicker to enable a user input the date for which
he/she wants data

I really need help for my project?

Hi all,
i have one asp page which picks up about 15 number values from form, and
enters it into sql server database whit float data type fiels.
my problem is how to enter NULL value into database if nothing is entered

I have an app where I have an ADODB.Connection object that is being
used in several places throughtout the program (in a .bas module and
in two different forms). I have this statement in the Declarations
section of the .bas module:

 i have a  problem  running vb6 program in windows xp,the vb6 program can
run in windows 98, window 2000 , how  ever  when i  install it and  run in
windows xp  profesional it  came out this:
Run-time error '3709'  The Connection cannot be used to perform the

Hi all,
i have one asp page which picks up about 15 number values from form, and
enters it into sql server database whit float data type fiels.
my problem is how to enter NULL value into database if nothing is entered

dear friend:
 any idea  to generate  the word document from  VB program? (recordset
display  to word)
hope someone  can give me opinion

I have created aCrystal Report, but I have problem in selecting record
from
a calculated field to printout. Can anyone help me? I need only those
that have an account balance to print out.