I created a form and link to a table.
How do I link the table records to a grid for display, add, delete and
modify?

I have a field on a form which requires a date of birth in the (British) form
31011970, or the field to be left blank. I have tried putting validation
rule: like "????????" or null, which works as far as it goes, but I would
like to make it more sophisticated, ideally a valid ...

I have a columnar form with tabular subform.  The data was all imported from
Works and therefore some of the fields have a great deal of data.  In the
tabular subform I would like to keep the boxes with just first row of data;
i.e. small, but be able to show all the data in a ...

I have a couple forms with subforms on them that are basically quick view
info only.  I don't want anybody to enter information on the subforms or
alter the subform in anyway.  However, the subform only shows so many
records.  I still want the user to be able to scroll down the ...

I have a question.  Sometimes when I open a form using VBA code and then
type in "docmd.maximize" to maximize the form screen -- sometimes the "X"
disappears.  Does anyone know why this happens AND how to fix it?
Thanks,

   I have a form that accesses a table.
   On the form is a Yes/No checkbox (from the table).
   I want to be able to lock all the other fields in the record (or just
lock the whole record) by clicking the Yes/No checkbox.

I have a dbase in Access 2003 SP2.  It started to crash and I recreated the
master by importing everything and then recreating the tables through a make
table query.  Some of the forms didn't look the same and some of the forms
did not retain their code (expressions connected to ...

I would like to have a message pop up when data is changed in a form with the
action to follow.
I know it has something to do with the property of "On dirty"
If any control is changed in the "Employee" form is made, I should receive a

My main form links to Invoice table:
ID
InvoiceNumber
Date

Good morning,
I have Access 2003.  I have a problem which I'm going to simplify in order
to explain it.  I have three forms named frmNewTickets, frmOpenTickets, and
frmAllTickets.  

Using Access 2000:
I need to add Client firms and their Salesmen to Clients and Staff tables.
I created form frmAddClient, where I add the information and two phone
numbers for the Client firm.

Hi,Im beginner of MS Access.I've dificulties in creating a form.
I have tables which are:
tblRoom(IDRoom,NoRoom,IDBlock,IDType,IDPrice,Occupied,Notes)
tblBlock(IDBlock,NameBlock)

i have a field called status, which can have a few different values, eg.
"Pre Planning", "Planning", "Plannning Appeal"
i want to use conditional formatting on a continuous form to say that if the
[STATUS] field contains the word "Planning" the backcolor will show as

When I run my main form I found there is a left vertical grey bar.
How do I get rid of that?
Thanks

I have a table "Master" with the following fields:
Master_No
Date
Name