VB Forum / Database Access / February 2004

In ado can you send a requery to only refresh one record?

I have a VB application which utilizes an Access 2000 database.
It works fine when the user's Language/Regional setting is "English (US)".
But, change the Lang/Reg to "French (Canadian)" and a typical fraction that
would have returned as "3.14" is returned as "3,14".

I have a recordset which I am printing. Some fields are empty and the
printer prints "NULL". I want it to print"" - nothing at all!
Help
Thanks

I've been using this string as part of my access 2000 databse to create an
email for me.
Now it has stopped filling in the EmailBody bit on Access 2003 machines.
DoCmd.SendObject acSendNoObject, , acFormatTXT, EmailAddress, SupportMail, ,

What should I do to have a VB 6.0 application running on Windows 95
My customer uses Windows 95 with Office 97
I told them to move forwards, but they won't
I created a package, like I did for every platform

Connecting to MS SQL SERVER 2000
   Form1.Adodc1.CommandType = "select * from ITMFIL00 where [ITEM-NO] =
'XER11'   "
   Form1.Adodc1.RecordSource = Text1.text

I have a form with quite a few textboxes, combo boxes, and a flex grid  that
are filled from a variety of tables.  In my form load event all of the
information is loaded from the various tables.  I am currently using one
recordset to load the information into the combo or textbox ...

I have two users who see the same recordset in a grid at the same time. One
user inserts a new record. How can I immediately refresh the other user's
grid?
My project in VB, database: Access over DAO.

Anybody knows of some VB code(VB code tidy utility) ??
Thx,
Nayan

I am trying to use a data report (datareport1) that is using a data
environment (dataenvironment1).  I am trying to print a sql query at
runtime.  Here is my code:
In my Form_Load, I am setting the connection string by:

I am using VB6 and ADO with an Access97 database.  There is a backend
database with only tables and a frontend datebase with queries and links to
the backend tables.
When I use a command object to open a parameterized query as

How can I code VB6 to INSERT a word document into an access database and
then retrive it? I guess the access databaase needs to have an OLE field but
after that I'm stuffed!
Many thanks

I have looked and cannot find a way to get the VB6 project compile version
number so I can display it in my "About" form.
Can someone point me in the right direction?
Thanks

   In a group project that I am doing for a class, we need to create a
simple client/server application.  We intend to have the database be on the
the server and have the client access it.
   The current way I am thinking about doing it is connecting with

I've sucessfully use the framework below to read an Excel spreadsheet. But the problem I'm having is that it makes the 1st row of the spreadsheet the column names of the dataset. Unfortunatly there is important information in the first row. Is there any way to not have the first ...