Tick Boxes and their powers...

[Bloodrayne]

Hello all,

Be gentle with me - its been a while since I used Access, but have now been asked to update someone elses Access database at work, and to add some new features - I can remember most aspects of what goes where, I just have a few queries about some of Access' other features (if it has them that is)

So, three questions - which I shall expand upon further if need be:

When designing a form - is it possible to have a tick box hide/reveal hidden fields/records?

In reports - is it possile to use a tickbox to exclude items from the report? (In this instance, there are two dates - and if the box is ticked I want the reports to use one date, and if not for it to use the other)

Last question!

There's three statuses for this particular part of the form (High/Med/Low) - is it possible to fit them all into one field (wherein clicking on the high button would report that it was high etc) - or should I go for three seperate fields?

The last one, I think... my mind recalls something about macros? But that could be Excel again... it's been a long long time...

Sorry if I appear confuddled - it's most likely because I am...

 

[mcadle]

With Access you can do everything that you have asked. There are macros in Access. Some people's opinion, myself included, is to always hard code the operation in VBA. This is sometimes out of scope for part-time users. These forums are usually very helpful. Most of the time a question has already been answered for a particular subject, all you need to do is search and read a little bit. Otherwise, there are some very dedicated and good posters (Pat Hartman, Rich, sorry if a left the plethora of you guys out, etc) that area always willing to help.

To answer your current questions, I think most of us need some more info. The table structure, the data, query structure, form and control names, etc. Provide us with that and we will see what we can do.

Good luck.

 

[The_Doc_Man]

When designing a form - is it possible to have a tick box hide/reveal hidden fields/records?

Absolutely. When I do this, I usually have an OnClick or OnChange event for the tick box. Inside the routine I sense the current state of the tick and make the appropriate items visible or not. (Property = xxx.visible; Yes/No)

In reports - is it possile to use a tickbox to exclude items from the report? (In this instance, there are two dates - and if the box is ticked I want the reports to use one date, and if not for it to use the other)

Yes, with the understanding that in THIS case, you need to do something a bit trickier. If the report is generated by a command-button action from the form bearing the tick-box, you can choose which of two different filters to apply to the report's report-name.Filter property, which is a string.

If the report is NOT generated by a command-button, you need a place to store the result of the tick-box change that persists until you open the report. Which means that the tick-box has to be bound to a field somewhere that the report can see in its OnFormat event.

There's three statuses for this particular part of the form (High/Med/Low) - is it possible to fit them all into one field (wherein clicking on the high button would report that it was high etc) - or should I go for three seperate fields?

Access calls that an Option Group. The group has the value of ONE and ONLY ONE of the Option Buttons included in the group. You select one of the buttons, the others are automagically deselected.

 

[Bloodrayne]

Good stuff!

My memory fails me on the coding side of things, I used to have some knowledge - can only remember the basics now...

I shall peruse the forums somemore and see if I can find answers that apply to my questions, thanks for the help so far!

 

[Bloodrayne]

Access calls that an Option Group. The group has the value of ONE and ONLY ONE of the Option Buttons included in the group. You select one of the buttons, the others are automagically deselected.

The options I have for my fields don't include the Option group, does it go under another name? I have Autnumber - Text - Yes/No, etc... But no sign of Options...I may be being dense though...

Ignore that... I've woken up a bit now.... Any further advice is still welcome though!

 

[The_Doc_Man]

The form's option group is stored in a table as an integer field, usually the smallest integer you can get away with.

Option groups are visual paradigms for choosing one of a fairly small number of choices. Usually three to five. After that, use a list box where the values DON'T come from a lookup table. That is another case where you are storing one of several possible values. Or use a combo box where you see one field from your lookup table but can store a different field.