I have function Function1 defined in MS Access 97 module.
This function is used in query Query1: SELECT A,B,Function1(A) FROM ...
So far so good .. good results.
Now I want to use Query1 in my VB6 application:

How to write the code when I press key F6 in keyboard to run an event?
Thanks in advance
Kennykee

I want to be able to select an item in a list box, then click on either an
up or down arrown and have the list item move in the corresponding direction.
I think I need to reference the listindex, but I'm not exactly sure.  Any
help would be greatly appreciated.

i'm hoping someone can point me in the right direction.
what i want to do is to be able to copy multiple fields from a form to the
clipboard with the field names.
now the tricky part. when i go to right mouse paste is it possible to have a

I am creating 7 digit SKU numbers for my products and need to create a
database to cross reference the product and SKU. I need to be able to type in
a SKU # and the product will pop up. The first 4 numbers represent one thing
and the other 3 numbers represent 3 other things.

When I update the (existing) AppTitle property with DAO code and do a
Application.RefreshTitleBar the change is reflected in the titlebar. When I
do the same with ADODB code: CurrentProject.Properties("AppTitle") = "new
value", the change is not displayed after the Application ...

There's six different stores w/ all unique part numbers in their inventory
system. I'm building Oklahoma City's information system as the master
(primary key) key for a universal part numbering system. I want to know if
the other systems have any part #s that OKC doesn't have. ...

This may be off the wall, but I figure the programming newsgroup would be
the best source.  I have an Access application that I would like convert to a
stand alone package (exe file, I don't want the user to need access or
runtime).  Can someone tell me which programming language ...

I've searched the board for the answer to my questions but I haven't been
able to find what I need.  My scenario is as follows:
I have a table that with four fields and thousands of records.  I am trying
to generate a random sample from the records of about 10%.  That part isn't

I've got two forms.  One datasheet and one normal form. So, if I select a
row in te datasheet all the data appear in the form.
But if the datasheet contains no data, then the old data in the normal form
stays there instead of disappearing.

I need to pull up some data by shift.  How can I determine what shift ran
what?  
I have a date/time field (combined) in a table that I am unable to do
anything too (linked and not our database).

Is it possible to use in a Public Function a method to "call" a private sub
(or public sub) which is tied to a click_event on a form button?
I have a unique need to try this method, which would theoretically work as
follows:

how can I change the rowsource property on a subform based on a condition on
the parent form?
if it worked, I'd write it like this:
if me.ab=a then

how do I search the FName field in tblTest for quote symbols?

I created an option group with two options using "yes no" buttons.  Based on
what is clicked (via vba), I write a value to a field in the table.
Here's what I need now.  I want neither button to be selected when moving to
another record, except when that record has a value in the ...