VB Forum / Database Access / December 2003

I am trying to update a textbox formatted as currency and I get this error.
Whilst doing the same in a normal textbox I have no problems at all.
Please advise.
TIA

Hello --
I need a control similar to a combo box that displays a number starting at
1.  It should have an up/down arrow to the right of the control.  I'd like
to increment/decrement the number based on the arrow selected.  What control

My VB6 application installed on 15 workstations uses Access db located on
the file server. We started to get corruption of DB one month ago. We
replaced a file server (it had some problems with hard drive), we checked
all network cables, cards hubs. Yesterday we tried to install ...

Hello--
I have two child forms within my VB6 application that I started to have
problems with tonight.
Child Form #1 (frmCustomer):

I use a couple of access databases that use all another database (also
access) through linked tables.
Somehow the information about the location of the db with the linked tables
is stored in the DB.

I need a ADO-connection to a IBM AS400 Database based VB6.0
The open is OK but command.execute create a runtimeerror.
Dim conn As New Connection
Dim cmd As New ADODB.Command

Using Access 2000 as the database with an OLE field
(photos) I want my Visual Basic 6 project's ADO control
to scroll through the db records and display the image in
the VB control. I have set the ADO connection string to

This is the problem.  I have to write a service for
Windows NT.  The service, in theory, is ultra simple.  
Open up a database that already exists, run 10 consecutive
queries that already exist, and close the database.  The

I am having trouble dealing with Recordset objects.
First I retrieve user information from MySQL database.
Then when I access these Recordset objects' fields by
changing the value

There is a query that works in Access.
It has REPLACE(...) in it.
When I try to use it from VB, it says:
Undefinde function REPLACE in expression

In converting a program from DAO to ADO, I know (and use) that DAO's
Tabledef.Fields collection is in the field order of the database table,
whereas ADOX's Catalog.Table.Columns collection appears to be in alphabetic
order based on the name of the column (field in DAO). Thus, trying ...

Ok I am just a baby at this however I have a form that
has several input boxes that set global variables what I
want to do is use one of the variables "Name2" in a sql
statement to populate a datagrid that will show all of

strQuery = "SELECT Defending, [Profit Taking],
Maintaining, Growing, [Agressive Growth], Launch From
Schmendry where Category='x'"
if i change the = to <> this works.if i can exclude x why

can any one please help me?
I want to create a table in Access through VB with the
decimal Data type and with attributes as size 18 and
precision 2.

Friends
have developed a program for bussiness application using VB6 and
Oracle. I upgrade my box to  Pentium 4 2.4GHZ and Windows 2000 SP4. Lately I am
facing a problem. The Windows shows this message