I have a form that has 2 text boxes with information that can be entered by
the user to locate all of the client information.  (Client ID, Client SS#)
The user enters the information and the form is updated with all of the
client information and opens a subform with all of the ...

I have a field called TIN that has to be 9 digits long.  How can I enforce
this on the form?  I tried the input mask but the "_" is annoying the users
because sometimes their cursor isn't at the beginning of the field and they
need to fix their data entry.  Is there a better way ...

Greetings All,
This website has been so helpful in my designing the database for my Internal
Audit Department but I have one problem that has been driving me crazy for
the past 2 weeks and I now want to seek your assistance for I haven't seen

I have 2 tables that are attatched by a one to many relationship. What I am
wanting to do is be able to pull up a person(my one table) by name and date
of birth, once they are pulled up, I want to be able to enter a test for
them(my many table) and then save. My question is would ...

Not sure if i'm being a complete idiot but I've created a form which is
based on a parameter query.  I've embeeded a subform which is also based on a
query.  Using the main form we toggle between clients records updating the
subform, however We would also like to alter the value ...

i've added a combo box that looks up fields in my organisation table i want
the user to select an organisation from this box and the organisation ID
field to be filled in the Organisation id field in the form?

In the form I have I would like to add a button that clears a specific field
in all the records of a table. How can do I create this?   Thanks... Joe..

I am trying to improve the design of my database.  At the moment I have a
form that displays information for a clinic. This form has buttons that
display information for other clinics (the information fields are the same;
patient name, dob, etc) but the records are different.  At ...

i need to update alot of records from a form.
for now i'm using recordset to loop the records and update the relevant
but when there is alot of record,its taking 4-5 minutes until its been
updating the table.

When I open a form in edit mode I want the Last Record to be shown as the
default.
Currently, the first record is shown.
Can this be done?

   I have to print access reports in acrobat distiller but it is not
my default printer.So when i use docmd.openreport the report is fired
on some other (default) Printer. I cannot change the default printer
settings. So how do i fire the report so that it uses acrobat

I have a form listing people.  On the form there is a start date and end date
[enddate].  The form is sorted such that first are the folks with null end
date, then everyone else.
I would like to add a button to quickly jump to the last 'current'

I would like to edit my form so it will only allow users to enter and save
records but not scroll through them and accidently delete them. Is this
possible?
I.e can i delete the scroll on the bottom of the form with all the table

"Call Summary" and "Call Details" are sub forms.Call Summary(datasheet view)
displays the summary of the calls made and Call Details(single form view)
should display the record selected in the Call Summary in detail.
I would like to display the details of the record in Call ...

I have a form with a sub-form containing a Memo field. (Data already added in
BD) I now want to change the size of my Subform (smaller in width) and would
like the existing data to "word wrap" but it does not.  Is this possible?