In the Northwind Customer Order Form, if you click OrderID, advice appears in
the bottom of the screen (not sure what this area is actually called). It
says 'Unique order number'. I find this useful guidance for the user but
wasn't sure how to implement it. Any ideas?

I have database with 15 forms. 2 out of the 15 forms are the most heavily
used and somewhat more complex than the other forms. Every so often when I
use the forms or go into the design view and make changes, the forms seem to
dissapper but are sill listed in the Database Window. ...

How do I create code that will enable me to hit enter on an item in an
Unbound Combo box drop down list, such that when I hit enter on that
particular item, it opens the related form?
Thus far, I've tried If ... Then ... Else statements, with 'DoCmd.OpenForm

hi i am yaros.

I have two combos that can be used to find a record and open the Order form -
one looks up the Ref and as an alternative the other looks up the Name.
Let's say I use Ref first and enter 8002 - order 8002 is opened, fine.
Then I want the order for Johnson so I enter that in the Name ...

I am building a database where I will be tracking meetings attended by our
employees.  I have a list of about 75 people.  I need to track the date,  
type of meeting, who held the meeting, and the people who attended.  I have 2
tables called employees, which contacts ID, and ...

I have developed two database applications with Access 2007. I have used the
package wizard and created setup.exe files.
The problem is, I can't install these two applications in the same machine.
Once I install one application, when I try to install the second one I get a

I just started with access so I am access stupid. I am setting up a database
for training aids and have several tables. Tables consist of a training aids
table, dealers table, personnel table, shipping table, then a main entry
table. The idea is to be able to track training aids. I ...

I am developing an Access 2007 database to generate name tags.  I would like
to include a watermark image common to each name tag.  I can include the
image but can't seen to convert it to a watermark.

create a combo box that gets its rows from a VB Function

I have a form with a list box. One of the columns in the list box is a number
that has a format of Currency in the underlying query. In the list box
however, it comes up as just a number. Is there a way to get it to appear as
currency?

I have some people the enter their names as Mary "M" Smith when this is
entered into the system it goes in fine but when I try and select it out it
gives me an error because of the "M". What's the best way to handle this type
of entry?

I have a form that displays in tabular form a table.  The form footer
contains a textbox that sums the 'amount' field.  I want to add another
textbox that displays the sum of the 'amount' of a query of records where
another field is queried.

The query below is set up as an Access view.  When I run it from views, it
returns 77,155 records.
SELECT   TOP 100 PERCENT CC.dbo.inv_mast.item_id,
    CC.dbo.inv_mast.item_desc,

Access 2000, switchboard created with the manager.  I added an item (entry,
button, whatever) to a menu within the switchboard.  Still within the "Edit
Switchboard Page" menu, I try to move it up in the list (with the Move Up
button), and at a certain point it disappears!  For ...