I was wondering if someone can help me out -
I have a textbox whereby it's entry is dependent on which of 3 buttons is
pressed. By clicking one of the buttons, it populates the textbox with an
answer and disables the other 2 buttons...

Im sure I have asked this before, but I cant find my post....
Is it possible to get the position of a selected node within its parent?
e.g. Parent has 10 nodes and the 6th one is selected.  I want to display on
my form "Selected Node = 6/10".

I have a a list box that getting its data from a table.
The list box is called LB
the Table is called table1 and has only one filed called Field1
What event and what code should be in the event for the list box to be

I am an Access nOOb! (so please forgive my first (of many) stupid questions)
I have a database with several different ways of looking at the same data.
IE: reviewing parts by Branch or by Vendor. The detail information is the
same no matter how I am grouping it, but each way of ...

I am wanting to show how many entries are on my database with different
criteria (i.e. How many are professionals etc).
I beleive to do this I should use DSUM, can anyone tell me the best
method to do this?

I need to insert this code in a form "on open property":
If today's date is Saturday then
make "this button" visible
End If

Can I open a subform from a command button rather than have it embedded in
the main form?  If so, how?
Thanks for any help!

Is it possible when opening a form from a button in another form to
copy information automatically?  Such as Name, Reference Number?
Thanks
Colin

I need a formula to back the Tax out of an amount.
For instance if the field is $1.00 I need to find out the amount that is
 Tax and the amount that is the Item.  Does anyone know what the
formula is?

I need to prevent the user to register more than a specified number of
records for a certain kind. Is it possible, with help of code in a form, to
test how many records there is in a table?
/ Rolf

I have set up on my database a means to print the current record on a
form using a report.  Is there any way that this report could be
emailed to someone by clicking a button and the details being copied
into an email?

I found the listing here that shows how to write the code for a module to
duplicate info from one form to a new record on the same form (Funtion
AutoFillNewRecord).  What I can't figure out is how to tell the command
button for add a new record to use this function.  Can anyone ...

Hi and thanks for your thoughts,
A Students table (and form) has LastName, FirstName and UserName fields
(controls). I've written a function to create/check UserName.
This code is executing in the forms beforeupdate event:

I am attempting to have a form auto-close either by tabbing through the last
field available on it, or by a button.  I can get the button command to work
by using an onClick DoCmd.Close, however, if the user tabs through the
button, it opens a new record in the table it is linked ...

I suspect the answer is no, but here goes....
I have a form which displays a simulated (i.e. MSKB 304581) progress meter
for a set of actions within the application.  The meter works fine until;
except, for one step.  At a point in execution, I'm running a stored query to