VB Forum / Database Access / May 2005

In my application i have a table of 100 000 records , and i need to fetch
them 10000 each . for example first fetch i need to get 1-10000 records ,
second fetch 10001 -20000  records to the record set.
What can be the MS ACCESS query to get something like this

I use the BrowseForFolder function to let the user searching some files. The
function is quite good but I don't like that the message 'What's This?'
appears if you press the right mouse button on the BrowseForFolder window.
To avoid the right mouse button on a TextBox I use

is it possible to read and write a record from COBOL INDEXED FILES in visual
basic 6.0 or .NET
Thank's
sf

I'm using VB Classic (VB6).
I want to know how will i know which control in the form will have focus
when clicking the mouse button. i mean, currently i am in one textbox
control and when it loses focus it the program will validate it. if the

Can anyone provide me some examples of using a Heirchal recordset such as
Customers - Orders - Order Details in the Northwind database without
employing the use of the Shape construct. Any help would be much
appreciated. Thanks

These files remaining into task manager also after i've close my exe app
created with visual basic 6.
Why?
Can you help me?

Mention Any kind of type which supported by Provider
Microsoft.Jet.Oledb.4.0?
or
Mention any kind of values that can be inputed at its "Extended Properties"?

I've made some printing forms with crystal reports but i made it with a
wizard.
In that wizard i must point the pad to my database
(D:\Projecten\Eindwerk\Mijndatabank.mdb)

I have a problem trying to get the record count to 0
below is the code I am using.
If I send an incorrect password, I should then get a record count of 0.
However, it is always giving me a recordcount of > 0, regardless of what it

I have a text box (txtTime) on a form and would like the system clock to run
in the text box. I have tried txtTime = Time but it only displays the time
at which the form loads. Can anyone help please?
Thanks.

Perhaps a stupid database design question, but are there any pros/cons to
storing negative values in a database field, vs. storing the number as a
positive (then changing as necessary with code)?  We have been being
somewhat inconsistent with how we have been doing this for our VB6 ...

I created an address book that will show personal information.
Now, I like to inherit a login page in order to retrieve the address book.
The user will have to enter a userid and password, in order to retrieve the
address book.

I have this error:
"Microsoft JET Database Engine (0x80040E10)
noone value specified for some needed parameters"
at this instruction:

I would like to use same code for querying dates in OleDbCommand (Access
database) and SqlCommand (sql server). However, sql server require quotes
where Access require #. Is there a uniform way for both?
Thanks

I'm trying to disconnect an ADO Recordset in VB6.  This works fine when
logged into my production database.  No problem.  However when I am logged
into my development database, I get the following error:
3707 Cannot change the ActiveConnection property of a Recordset object which