I have a table with 21 fields.  3 of them are: tel no, cell no, and employee
no.  I have a table where I enter information for jobs, and I would like to
have 3 pieces of info added without having to enter them each time I enter
job info.  The employee info is in a separate table ...

I have 6 product lines, each product line has a high level of
configurability. Using tabs you configure each of the product lines.
Should each product line be stored in its' own table or one table with
all product configuration fields combined. Can you have a Parent Table

I keep getting 'Runtime Error 2448' when I run the code below.  When I debug
it highlights me.Filter=strWhere.  Any suggestions??
Private Sub Filter_Click()
Dim strWhere As String

I keep getting 'Runtime Error 2448' when I run the code below.  When I debug
it highlights me.Filter=strWhere.  Any suggestions??
Private Sub Filter_Click()
Dim strWhere As String

I'd like to make a report like this one :
               Jan    Feb   Mar    Apr    ... and so on
Qt             15      25     30      28
Sale      3000   4500  6000  5800

I was wondering if this is possible:
If a user has three loans by the same company(but different loan numbers,
amounts etc..) and fills in all the information in record one, because most
of the information will be the same for the next two records(next two loans)

Is there anyway to protect a Access Database File from "deletion". I
mean, wherever we save the *.MDB file, no one will be able to delete
it. Because, Access will ask PASSWORD to confims deletion.
Regards.

Hi, i have read through millions of posts but i dont seem to be able to find
the answer.
I would like my form to open showing no records until after the combo box
has chosen group or category.

When the Filter criteria means no record/s are found a new record is inserted.
I want nothing displayed OR an error message OR anything else!

I have a table "Appraisals" with amongst others two fields, one called
Appraisal_Reminder and the other Appraisal_Due.  In the input form I would
like for the Appraisal_Due to be the date in the Appraisal_reminder + 14 days
so that when the user input 01/03/2007 in the ...

I used the user based security wizard to set up users w/ passwords. I could
really use help with the following issues:
1) I need to create a form and routine for prompting the user to change
thier password from "NEW" to a strong password (i.e., Rsmart@6, at least one

Sorry if this is a little bit of a noob questions,  I have a Form (frm.a)
that has two subform (datasheet view, sub.a, sub.b).  I want to open a
additional form based on the active line in sub.a or sub.b.  as it links to
that data.

Is it possible to disable the Access notification about lock and other
violation issues for a specific form, and leave it to notify on other forms?
Thanks!
-gary

I need to split the name field content of an imported table in a MS Access
database. For instance: Mr. H.C.J van der Laan-ter Broek.
It needs to be split in:
Honorific: Mr.

I have a form which is used only for data entry and its DataEntry property is
set to Yes.
I have a user who keeps using the mouse scroll while using this form - this
has the effect of starting a new record.