I have an Access application I've used long and hard under A2K, but now I
need to run it on a PC which only has A2K2 installed.
One of the main forms has a subform, which is filtered when the form opens.
The filter occurs in the form's OnLoad event; it calls a sub (in the main

Hi Ng
I have got a form which uses to days date - the date is stored in a table
when pressing af save button.
The format in the code is :Format(Me.Form.Controls("CTLDato"), "mm/dd/yy")

I've got a field that has some old data with text in it, but all forward
data will be a 3 digit number.  But many of the numbers are still only 2
digits.  I would like to force the leading zero in the entry of the field.
For example if the number 77 is entered into the field, 077 ...

Is there any way of determining in VBA the name and arguments of the
currently executed procedure?
To assist in debugging, I would like to be able to trace the procedures as
they are executed.  Then, when it crashes with Access's usual unhelpful

here is my situation, any help will be appreciated
i have a form with two command buttons on it, listing update and append
arc
Private Sub listing_update_Click()

How do I limit the results of this query to return only the NextAppt and the
corresponding Subject?
SELECT [Subject], MIN([ApptDate]) As NextAppt
FROM tblAppointments

There is a font number limitation in Access which prevents them from
appearing on some pop-up lists.   Has anybody encountered this same problem
and if so is there some work-around.   I do a lot of web publishing and I do
not want to remove fonts from my Font directory just ...

In Access each field has individual properties (font, size, color etc).  Is
there a way around having to enter all these similar properties for each
field.   This seems so redundant.  Is there a way that I can set up these
properties only once and have individual fields use these ...

I realize this is very basic stuff, but I have lost my Access program
books and cannot seem to find what I want.  
Having finally managed to joint two tables to create a query, I am now
trying to run a query to sort out all the basketball players from

Hello!  I do it every year, but every year I forget.  
I have a table with two fields:
First Name
Last Name

Does anyone know how I can getseveral users to share a single database
at the same time on a network? I can only get one at a time. Is it
something to do with permissions or is there a setting in the database?
Thanks

Is there a convenient way to trap the date/time of the last change to the
data (in the tables) in a database.
(the date modified changes when the file is accessed, irrespective of
changes, so that's of little value)

In the FE mdb I put two variables in a module:
Private selectedFromDate As Date
Private selectedToDate As Date
I create functions/subs:

I have this bit of code:
SELECT itemcode, min(Price) AS minprice
FROM itemlist
GROUP BY itemcode;

I have MS SQL Server 2000 evaluation version on my desktop PC. I have
the SQL Server client tools (only) on the laptop. The two computers are
networked. I had an Access MDB database on my laptop, but I converted
it with the Access upsizing wizard to an Access ADP database with the