MS Access

[EJFan]

hey... 'puter dudes...

anyone have a clue if there's a FREE plugin for access (from MS or elsewhere) that will allow forms to include an alphabet tab?

i have an access database with 3300+ records in it and my life would be greatly improved if i had a set of tabs so i could quickly go from "A" to "M" and so on by clicking on the appropriate letter. i've seen this in cheaper databases but can't seem to find anything for access.

any ideas?

 

[Blindinthedark]

That's a lot of tabs.

Are you doing a search for (in your example) all "M's" by clicking on the tab from a starting point of being on the "A's"?

I'd say to make it easier create a querry and run a button that calls the querry.
For what ever field you are searching for enter in the CRITERIA field of the querry editor ... [enter letter: ] . Make sure you have the square brackets around your question. The querry will then search for what ever letter you want.

It's faster and you won't have lots of redundant code that you would with the tabs.

 

[ultra99]

Yes I have done this using a custom FORM using a group frame with TABS.

On each tab click you would need to requery to return a recordset fitting you new filter specs.

 

[EJFan]

Yes I have done this using a custom FORM using a group frame with TABS.

On each tab click you would need to requery to return a recordset fitting you new filter specs.

come again?

can you explain this like you're explaining it to a 4 year old? i use access regularly but i'm not super-proficient with it. sad but true.

 

[silverwhisper]

EJ:

what he's proposing is instead of the alpha tabs on the form you're designing, insert a button that calls a query. the query could simply do a lookup on your table, sort your results--heck, have it request a text string before it runs.

ed

 

[ultra99]

There is a form design component called TAB frames.

But as silver suggested, I think buttons would be easier.

If you want I will work up a little demo for you.

Do you know VBA at all?


Oh, and no, I do not think I could ever explain it to a 4yo

 

[Blindinthedark]

If you really want to do your thing in tabs you will have to build 26 querries. One for each letter.

Build your main form but instead of calling the table directly call the one of the querries instead. Save a form for each letter of the alphabet. That's pretty easy, just save the form with a new name and change the recordset to reflect the new querry.

Build new form set up for tabs. Set up 26 tabs. On each tab call one of the forms you've created.

It's a pain in the ass and the button will be easier but what ever floats your boat.

 

[EJFan]

ok... i follow now.

thanks for the information. no need to run a sample, ultra... i appreciate the offer though.

i'll put this through the wringer and see if i can make something explode.