hi everyone,...a two parter....
I am trying to calculate the age and months of service.  I used the
calculate age function, however I wanted to know if I could get age along
with the months as well....for example....6 years 8 months?  Does access do

I would like to be able to create Access databases and have users enter data
into them. (I know it's a stupid statement as that's what Access is for)
however I don't want to have MS Access on all the machines.
Is it possible with any available software (I would have Access on my

I have tried building a macro with the run command funtcion but it error's
out.  Is there a way much like when you compact the database on close funtion
in options?

I have a subform which has some required fields. I have been informed that a
way to get out of the subform when a record has been partially created is to
use
me.undo

when sorting a column of surnames in Access it puts O'NEIL before OATS but
when sorted in Excel it puts OATS before O'NEIL. I have also notice this with
name starting with Mc or Mac.  Is there any way that Access can be made to
sort the same as Excel?

Backed up DB in 2003 moved to machine with 2007 ran for two wks backed up and
copied, moved both files to first machine. Access crashes when filtering by
form, highlighted in the date field when filtering shows >=6/16/07. I did not
convert at all.

I need to have a database for comparing between about 10 supervisors. This
database compares supervisor’s performance, no. of courses, and the no. of
experience years.
If anybody has a database like this or knows a website provides it, kindly

Help Guys I have 2  textbox controls on a form The first textbox displays  a
Transaction Date from a table called sales Now I want the second box to show
the Total count of products on that date and before am using the following
expression

I have a table tbl_Cost. In my form I have a combo box (cmb_Year) and
a textbox (Text7). Now the control source of Text 7 is
=DLookUp("[COSTYear]","[tbl_COSTAPPEND]","[cmb_Year] =[COSTYear] ")
The rowsource of the cmb_Year is

I have attempted to use the code supplied on
http://www.mvps.org/access/api/api0001.htm and as I have limited knowledge of
VBA have found it a bit confusing. The Issue I have however, is that how do I
link this code to a button, I have completed usual practice of using the 'on

i am finding it very hard to get hold of the above. I need to distribute some
databases that are small to medium in size and complexity. the machines do
not have a copy of Access so the above was suggested to me or Runtime. Does
anyone k now where I can get a copy of either? I am ...

If an invoice has grociery items, then the order of the items on the invoice
is not important.  For example:
apples - $1.29
oranges - $1.15

Does anyone know how to enumerate through the AllReports collection to
set a custom menubar and toolbar for each report in the collection?
I can set the menubar and toolbar when a report is open, but I need to
be able to set these whether a report is open or not.

No problem setting a textbox's BackColor by code, but...
i'm using in...
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
...snippet...

i have a table open in access, in datasheet view, and i can not cut, copy or
paste in to the table or from the table. i want to copy one feild at a time.
The data is stored on a server, so when i use a diffrent computer evrything
works fine.