Is there any way to reference the Application object of an external
database?
The thing is, I want to use the D* functions on tables in external dbs and
since those functions are properties of the application, I need to point an

I'm trying to write code to create a Function that will, depending on the
Command Button pressed on a form, take the name label (caption) of the button
and assign the text to a string that I can then do something with.
I know how to do this on an individual button basis as a ...

I have created a Function that works on the Click Event of a button on a
form.  The function takes the Caption of the button_label and does a DLookup
to retrieve associated data.  
Within the Function I end up with two string values (strAirportID and

I have the following code:
StartDate = (((Now() - Day(Now())) - Format(Now() - Day(Now()), "d")))
EndDate = (Now() - Day(Now()))
DayCount = 0

I have posted my question on my website as the alignment in this post goes
for a toss. The text editor wraps up the data in the next line by default and
because of which I am not able to copy my data in this post.
http://www25.brinkster.com/shr­eejipc/Mihit/BoardAccessQuesti­on ...

How can I easily get the record count on a datasheet after I have applied a
filter

Can you help me clean up the code below? I expect it to hide the named table
and it doesn't.
Function HideTable(acTable As String)
   Dim DB As DAO.Database

Thanks for taking the time to read my question.
I am trying to use FileCopy to move a file from one location to another, but
I keep getting "Permission Denied" Run Time Error 70.
I don't know why.

I have a variable dDOB AS DATE to which I attach a date value from a text box
on a form. This date is then written to a table in SQL Server by passing it
in a parameter @DOB.
If no date in entereed by the user, I would like the field in the table to

I have a datasheet sub form and sort menu. If the user select Id and sorted
ascending or descending, I want to be able to know the sort selection to run
my SQL depend in the user selection.
How can I get the sort value in different form? For example, I want to be

I'm trying to open an ADO recordsetclone using the
following code but I keep getting a Type mismatch error.
I believe I have the reference(s) to the ADO.
   Dim RecClone As ADODB.Recordset

I have currently created a from that has three drop down boxes. After box one
is selected, then box two does a requery. After box two is selected, box
three does a requery.  And then after bo xthree is selected, a requery is
performed, and a report is created.  I want to know if ...

When filling bookmarks that are specified in the FOOTER of a WORD doc,
they are not filled !  on of they are located in the body.
Is this a bug in WORD ?
Or is my code wrong ?

Could someone please look at this code and tell me what I am missing,
please?  The problem that is occuring is I am given an error (5922)
that states "Word was unable to open the data source"
As an overview, I have a form where you can put the criteria to select

I am attempting to set a shell as an object and can't seem to figure it out.
Any help would be greatly appreciated.  Here is what I have so far.
   Dim System As Object
   Set System = CreateObject(Shell("C:\WINDOWS\system32\Notepad.exe", 3))