I would like a search button that I or a user could use within a form to
locate specific records. Is this possible? I dont want other users in the
tables so it would have to be in the form or report.

Thanks

David

Yes you can.

IIRC you can use the button wizard in form design to create
a Find Button for you.

Alternatively you could code one up by hand. The wizard
should give you a good start though.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In news010E015-2B96-4F83-993E-(E-Mail Removed),
DDrowe typed:
> I would like a search button that I or a user could use
> within
> a form to locate specific records. Is this possible? I
> dont
> want other users in the tables so it would have to be in
> the
> form or report.
>
> Thanks
>
> David

Check this link for a search example on a form

http://www.databasedev.co.uk/text_search.html

--
\\// Live Long and Prosper \\//
BS"D


"DDrowe" wrote:

> I would like a search button that I or a user could use within a form to
> locate specific records. Is this possible? I dont want other users in the
> tables so it would have to be in the form or report.
>
> Thanks
>
> David

As a PS here's a search form from the Access Web
http://www.mvps.org/access/forms/frm0045.htm

And IIRC you can use the filter by form button from the
toolbar to do a Query By Example.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In news:%(E-Mail Removed),
Nick Coe (UK) typed:
> Yes you can.
>
> IIRC you can use the button wizard in form design to
> create
> a Find Button for you.
>
> Alternatively you could code one up by hand. The wizard
> should give you a good start though.
>
>
> In
> news010E015-2B96-4F83-993E-(E-Mail Removed),
> DDrowe typed:
>> I would like a search button that I or a user could use
>> within
>> a form to locate specific records. Is this possible? I
>> dont
>> want other users in the tables so it would have to be in
>> the
>> form or report.
>>
>> Thanks
>>
>> David

This is a great littly search form however I dont know enough coding to be
able to use it with an Auto number field instead of a text field. I know it's
probably quite simple however my MemberID is Autonumber so keep getting
errors.

"Ofer" wrote:

> Check this link for a search example on a form
>
> http://www.databasedev.co.uk/text_search.html
>
> --
> \\// Live Long and Prosper \\//
> BS"D
>
>
> "DDrowe" wrote:
>
> > I would like a search button that I or a user could use within a form to
> > locate specific records. Is this possible? I dont want other users in the
> > tables so it would have to be in the form or report.
> >
> > Thanks
> >
> > David

What is the error you are getting?

It should work with auto number also.

--
\\// Live Long and Prosper \\//
BS"D


"Badger" wrote:

> This is a great littly search form however I dont know enough coding to be
> able to use it with an Auto number field instead of a text field. I know it's
> probably quite simple however my MemberID is Autonumber so keep getting
> errors.
>
> "Ofer" wrote:
>
> > Check this link for a search example on a form
> >
> > http://www.databasedev.co.uk/text_search.html
> >
> > --
> > \\// Live Long and Prosper \\//
> > BS"D
> >
> >
> > "DDrowe" wrote:
> >
> > > I would like a search button that I or a user could use within a form to
> > > locate specific records. Is this possible? I dont want other users in the
> > > tables so it would have to be in the form or report.
> > >
> > > Thanks
> > >
> > > David

Runtime error 2465 Cant find field txtSearch in your expression.
Stops at ‘If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then’
My field is MemberID(Autonumber) which I first tried substituting for all
instances of Student because the field in the form is strStudentID - I
believe


"Ofer" wrote:

> What is the error you are getting?
>
> It should work with auto number also.
>
> --
> \\// Live Long and Prosper \\//
> BS"D
>
>
> "Badger" wrote:
>
> > This is a great littly search form however I dont know enough coding to be
> > able to use it with an Auto number field instead of a text field. I know it's
> > probably quite simple however my MemberID is Autonumber so keep getting
> > errors.
> >
> > "Ofer" wrote:
> >
> > > Check this link for a search example on a form
> > >
> > > http://www.databasedev.co.uk/text_search.html
> > >
> > > --
> > > \\// Live Long and Prosper \\//
> > > BS"D
> > >
> > >
> > > "DDrowe" wrote:
> > >
> > > > I would like a search button that I or a user could use within a form to
> > > > locate specific records. Is this possible? I dont want other users in the
> > > > tables so it would have to be in the form or report.
> > > >
> > > > Thanks
> > > >
> > > > David

Need to change the txtSearch to the name of the text box in your form that
you are using for the search

If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then
--
\\// Live Long and Prosper \\//
BS"D


"Badger" wrote:

