A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Create a Search Box on a form



 
 
Thread Tools Display Modes
  #1  
Old March 28th, 2010, 07:39 PM posted to microsoft.public.access.gettingstarted
Summing multiple fields on a form
external usenet poster
 
Posts: 38
Default Create a Search Box on a form

I have a form that allows the user to add a new record. Now I want to allow
the user the capability to change a record in the database, when necessary.

I want to create a search (or filter) on my date field. Do I need to create
a new form or can I use the same form for adding? Also how do I create the
search????

  #2  
Old March 28th, 2010, 08:51 PM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Create a Search Box on a form

If you want to search the form for a specific date, have the user
right-click in the date text box and use the filter for to enter the date.

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"
t.com wrote in message
...
I have a form that allows the user to add a new record. Now I want to
allow
the user the capability to change a record in the database, when
necessary.

I want to create a search (or filter) on my date field. Do I need to
create
a new form or can I use the same form for adding? Also how do I create
the
search????

  #3  
Old March 29th, 2010, 12:15 PM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Create a Search Box on a form

Access provide the ability to search (actually, filter) by form or
selection. To use those, right-click on the form and chose from the sgortcut
menu. You can also add an unbound combo box to your form, and search from
that. There is a wizard available from the form's Design View (option 3) to
do that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Summing multiple fields on a form"
t.com wrote in message
...
I have a form that allows the user to add a new record. Now I want to allow
the user the capability to change a record in the database, when
necessary.

I want to create a search (or filter) on my date field. Do I need to
create
a new form or can I use the same form for adding? Also how do I create
the
search????



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.