How can I close a form with required fields without the msg box popping up
to enter required fields.
I do not want the user to have to hit the escape button.  I want the form to
close without msgs.

I have a question to pass a list from either a table or query.
I have a list of departments for example and I want to pass these (sorted by
Category(Div#) and Dept#) so I dont have to enter them in the subform.
Presently I have the following tables:

SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]

I am new to SQL Server and I'm trying to create a parameter query in the View
folder in SQL Server. I used @name as well as  a ? mark for the parameter,
but I continue to get a message stating that "'Parameters' cannot be used in
this query type."

I am trying to construct a report that sorts records based on
departments in the organization.  Each department code is a letter and
a number, like B1.  However, each department is divided into
divisions, whose codes are the Departments plus another number, like

Is it possible to align one column right then the next column left in a drop
down list?
Thanks for any ideas on this......Bob

I am trying to create a relationship, using Tools >> Relationships, &
keep getting this error message. I am trying to link table
TM_CampaignCustomers with TM_CompContact. TM_CampaignCustomers has as
its primary key field TM_CCID. TM_CompContact has PK_Contact. Bothe

I love that you make discussion groups available, and use the one for Access
a lot, but I would like to be able to sort items in a category by date, and I
don't see able to.
Could you either tell me how, or add it if it is not available?

I am a newbie at MS Access programming.  I have 5 subforms on
different tabs all based on a single table.  When a record is edited,
selected (or added) on subform1 -  frmSubTaskOrder, I would like the
same record to be selected when I move to subforms2-5 eg

Hi, my data looks like this:
iss_id    fld_title                icf_value
1327    Next Actions    Review with team and close ticket
1327    Co-Assignment    -1

I would like to be able to set the default value for Allow Zero Length to
True.
For the vast majority of cases I do not was this value set to False but that
is the default.  I end up having to go through manually and setting the

I have designed a database for members of our organisation with tables,
queries, forms, subforms, graphs etc.  Our members are independent and we
have no say over their IT systems and so i need the database to work on
Access 2000, 2003, 2007.

I'm in Design view trying to add new controls to my form.
I double-click the control on the Toolbox and drag it to my form.  When I
release it I get a popup dialog box that says "Cannot find project or
library" with Ok button the only option.  And it does not add the control.

Does anybody have any experience on how to get an Access report to
staple the pages in a group together? Is there an API in the printer
driver?
Regards

Access 2007
Hopfully, there is a way to change this default directory.
The last used directory, does not have the permanency I would like
but, is much better than MS's attempt to force all users to begin in a