I am currently trying add sum form of navigation to my reports, i want to
avoid having to press the cross at the top right in order to close that
window down so i can go straight back to my form.
Is there anyway of doing it?

I'm trying to do the following
I have a table with "purchase date", "item purchased", "vendor" and "price"
and would like to extract for each item and vendor the LAST price paid.
040101    ItemA    VendorX    10$

Hi. I want to be able to select a set of records, in a
query, by saying "give me all the records that have the
year 2003 in the date in this field". The field specified
is a Date/Time field, set to Long Date in the Table. What

Hi I'm looking for some hel
I am trying to implement the copying of the contentents of a text box to the windows clipboar
Private Sub cmdCopy_Click()
Track.SetFocus

I have added some new tables in my database. When I am in design mode on a form, the new fields do not show up in the field list?

I would like to activate/desactivate a process (a VBA procedure) by
shifting the focus on/away from a controlbox. Starting the process is
fairly trivial, but stopping it stumps me. I don't know how to abort
the procedure once the process has started (DoEvents, etc.) It seems

In India we use the following format to display currency:
1,00,000   -- Known as One Lakh instead of  One Hundred Thousand
10,00,000 -- Known as Ten Lakhs instead of One Million.
10,000,000 --Known as One Crore instead of One Billion

Is there an easy way to update 40 columns from one table to another.  The
only examples I have seen are using joins but I don't have a good field to
join on.
The application adds a job to a schedule then a technician fills in all of

Is there anyway I can setup autonumbering to use a specific numbering
fomula?  For example to put 2 zeros before the numer 1, 2, 3 and so on.
Thanks

I am importing a field from another database.  The field has data that
represents       location  district   compan
and looks like                xxxxxxxx.xxxxxxxx  (ex.1
or                   xxxxxxxx.xxxxxxxx.xxxxxxxx  (ex. 2

I would like to know the maximum table size of MS Access.
Thanks you for kind attention!!
Roy

Hello all,
I have devised a way to get the month
value from the Calendar control...and thats to just place my own cboBo
over the Calendar control cboBox in order to do exactly what I want i

I apologize if this question has been asked before.  I'm new to using Access and I'm responsible for keeping a database of approximately 150 employees.  One of the things I want to do is run a report that will give me the retirement date for those employees.
That date will be 20 ...

I have a database that needs to be viewed by a number of
people who currently don't have Access installed on their
computers.  It's going to take some time to convince the
company to buy additional licenses, so can anyone suggest

I need to get the 2nd row in a table, when it is ordered by date.  I know I
can get it by retrieving the whole result set ordered by date and then step
to the 2nd row in the recordset.  But that seems inefficient.  In some
environments, I believe I've seen a SELECT TOP 10.... or ...