VB Forum / Database Access / December 2004

I have a SQL statement to look if there is an occurrence of double date/time
values and how many occurrences.
Now i need a SQL statement to get the average of the total number of
occurrences.

I am trying to do what I would assume to be a simple process.  I have
an open empty form...with no data in it.  I have another search form to
get a record I am looking for. After selecting the record I have a
routine that grabs the record number, selects the data from an SQL db

Dear sir,
i have following structure of database tables.
master table Invoice have following fields
InvoiceSrNO

I have a combo box in one of my forms, the problem I have is when I am
updating the record. for example when I am updating any of the fields except
for the department which is the one I use the combo box for, I get the
following error message "invalid index".below is the code ...

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt
i get this erro when i want to update table whit cammnad
 sql = " update startstkt set startstk_eqty=" & rsd!eval & " where " & _

I would like to link a record (from different tables) from access into
word.
f.e.:
Table 1: Nationality

I have the following code but do not know the best way to return the updated
DataTable back to the database. I believe I can use the Update method of the
Data Adapter, BUT if true, I also believe I have to 'long-hand' write code
for each individual column data that's being added.... ...

Is there any way to make a recordset with records from 2 databases?
For example, if I have 2 databases (CurrentDB and ArchiveDB) is there a
simple way to get all of John Smith's records past and present?

I'm doing a 'select * from table' in my DataReader below and populating an
array with the results.  Obvisouly I'm only getting the first field from the
results by the use of the GetString(0).  
My Question is how do I find out how many elements there are to GetString

In one section of my projct i need to check certin fields in different SQL
2000 tables.
ie  in the client admin table, all clients have a licence number field and a
software type fields. Both are varchars. id like to check if the licence has

Hello,
I want to export all the data in a table in access 2002 to excel file using ADO
How can I write the code for it.
thanks in advance

Hello I need to create an ole db provider. I have seen links such as
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cp
contemplatefiles.asp
To help me out. But I am still having problems getting the ole db to work.
Does anybody know where I can find a ...

I would like to know how best to create an ADO recordset using the data from
an Excel spreadsheet? Thanks

Hi, how to define a required field when I create a disconnect recordset:
With .Fields
   .Append "ItemID", adSmallInt
End With

Hi people,
Why the :
Forms!frmHead!NMBProduct.setfocus
is not working when I "walk" trought the form (frmHead) and work just fine