VB Forum / Database Access / June 2005

Please check the code snippet below. I want the 4th column be numeric.
But, in the result it is always showing as text.
Any suggestions to show this column as numeric?
Thanks.

I am repeating this because the internet server stopped.
To circumvent the problem of the security dialogue in Office 2003, I start
my Access applications from another application with the following:
dim appSIS As New Access.Application

I have a query that runs a stored procedure which returns a resultset in
query analyzer but when run in vb doesn't open a recordset
I have tried set rs = conn.execute(strSQL)
and

I'm doing a project (for work) in VB 6.0 using an Access database (with
ADO).  It has to be runtime compatible, so I can't use the new
Access.Application.  I'm using a shell execute and getobject when I
reference Access.

I want to insert picture into Access DB.
I use INSERT INTO statement, but it doesn't work.
Please Help
Regards

I would like to retrieve the number of records a user chooses, set equal to
the variable N.
SELECE TOP" & N & "FROM Problems......
I am not sure of the format....

I seem unable to get a dataset to update the database properly on a call to
"update". I have a simple form with a bunch of text fields bound to fields in
a  table called "settings" . It loads and fills correctly, and when I make
edits to the bound text fields the changes are ...

I've just (after 2 years!) discovered the data repors object
Well, I've foind int NOW becuase I've gone from VB6 learning to
enterprise!!
However,

VB6 SP5, Access 2003.  Level - Beginner
Can someone help me to determine what is wrong with this SQL statement
please.  Worked until I added the BETWEEN statement. Date values are derived
from inputboxes.

I'm developing a database project using VB6 and SQL Server and I've seen a
few ways that folks name their functions and SP.  I'm soliciting help to
find the best way to name my objects.
For example:

There is a scenario in my application,where you have to read an exce
file and import the Values to a SQL Server Table.
The methodoly that i have implemented is:
Step 1: Open an Excel Connection using Microsoft Jet Oledb Provider.

Can I get example and explanation for Connection string to SQL Server
Database?. I want to made application VB with accessing SQL Server 2000.
I very appreciated for your help..
Regards.

My Application freezes while performing UpdateBatch.. Is there any
workaround to do the UpdateBatch asynchronously ? in Detail..
I was doing Batch Updation to SQL Server database through ADO
recordset's UpdateBatch Method. The Pseudo code will look like

I am writing an application in classic VB that will address an
underlying database.  I have written code to deal with the 'normal'
situations when all is running well, but am having trouble dealing with
those 'other occasions'

Thanks a lot for you Advice William.
Actually in my application, the users who are not connected to the
server will load an Excel file with data and send it to us.
We then will read and import the data from excel to SQL Server table.