By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

setfocus and report creation problem

P: n/a
I'm creating a new databse and have a couple of problems I'd greatly
appreciate any feedback on.

1) I have an order form and would like to set it, so that when the form
is opened, the focus is set to my reference field and the find command
is executed prompting the user for the reference he/she wants to find.
I pasted the code from a Find command box i created, but cant work out
how to use the setfocus when the form is opened to go straight to that
field. The plan was to put this code into the onopen property.

2) Every order has an order type - there are about 5 types. When
creating a report I would like Access to count the number of each order
type within a certain time period. I've managed to create a query which
prompts me for the time period, but cannot get Access to count each
order type.
In case this is a bit unclear....:
If i have ten orders, 3 are of type A, 4 of type B and 3 of type C, I
would like a report to show
Type A - 3 Orders
Type B - 4 Orders
Type C - 3 Orders .........just simply counting the number of different
order types.

Can anyone help?

Jan 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.