Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2005

Tip: Looking for answers? Try searching our database.

search in access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Samrasr - 23 Jan 2005 18:25 GMT
Hi hope someone can help me.

I have a form, on the form i want a create a box, when i click on the box a
find  Dialog box appears just like the one when you click Edit and select
FIND.  Every time i want to search for a name in all records i have to
deselect Search fields as formatted and click on for it to search all
records.  I know all this, but a new user would not.  

Can you please explain this in detail and in a simple mannor, i.e codes in
Visual Basic, etc.

This is the third time i have put thread in without success!  So its a box
that appears and you type a text, number and it will find in all fields for
that.  So if i type Ricky it will find Ricky in every Record..

Thanks, i wait in anticipation.

Ricky Samras
Signature

Ricky Samras

B. Comrie - 24 Jan 2005 07:49 GMT
Try writing your own, add a text box and button to your form.

Then try playing around with the DoCmd.FindRecord command

DoCmd.FindRecord Me.TextBox1, acAnywhere, False, acSearchAll, True, acAll,
True

Signature

B Comrie
http://www.codewidgets.com
http://www.comriesoftware.com

> Hi hope someone can help me.
>
[quoted text clipped - 14 lines]
>
> Ricky Samras
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.