I'm needing a option (calendar, combo box, etc) that allows user to select
the month/year.  I tried to use the calendar, but couldn't get it to not show
the days. I then tried a combo box looking at the date in my records and used
datepart to extract only the month, then grouped ...

I have a datasheet on a form that I will be entering numbers on from my
keypad.  Each time i enter a number, I hit the Enter button on the keypad to
enter a new number.  By default the cursor moves left.  I don't want to
change the default...I just want that action when I'm in ...

I have an option group of four radio buttons:
Section 1
Section 2
Section 3

Is it possible to create a text string of column data?  For example, in
[table1], I have a field [field1] that can have "x" amount of records.
[field1]
a

I have two questions.  They may be so simple that no one ever asked, because
I can't find it in the post.
Firse, I have a form that displays information only. I have a print button
on it that prints a report that matches the form's information.  The problem

Why is the LostFocus event not working.  Nothing happens, I am able to click
in any other control I want.  I tried the Text21_Exit event and it did not
work either.
Private Sub Form_Load()

I have a textbox on a form where =DSum("Amount","TreasurerDeposits") returns
the sum from a table...it works....why can't I do this for a query?  What do
I do to get total from query....is there any SQL that will do it?
i have a subform showing records from a query and I want a ...

I have a form bound to a table in A2003. When the user wants to insert a new
record, I want to set one of the fields to a certain number (similar to
autonumber). I tried setting it in the Before_Insert event, but the event's
not fired until the user types in the first character ...

I have looked through the posts, but haven't quite found an answer to this. I
have a database where separate copies will be used by different people. When
they first begin I would like an easy way to ask them for some text or
numerical values that will be used from that point ...

Hi
I have a form containing a combo box that contains department names and a
text box containing a value that is linked to the department via a department
table.

My main form is quite tall as most of my users have large screens. On
smaller screens however it must be viewed using scroll bars.
This is fine but when the form loads it always displays the form half
way down and the user cannot see the top of the form without manually

Is there a way to check when clicking on a button in my form that it check
if a specific Excel document is open if yes then close that document only? I
know there is way to close Excel but that closes all Excel documents open but
I just want the specific to be closed and not all ...

I have a form that displays a single record's data.
On Form_Load I check that all the data is present for this record (as
we have legacy data) and then issue a msgbox that tells the user that
something is missing and please fill it in.

I'm receiving #name? on a subform on a subform in Access 2007.
The subform on a subform works great in Access 2000, 2002, and 2003.
Any idea where I can go to fix this?  It's not an invalid name or anything
like that.

I have a form with memo fields and it contains a subform with buttons to
insert boilerplate text into the fields in the parent form.
If the button were in the same form as the memo field, this code would work:
Private Sub Command1_Click()