VB Forum / Database Access / April 2004

This may seem peculiar.
I am always working with money and interest rates.
I frequently make changes to get to a desired result.
When I enter a textbox I always have to delete what is there

This is going to sound REALLY weird, but my boss just threw me in the lions den.  I have VERY little programming experiance in the way of APPLICATION programming.  I usually use VBA with access and javascript and stuff like that.  So here is the deal
my boss wants me to make a ...

Can someone please tell me what driver/addin, whatever, I need
so that I can use VB6 to access Access 2000 dbase files?
Many thanks,
Geoff Turner.

I'm using VB6 as a shell over Access2000 I have sent  the forma
in my masked Edit to ###-##-#### and to Social Security i
the Access Field, and it works fine except for the leading 0 whic
does not display

I have a database with a Visual Basic front-end.  Within this VB app, it is
possible to search a table in the database, using a secondary key (i.e.
customer name, there could be two customers with the same name) via direct
access.  The results are displayed in text boxed on the form ...

I need to know what code to write in order to round the value in a text box
off to two decimal places.  The value is a single number, but I need it to
be displayed as a currency on Form_Load().
Ideally this code should not be overly complicated, and should be short and

how do i capture the return valuer from this SP?
alter procedure dbo.TableExists
@tablename as varchar(50)
as

I have a data access class with a function defined below.  As you can see
each call will open a connection, run query, close connection then return
data.  The process of establishing a connection for each query sometimes
takes longer than running the query!  I thought that ADO used ...

i wrote a vb program that insert row in an access db, just execute a :
INSERT INTO eventi ....
it runs good until today, i change the pc, it was on a win2k english pc and
now it is on winxp italian pc. The other query SELECT  runs good , the

Can any body help me to use the ADO Recordset in Multiuser Environment?
How Can I Restrict User 2 to Open the Same Row which is Opened By User 1 and
I will Display Message that "This Record is being opened for edit"?
Suppose User 1 Open a ROW using SQL "Select * from EMP Where EMPID ...

I am developing an application using VB 6.0, MS SQL 2000 and I really don't want to use Crystal report to generate the report instead I would like to use MS WORD b/c it give users option to make changes to the final output.  But how do I implement that?  Does anybody know of a ...

When i query a table written japanese (unicode) my record set gets corrupted
how can work around this?
I use ADO , windows2000,vb6

I am trying to connect to a DB and return several (disconnected)
recordsets.
The problem that I am having is that the number of recordsets that I want to
return is not predefined and I want to have them all current when they are

I have a stored procedure on a SQL server 2000 db that returns database
fields and empty field that I declared as a variable.
I then want to disconnect the recordset from the connection and step through
the recordset and depending on logic update the empty field with a value.

What is the easiest way to go from rdo to ado? Any suggestions? I have a project that I took over from some other developers and it uses rdo. I'd like to migrate it all to ado, but some parts use a class other parts use straight rdo code.
Thanks