Anyone know any good statistical add-in for access, preferably
free(sorry already aware of Total Access Statistics), that can easily do
frequency distribution tables, with counts, cumulative counts, percents
and cumulative percents??

I am working on a DB for ordering process. I need help on importing a text
file (Tab delimited) into my DB.
I can import by creating a query with append option to import the data into
my db, but the problem is the text file name changes everyday "ddmmyy.txt"

Are there any general gotchas or specifics about version compatibility?
If Access abnormally terminates can the database be corrupted without
any apparent problems in the future?
I've written an Access database using Access 2k2 using an 2k database

I have a form where one of the entries is "Contact".  On BeforeUpdate
I check the table for the existance of that Contact.  A mesage box
informs the user that the name is already in the table and cancels the
event.  What I want to do is clear the text from the text box to allow

Please, I need expression to be used in a field in FORM. After I
divided 2 numbers I want the result be rounded to the nearest "half".
Also, when I sum " [q1]+[q2]/2. I get wrong answer for exampmle  4.5+2
/ 2. the result should be 3.25 but the I got 4.25 . Any idea how to fix

Is this even possible.  To be able to have a subform where the Master field
on the main form is linked to the subform via 1 child field OR another?  So
the table for the main form, can be matched to 2 different fields (one or the
other).  Can this be done with only 1 subform?

Could develop web pages that would interact with the access/jet database
- like DAP but without the security flaw???
One of Access' competitors (Filemaker Pro as I recall) touts its EASY
way to build web forms using its product.  Sounds like they are trying

I have been working on an Access Db for awhile and am very close to
being ready to hand it over to the person who requested it.  There will
be one user and the db will reside on a desktop PC.
Here's my dillemma?  How do I insure that the user will not have access

The Access form's control box has available an "X" to close and the
min/max buttons.
Is it possible to customize the control box to include other options
and to isnert my own icons/command buttons?

I have this funny problem with the listcount property of a list control. If
there is no item in the list, Me.stafflist.ListCount returns 0 (zero). If
there are any items then Me.stafflist.ListCount returns the actual number of
items + 1. Why is that?

If I divided  6.5/2 , I get 4.25 and if I divided 7/2 I get 4.75. I
want the first number to be 4 and the second number to be 5. but if the
result I get from other division 4.5, I don't want it to be changed.
Please, I need the expression to be used in a field in FORM section to

Can I control what text appears on msgbox function buttons?
Sure do like NOT having to build a form to show a msg
and solicit a YES/NO response. MsgBox function is a great solution
for that.

I found some code Dev Ashish posted nearly a decade
ago in response to someone's inquiry describing their need
to dial a number, monitor call progress and determine whether
it was busy. This was back when A2.0 was more widely used,

I just had a google through this NG but have not seen mention of Erik
Rucker's blog entry and the new Jet:
http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx
mentioned by Mike Gunderloy

Is there any way to run (emulate?) MS Access application on Linux ?