> Runtime error 2465 Cant find field txtSearch in your expression.
> Stops at ‘If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then’
> My field is MemberID(Autonumber) which I first tried substituting for all
> instances of Student because the field in the form is strStudentID - I
> believe
>
>
> "Ofer" wrote:
>
> > What is the error you are getting?
> >
> > It should work with auto number also.
> >
> > --
> > \\// Live Long and Prosper \\//
> > BS"D
> >
> >
> > "Badger" wrote:
> >
> > > This is a great littly search form however I dont know enough coding to be
> > > able to use it with an Auto number field instead of a text field. I know it's
> > > probably quite simple however my MemberID is Autonumber so keep getting
> > > errors.
> > >
> > > "Ofer" wrote:
> > >
> > > > Check this link for a search example on a form
> > > >
> > > > http://www.databasedev.co.uk/text_search.html
> > > >
> > > > --
> > > > \\// Live Long and Prosper \\//
> > > > BS"D
> > > >
> > > >
> > > > "DDrowe" wrote:
> > > >
> > > > > I would like a search button that I or a user could use within a form to
> > > > > locate specific records. Is this possible? I dont want other users in the
> > > > > tables so it would have to be in the form or report.
> > > > >
> > > > > Thanks
> > > > >
> > > > > David

Sorry that was rather stupid of me! Many Thanks will try!

"Ofer" wrote:

> Need to change the txtSearch to the name of the text box in your form that
> you are using for the search
>
> If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then
> --
> \\// Live Long and Prosper \\//
> BS"D
>
>
> "Badger" wrote:
>
> > Runtime error 2465 Cant find field txtSearch in your expression.
> > Stops at ‘If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then’
> > My field is MemberID(Autonumber) which I first tried substituting for all
> > instances of Student because the field in the form is strStudentID - I
> > believe
> >
> >
> > "Ofer" wrote:
> >
> > > What is the error you are getting?
> > >
> > > It should work with auto number also.
> > >
> > > --
> > > \\// Live Long and Prosper \\//
> > > BS"D
> > >
> > >
> > > "Badger" wrote:
> > >
> > > > This is a great littly search form however I dont know enough coding to be
> > > > able to use it with an Auto number field instead of a text field. I know it's
> > > > probably quite simple however my MemberID is Autonumber so keep getting
> > > > errors.
> > > >
> > > > "Ofer" wrote:
> > > >
> > > > > Check this link for a search example on a form
> > > > >
> > > > > http://www.databasedev.co.uk/text_search.html
> > > > >
> > > > > --
> > > > > \\// Live Long and Prosper \\//
> > > > > BS"D
> > > > >
> > > > >
> > > > > "DDrowe" wrote:
> > > > >
> > > > > > I would like a search button that I or a user could use within a form to
> > > > > > locate specific records. Is this possible? I dont want other users in the
> > > > > > tables so it would have to be in the form or report.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > David

Works just fine now, however id like to use the code to search for members by
last name and have adapted this but of course it doesnt cater for several
instances of the same name - is it possible to use this code but allow you to
run through several records?

"Badger" wrote:

> Sorry that was rather stupid of me! Many Thanks will try!
>
> "Ofer" wrote:
>
> > Need to change the txtSearch to the name of the text box in your form that
> > you are using for the search
> >
> > If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then
> > --
> > \\// Live Long and Prosper \\//
> > BS"D
> >
> >
> > "Badger" wrote:
> >
> > > Runtime error 2465 Cant find field txtSearch in your expression.
> > > Stops at ‘If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then’
> > > My field is MemberID(Autonumber) which I first tried substituting for all
> > > instances of Student because the field in the form is strStudentID - I
> > > believe
> > >
> > >
> > > "Ofer" wrote:
> > >
> > > > What is the error you are getting?
> > > >
> > > > It should work with auto number also.
> > > >
> > > > --
> > > > \\// Live Long and Prosper \\//
> > > > BS"D
> > > >
> > > >
> > > > "Badger" wrote:
> > > >
> > > > > This is a great littly search form however I dont know enough coding to be
> > > > > able to use it with an Auto number field instead of a text field. I know it's
> > > > > probably quite simple however my MemberID is Autonumber so keep getting
> > > > > errors.
> > > > >
> > > > > "Ofer" wrote:
> > > > >
> > > > > > Check this link for a search example on a form
> > > > > >
> > > > > > http://www.databasedev.co.uk/text_search.html
> > > > > >
> > > > > > --
> > > > > > \\// Live Long and Prosper \\//
> > > > > > BS"D
> > > > > >
> > > > > >
> > > > > > "DDrowe" wrote:
> > > > > >
> > > > > > > I would like a search button that I or a user could use within a form to
> > > > > > > locate specific records. Is this possible? I dont want other users in the
> > > > > > > tables so it would have to be in the form or report.
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > > David