In Excel VBA, there is this command
ActiveWorkbook.Path
which can tell you the Path of where the active xls file that you working in
is.

I have a form with the following:
txtbox numStudentRef
txtbox txtName
Tab Control [Information]

I am trying to build a pick list of items that have criteria for selection -
but I don't want to hide the items that don't meet the criteria
eg list of:
Apples    Fruit

I have a complex problem. I have some users who what a search form.
They want to be able to search by up to 5 different things. The problem is
all 5 are stored in different tables. They are connected through a master
form, but that form is going to have a lot of records. Is there ...

I have a record that I would like to send it to MS publisher so that it would
print. How can I do this.

I would like to have a button on my Form open the request task section of
Outlook, preferably with a default recipent already created.  Is this
possible? and if so a BIG hint as to how to do this would be very much
appreciated.

I have a form that is designed as a dialog box. When it's executed from a
maximized form it will load as maximized, too. However, when it's executed
from a restored down form it loads restored down.
Loading maximized is annoying. How can I set it up to load restored down

I have several forms on which I would like to use custom nav buttons.  I have
successfully set this up on one form but it seems like I should be able to
put the code in a module and call the procedure when the form opens (the
form's On Current event) and when the First, Previous. ...

I need to know if there is a way to determine in access what library the vb
code is using. We have some code that use to work when we all had office xp,
but we moved to office 2003 and I am assuming that because of the 11 library
the code doesn't work.

I want to filter a combo box based off of a user's selection in an option
group.
The 'Option Group' contains a number of different reports  (New, RePrice,
Products...)  These items are vaules in a column called 'Request Type' and

Hi,  
I am trying to do this:
Take a SQL Count query, move the result to to a variable, and then throw the
variable to a msgbox.  

I would like to use 3 combo boxes to choose the time for my bound textbox;
Hour, Minutes (by the quarter hour), and AM/PM.
My bound textbox txtStartTime (default value is 08:00 AM)
cboHour: would be a value list of 1-12 (representing the hours)

I need to be able to get rid of the hourglass, and reset echo and setwarnings
back to true. The function is easy to create, but how do I assign keystrokes
to it to activate it?
Bill

When scrolling down in the sub form, and then scrolling up again, the record
on top seem to disappeared. By using the scroll button on the mouse I can
scroll down but when scrolling up I can't see the record on top. (Using
vertical scroll bar I can scroll up and see the record on ...

Is there anything available to enable me to force a label or text box
infront of an active combo-box?
I have a small sub-form (pop-up & modal) to display contacts for a given
customer and want the 1st tab combo-box that contains the numerous contacts