HI Small query

[Anil showreddy]

HI,

2 Queries
1) i have crated one project in Access and from the "Tools----->startup" i
have taken "Switchboard" as a startup form i unchecked all menu bars and
items, now i could not able to open the tables and reports.
2) how can i do calcutaions by using the entered values like "quantity" and
"price"?
could you pls give me an indea for this?

Thanks and Regards,
Anil showreddy

 

[John W. Vinson]

HI,

2 Queries
1) i have crated one project in Access and from the "Tools----->startup" i
have taken "Switchboard" as a startup form i unchecked all menu bars and
items, now i could not able to open the tables and reports.

Ummm... that's what you asked for. If you turn off the database window and the
menus, then they won't be available.

You can get them back by holding down the Shift key while opening the database
or see the Database window by pressing F11. Before turning off the builtin
menus, you really should create custom menubars to allow you to do what you
want.

2) how can i do calcutaions by using the entered values like "quantity" and
"price"?

With a Query; you can put a calculated field in the query by typing

ExtPrice: [Quantity] * [Price]

in a vacant Field cell. Or, you can do calculations in the Control Source of a
form or report textbox.

could you pls give me an indea for this?

You may want to study some of the tutorials and orientation in these sites:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials