SEARCH BUTTON

P

pradeep_siemens

Hi experts
I am extremely new to access, but i have managed to create a database myself
and have created a data access page through it. I just want to have a search
button in the page. Which i did using the toolbox option? I am badly stuck up
when I wanted to create a programme for the search command button. i am a
worse at VB, I would be glad if some one helps me to derive the code for the
search button. And also do help me where and how to enter the code for that.
i don’t mind sending you the supporting documents to your e mail id
]
thanks in advance
pradeep
 
P

pradeep_siemens

hi jack
Thanks a lot for your reply i have been scraching my head for past 2 months.
i did went through the website. i was able to get a part of info what i
needed. by the way if i sene a demo document to your mail i d will you be
able to help me out.
pradeep

Jack said:
There's a number of different ways to handle this. Allen Browne keeps a good
example in his site. You may want to download the sample and analyze it, and
see if you can make it work for your scenario.

http://www.allenbrowne.com/ser-62.html

hth
Hi experts
I am extremely new to access, but i have managed to create a database myself
Click to expand...
[quoted text clipped - 7 lines]
thanks in advance
pradeep
Click to expand...
Click to expand...
 
J

Jack Leach

Unfortunately, for security reasons, I try to avoid accepting executables of
any sort from people I don't know (no offense... better safe than sorry).
Also, it is recommended to try and keep everything within the newsgroup so
others can benifit from it is well.

What kind of interface would you like? Some people use an unbound textbox,
and filter the results as values are typed in, or you can have it filter a
value when a button is clicked (which I'm assuming you'd like to do here).

If you could advise your ideal plan, as well as some information on the
interface (are the records on a subform with the button on the main form, or
do want to click a button to have a pop search form to restrict mainform
records?). Some more information on the setup will help us guide you in the
(hopefully) right direction.

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
P

pradeep_siemens via AccessMonster.com

hi jack
i am new to access but with some guidance from various sources on net. i
built a search form as in the below link
http://www.datapigtechnologies.com/flashfiles/searchform.html. once tried the
run command a pop up box displayed stating
" enter parameter value" also providing me a text box to enter value . when i
tried cancelling it i showed me an error in the vb programming.
Private Sub Command21_Click()
DoCmd.OpenQuery "mainquery", acViewNormal[/QUOTE]
End Sub
i tried debugging it but unsuccessful.
Please do help me out
 
Top