I'm testing the use of an Access XP front-end (FE) with an SQL 2005 back-end
(BE) and I've encountered a minor issue which didn't occur when it was an
Access FE / BE.
I have a form bound to a query with multiple "joined" tables, all of which

I have a form that I set the property "modal" to YES. Once I set it this
way, I cannot minimize the Access window. I still can minimize the form
itself. Is there a way to minimize the Access window when I click minimize
on the form?

I have a table (and form) that shows a list of business opportunities with
fields such as Program Manager(LastName,FirstName), Expected Funds, Start
Date, End Date, etc.  This table and form are titled "Opportunities".  I also
have a table and form that lists the various Program

Using Access 2007.
I have a split form where one of the fields is a (deliberate) different
font; but for some reason the font will not show up as such in the datatsheet
view of the split form.

I have multiple forms set to view as Continuous. Most of the time the forms
only display the control box when opened. The header, detail and footer
sections are not displayed. However, you can usually manually resize the form
and expose them, but not always. It doesn't seem to ...

i have using access to do a pivot chart. but now i want to change the legend
name. how i can change it? because when i click the legend on the top at the
ribbon there. it will generate a name and i want to change it. anybody can
help me? thanks!

I have a form that has a sub form.  When I close the form, I get a prompt to
save the sub form.  I also used to get the prompt to save both the form and
sub form when I closed that form, but added the acSaveNo to the Docmd.Close.
However, that does not stop the prompt for the sub ...

Here's my scenario. See below
******************************
1. Make a macro where:
  Macro Name = Insert Hyperlink (or whatever)

I would like to create a macro for a command button that can do the following:
Go to: Tools\Security\User and Group Accounts
Once the "User and Group Accounts" windows is open, I want to open the
"Change Logon Password" tab.

Good day all. I'm having trouble with my database. I'm not sure whats causing
the error but the error msg that pops up is: "The table 'Spares - Office' is
already opened exclusively by another user, or it is already open through the
user interface and cannot be manipulated ...

I have list boxes on a form for users to choose criteria for a second form.
I have the following code in the On Click events of buttons for each list box:
Dim varItem
For Each varItem In DamageReason.ItemsSelected

Is there a way to open the results from the filter in datasheet view or any
view that allows me to copy the results? I have an email address field and
need to be able to quickly copy them from the filter results. I know I can
change it from Form to Datasheet view once I run the ...

I create and open an Excel spreadsheet from Access. Excel opens behind Access
window. How do I open the Excel spreadsheet so it's in front of Access window?
Thanks.

I really love Vista Aero. It makes me happy. Its all smooth and shiny.
What could be better?
Maybe aero, with customizable appearances

I have a replicated database that I would like to transfer from 2000 to 2007.
This database has many customized macros and forms.
I have created simple databases in 2000 and opened them in 2007 with no
problem.