I had a form based on a query and did some revisions to the underlying
tables. I've reset all the existing relationships, but now every time I try
to add a new record I get the Access error 3164. There is no one else using
this database as it isn't in production yet and I've ...

I have 2 combo boxes on a form with the relevant information being displayed
in the subform. The selection in the 1st combo box restricts the value in the
2nd combo box and also restricts the data in the subform. Perfect.
My problems arise when I select a value in the 2nd combo ...

I have a number of questions that need responses to be entered at certain
points during a process. I would like to have a checkbox for each question
positioned under 'seperate columns' depending when in the process the
question needs to be addressed. I have used a continuous form ...

I am using the "Application.FollowHyperlink strFilePath, , True" line
of code from within access forms to launch any file type I want
(e.g.,
xls, doc, pdf, etc.).  The files open up okay, but open up in the

Hi Gurus :-) I have a MS Access database that is very sensitive and
therefore i have disabled the Shift Key but still if someone knows how
to enable it back they can enable the shift key back.
My requirement is to permenantly disable the shift key so nobody even

I have a text box on a form that displays a custom counter.
However, like many people that deal with multiple records, sometimes
the counter loses its place.  For example:
Records 1 through 5 are numbered as such, but say you erase record 5

I would like to have the field on my date entry form change to a specfic
color after data is entered. Right now all the fields background are white. I
would like them to be light green, for example after data is entered and
saved.

I have got a database. I have created a form from an existing table.
I want to send out the form via e-mail so that the customers can fill in the
details and then when they send it back to me I can easily update my table
with the new information?

I have a form with one main field at the top [name] then I've use the
tab-control to create many "pages" on the form.
I need the [name] field to be frozen so users can't change it, so I set the
text box property locked to "Yes".  The problem is that when I open the form

I have 2 check boxes on my form.  One is "projection" and the other is
"actual".  When doing data entry the user must check one or the other, but
never both.  How do I accomplish that?
Thanks!

I need to have the state already in forms every time the are filled out.  I
have it on my form as a blank text box.
I tried putting in the default of the properties like I did on the table,
but it did not show up in the form view.

Is it possible to activate the advanced filter/sort command from a button?

Hello,
Someone might have asked this question before..but I'll go ahead and ask
anyways.
Is there a way to make a different subform open depending on the selection  

You may think this is not pretty (and it isn't) but I have to print forms
instead of reports, so things get messy. I know forms are not meant to be
printed, but I've got to work with what I've been told to do. I've worked
around most of my problems, but this one sticks out.

Using Access 2000
I'll try to make this a short post, but any help would be appreciated.
I have a form, bound to a table, that allows the users to lookup an
employee.  Once they are on the correct employee, they then enter time/