I would like to pass a pointer to a function/subroutine written in VBA (I
know you can pass one to a builtin DLL routine) and run it with data
specified within the calling routine.
Let me flesh it out a bit more for you with the following code:

Takes over 5 minutes to run.  Would coverting the query to VB to quicker?  
There are a total of 300,000 records being processed.

New problem for me here.
I sometimes have a need to have exclusive access to both front and back end
content.  
1. Is there a way that I can shoot a message (as in a timer) that will say

I need a little help. I have two procedures in my code:
Private Sub Form_Open(Cancel As Integer)
....
Dim Arr() As Variant

I'm using Access with SQL Server 2000 to develop a database, and want to set
global Transact SQL variables, but I don't know how.  How do a set a variable
that can be seen by any query, etc., in the database ?

I would like to edit a MSHflexgrid in Access 2000, as I've done many times
in VB6, using a floating Textbox.
However in Access, my textbox always appears BEHIND the FlexGrid control,
and so it is always hidden, even if I bring it to front in design view. And

I need to open a form from a subform and have it find records based on the
table from the subform, rather than a field on the subform.  Is this possible?

Is it possible to add a field in an Access table together with it's input
mask. I mean using an alter table query.
Thank you.
Torrio

Hi all,
I have been working on this code for many hours but I cant get it right.
Hope somebody could help a desperate here. This is my problem.
I have 3 combo boxes in subform. The second combo box row source will depend

Failed to attract a response after 2 weeks under forms coding.  Trying here...
I have Access 2003.
I'm trying to programmatically load a Word document into Access via OLE.  I
have a table with a field called Reqmnts.  Its data type is OLE Object.  I

I am using an excel file which has macros in it, when ever i click the
command button its gives the msg that Run-Time erroe '429'  activex
component can't create object.
can any body help me on this, waiting for the replay

When I open my form I want my combo box to drop down and show the records
somewhat like a list box.
VBA code?

If you cannot come out with a Access interface similar two Access 2002 then
count me out. I will not purchase this joke.  Who ever came up with this
managery should be fired.  I waited five years for this. this is insane I
could not be more disapoiunted

i know how to combine two fields in a question to get for example name and
surname together, but i can't get a spacing between the name and surname ex.
this is the way i want it...
olle andersson

If you are storing the User Id and password in a table.
Is there any restrictions (like special characters?) that you cannot use?
Or does MS Access 2000 care?