Access 2000 questions

[Yeah]

A while back, I posted a set of Access 2000 questions in relation to my Home
Inventory Database. I give thanks to the individuals who were able to help
tune up my database to my needs. However, I still have remaining issues.

1) When I open my database (from the desktop, for instance), I just want the
database window itself. Not the Access menu screen that pops up. Is that
possible, and how do I do it?

2) I'm still confused as to how to sort my records automatically. I'm
looking for an alphabetical sort order on two fields: Category (drop box),
*then* by Item Name (text box).

3) What is the vertical bar along the left side of my form screen with the
right pointer on top? Do I need it? If not, how do I remove that as well?

Any information is much appreciated. Thanks!

 

[Arvin Meyer [MVP]]

Answers inline:

A while back, I posted a set of Access 2000 questions in relation to my
Home Inventory Database. I give thanks to the individuals who were able to
help tune up my database to my needs. However, I still have remaining
issues.

1) When I open my database (from the desktop, for instance), I just want
the database window itself. Not the Access menu screen that pops up. Is
that possible, and how do I do it?

After your database is opened, go to Tools ... Startup and specifiy your
startup form and uncheck "Display Database Window"

2) I'm still confused as to how to sort my records automatically. I'm
looking for an alphabetical sort order on two fields: Category (drop box),
*then* by Item Name (text box).

Write a query that sorts your records. If the order of fields to display
does not match your preferred sort order, add the fields again in the order
you want them to sort, turn on your sort order and uncheck the show box.

3) What is the vertical bar along the left side of my form screen with the
right pointer on top? Do I need it? If not, how do I remove that as well?

The bar is more useful in datasheet and continuous forms. You can turn it
off in the form's property sheet in Design View on the Format tab, select
"Record Selectors" and set it to No.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Joseph Meehan]

A while back, I posted a set of Access 2000 questions in relation to
my Home Inventory Database. I give thanks to the individuals who were
able to help tune up my database to my needs. However, I still have
remaining issues.
1) When I open my database (from the desktop, for instance), I just
want the database window itself. Not the Access menu screen that pops
up. Is that possible, and how do I do it?

I am not sure exactly what you are talking about.

2) I'm still confused as to how to sort my records automatically. I'm
looking for an alphabetical sort order on two fields: Category (drop
box), *then* by Item Name (text box).

Create a query and sort on those two fields with the field you want
sorted first to the left of the other.

3) What is the vertical bar along the left side of my form screen
with the right pointer on top? Do I need it? If not, how do I remove
that as well?

In display or design view?