Search Data Access Page by Letter???? How ???

[Guest]

I am a complete NEWBIE at Access 2003. I have created a database and a Data
Access Page to look up the data. But how can I make it look up our members
by letter or name instrad of page number by page number in Data Access Page ?

 

[Guest]

May I suggest, as a new user to Access, that you use a form instead of a Data
Access Page? The reason I say this is that Data Access Pages (DAPs) have been
deprecated by Microsoft in Access 2007. So, do you really want to spend time
learning this technology, only to find later on that you can only create and
edit your DAPs in earlier versions of Access (they still work in A2007, but
you cannot create or edit them).


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Here's the problem in detail... I am helping to manage a Karate School.
Neither the owner nor his wife are technically saavy AT ALL !! The wife is a
busy body and gets into things ALL OF THE TIME. With the DAP, I can give her
access to search the records without the threat of her deleting or changing
anything by mistake. The last time I let her have access to Excel, EVERY
student was named Bryan M. All 103 of them !!! Is there any way else that I
can do it ?

 

[Guest]

Sure. You create a switchboard form that opens at startup. I prefer using
unbound switchboards, not the bound style that the switchboard wizard
creates. You allow your users to only open forms and reports. Hide the
Database Window, disable Use Access Special Keys (Tools > Startup options),
remove the standard menus and possibly even disable the Shift key.

Create your own QBF (query by form) search form instead of letting the user
use the built-in Find and Replace, since you cannot restrict this built-in
method to Find only. You can also convert your .mdb to the compiled .mde form
to help prevent unauthorized changes to the structure of the database.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Sure. You create a switchboard form that opens at startup. I prefer using
unbound switchboards, not the bound style that the switchboard wizard
creates. You allow your users to only open forms and reports. Hide the
Database Window, disable Use Access Special Keys (Tools > Startup options),
remove the standard menus and possibly even disable the Shift key.

Create your own QBF (query by form) search form instead of letting the user
use the built-in Find and Replace, since you cannot restrict this built-in
method to Find only.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thanks !!! Since I am brand new, I hope you will be there and available for
me with the HUNDREDS of questions that i'm sure that I will have !!! Speak
to you soon ?!?!?

 

[Guest]

I'll be here, as will many other capable people who are regulars in this
newsgroup.

I suggest that you start your journey by learning some about naming
conventions, reserved words (avoid using these in anything that you assign a
name to in Access), database design (a *very* important topic), etc. You are
welcome to download a zipped Word document, which I call Access Links:

http://home.comcast.net/~tutorme2/samples/accesslinks.zip

For the present time, concentrate on the first four pages only.

Happy Learning!


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________