can you get rid of navigation buttions for a datasheet?

  • Thread starter Thread starter djc
  • Start date Start date
D

djc

1) I have a subform that is just used to show a list of items (one field).
Its source is a query. I don't want the nav buttons to be there? Can I get
rid of them?

2) I have the source of a subform set to a query. Can I use the FilterOn
property to filter that source further on the fly based on user actions?

Basically I'm looking for a nice efficient way for a user to be presented
with a large list (potentially thousands) that they can sort and filter in
various ways to obtain their 'subset' of records. This subset of records
will be added to a list. So, more basically put, I need a good way for a
user to build their own list of items from one master BIG list.

any suggestions?
 
1. Use the DatasheetView of a Form where you can set the Property
NavigationButtons to No.

2. Yes. Set the Filter String of the Subform and then set FilterOn (of the
Subform) to True.
 
clarification:
when I said subform below I actually meant 'subform control'. I have a
subform control with the 'source object' set to a query. So I did not see
the same properties (like filter and navigation buttons) as I normally do
for a form.

1) So you are saying I should bind the query to a form and make that form
the 'source object' for the 'subform control'. Is that correct?

2) Number 1 makes sense to me. But I was wondering if I could get the same
end result just making the query object itself the 'source object' for the
subform control. This seems like it would simplify things. Do you know if I
can?

Thanks for the reply!
 
See in-line.

--
HTH
Van T. Dinh
MVP (Access)



djc said:
clarification:
when I said subform below I actually meant 'subform control'. I have a
subform control with the 'source object' set to a query. So I did not see
the same properties (like filter and navigation buttons) as I normally do
for a form.

1) So you are saying I should bind the query to a form and make that form
the 'source object' for the 'subform control'. Is that correct?
Click to expand...
Yes. Use the Form Wizard to create a quick & dirty Form based on your
Query. Set the Default View to Datasheet and set the Navigation Buttons to
No.


2) Number 1 makes sense to me. But I was wondering if I could get the same
end result just making the query object itself the 'source object' for the
subform control. This seems like it would simplify things. Do you know if I
can?
Click to expand...
Not AFAIK since you cannot control the appearance of a datasheet.
 
Thanks for the info!

Van T. Dinh said:
See in-line.

--
HTH
Van T. Dinh
MVP (Access)




Yes. Use the Form Wizard to create a quick & dirty Form based on your
Query. Set the Default View to Datasheet and set the Navigation Buttons to if
Not AFAIK since you cannot control the appearance of a datasheet.
Click to expand...
 
Back
Top