Hello - I'm new to Forms.  I created a query pulling data from multiple
tables/queries and including some calculated fields.  I want to show the
results of the query in a form AND allow a user to update two fields in
tables that were used in the source query.  When I create the ...

I have a form called [Transactions] that has a subform [Transaction Details
Subform].  I would like a form called [Entry Form] to open when I click on
the [ID] field of the [Transacion Deatails Subform].  Here is the code I have
so far, but when I run the code it ask's me for ...

I have a database to which now for some unknown reason (probably really
simple) it no longer allows me to add a new record on  the form, only the
table. I have AllowDataEntry set to yes and I dont recall changing any
properties. Is there something I am overlooking or why would it ...

I am using the Lebans MonthCalendar. Instead of using the textbox
double-click event to open the calendar, I would like to use a bitmap
graphic (image control) of a calendar I created. However, there seems
to be a problem where after opening the MonthCalendar form, the window

I have a form that our Lab Director enters info on, but I am struggling with
two items.
1)  I have a drop down list that our director chooses the dr # from.  
However, sometimes he types in his own number, which that number is not in my

I have a list box that you can select a group name from.  When you click
print preview I then have a Graph (that is fed by
qryGroupSummary_AreaSummary) that should display only the group that was
selected from the list.  Below is what I have so far.  In Debug everything

What I have been using until today: a spreadsheet-like table containing
several dozens of fields, all Boolean (yes/no data type) + a form with
checkboxes linked to those fields (one checkbox + label for each field). Each
record represents the answers of one respondent to the ...

This is a rather trivial point but I was wondering if there was a way to
format an input make to capitalize the first letter and leave the rest
untouched. I know I could program something in afterupdate like
upper(left(textbox,1))&mid(textbox,2,99) but I just want to use the mask ...

Is there any way to control the switchboard so that only specific users can
see a specific option on the switchboard?  For example, if the user is part
of the Admin group, they can see the switchboard option that opens the
Password Update page for all users, where a user who is ...

I have created a pivot chart which consists of 4 sales areas by month, I
have displayed this as a stacked bar chart, however, I would like to see the
sales areas with the higher volumes at the bottom of the bars and the areas
with lower volumes at the top of the bars, each month ...

I have a form and a report.  I want to send the report to a person name that
I have on the form. How can I get the database to use that name in the text
box to send the report for that certain record.

I tried to post this earlier, but I don't see it out there, so I apologize if
it's up twice.
I'm developing a database which was working quite well when suddenly, I
can't open many of the forms.  It seems that the affected forms are ones that

Does anyone have a code resource for determining the actual used width
of a form?
I would like to know the minimum width that a form can have without
hiding any of it's controls/subforms.

I am using Access 2003
I created a db with a main menu form in which the users can pick the forms
and/or reports they want to see.  Currently, when you click on a buttom, you
are asked to enter a name or a beg/end dates, depending what you are opening.

To the Microsoft MVP professionals!
I have a big serious problem, please help!
I already posted this problem on 03/05/07, Allen Browne responded, thanks I
appreciated.