Hello, I designed a database with a data entry form which includes a supplier
field and a supplier ID field.  Is there a way without writing code to enter
an ID number in the ID field and have the appropriate supplier entered
automatically in the supplier field?  Thanks.

I've added an ms spreadsheet 11.0 activex to my form and want to get data
into a specified cell(s) when a button is pressed.  Click a button and a4 =5
or b7 = "howdy". Does anyone know how you would get data into a cell (not
entering it directly)?

I have created an access database form and when I tick a box in one record,
it automatically ticks that box in all records.  I dont want it to do this.  
How do I change it?

Can anyone tell me if it is possible to use a checkbox that has three
possible answers vs two?  What I'm looking for is a control that will allow a
user to check either, yes, no or n/a.  I've also tried do do this with
grouping but no luck.  It doesn't matter if it is a checkbox or ...

Can anyone see what the problem is with this and hopefully assist.
=IIf([tblStaff.Type]="Wages",[total]*[ComAx],0) Or
IIf([tblStaff.type]="Commission",[total]*[commissions],0)
Thanks

I was using the method Date() to bring up a default date.  I since had to
move to another workstation and now all fields that should display today's
date now display NAME?  
Can someone tell me what is causing this problem.

Whenever I try to use the Documenter facility in an Access database I get an
error message "Invalid procedure call or argument" no matter whether I am
trying to document a table, query or report and irresepctive of the selected
attributes which I choose. Any ideas anybody?

Keeping it simple. I have a continuous form. I want to make the record that
has condition X blue, and the record that has condition y green. How do I do
that?
Thanks

I need a template that has a narrow left column, a line going down the page
and a wide right column.  I want to be able to type, flow easily between the
2 columns.  Back and forth as I do questions and answers. How do I make this??
Please.

Is there some way I can make the calendar page bigger? I want to use it on a
touch screen - and the standard one is a little too small.
I use the Calendar Control 11.0 that can be selected on Toolbox menu when
pressing "More Controls..."

I have a form [frmEvent] based off of a query to run a report.  I want the
user to select an event, and then the start and stop date before clicking the
"Run Report" button.  The event portion works great using a combo box. In the
query I entered the following criteria:

This is my first database.
My primary key that links the table is a number.
When I am entering data, the primary key field changes to "0".
I changed the properties of the primary key to no default, but I still have

I have a dozen or so Yes/No fields on the form.  Many times I'm selecting yes
for many field at a time is it possible to select something else and it will
turn multiple fields to yes or even all of them?
Thanks...

Simple question: I have eight textboxes on a form which I wish to be
disabled by default, but which can be enabled for input by means of a toggle
button. How would I go about achieving this?
Your help would be greatly appreciated!

Okay, so I built a form with five subforms (because I couldn't get the form
to accept merging fields into one form - the relationships got confused).  
So, it all seems to work; except, after inputing the data, when I try to add
a new record (with the arrows at the bottom of the  ...