VB Forum / Database Access / November 2004

I'd like to clarify the meaning of the Size property, when creating a
parameter to call a stored procedure.
Let say the size of the field in the database is varchar 100 and the size of
the data is 80, should I set the Size to 80 or 100?

i have this query
   SELECT id, email FROM [user] WHERE (email IN (SELECT email FROM (SELECT
email, COUNT(email) AS c FROM [user] group by email) AS aaa WHERE  c > 1))
ORDER BY email;

List:
Pretty much what it says.
I'm using DAO 3.51 (iirc) under VB6 SP5
I've a number of queries that I issue repeatedly with slightly different

Please provide me the syntax of "alter table..." to disable and enable
foreign keys in Accsee database.
Thanks.

Now, I am developing the personnel system. But when two or more user running
the system, one user have updated one record and second user browse the same
record. It cannot show the updated information for second user except the
second user close the system and re-run again.

I'm not sure what this means.  I upgraded my merge module from 2.7 a to 2.8
and receive the message
"'MDAC 2.8 Reboot Location' is not a valid Property value
What does this mean?

How can I connect to Access and fill values from 1/field into a array and
paste the result into a msgbox??
Can someone please paste any exampel for the above problem I can't find put
how I should solve the problem!!

When I tried to transfer SQL Server Data to Excel using VB6, the errors was
occurred.
The following is the coding and the error messages:
Coding:

When a shape is applied in a query and loaded into a mshflexgrid, invariably
the plus signs are in the open position showing all matches.  Is there a
property that sets them to open in the closed position?

Somebody please help!
I'm using VB6 - ADO. The recordset updates fine the first time the
rs.Update() method is called. However, when the same record is updated a
short time later this error occurs: "Row cannot be located for updating.

I'm using an english version of XP and developping sotfware with VB6 for
french people. The date returned with "NOW" is an english date value.
When day is less or equal to 12 format(now, "dd/mm/yyyy") return for
exmaple 10/11/2004 where date=november 10, 2004 , but when day is

I need to spin through a huge table (500,000+ records), look up information
in two other tables (based on values extracted from each "master" record).
Then I need to place the original master entry into a second table and delete
it from the original table.

I have an application that migrates data from one database to another.  I'm
using ADO 2.6 and VB6 SP5.  Database is MS Access to MS Access.  
A connection object is opened for each database.  For each table in the
source db I use a command object to execute an insert on the ...

   I'm accessing an Access table through VisualBasic scripting using an ADO
object.  I'm trying to filter on date comparisons.  The following select
expression does not work.  The 'Initiated' field is defined as a Date/Time.
Select expression:

Here's the problem. I have the following function... (Watch out for line
wrap)
Private Function xref_lookup(ByRef strXref As String, ByRef strCode As
String) As String