Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching Access database with two text boxes

Status
Not open for further replies.
jcpelejo

jcpelejo

Programmer
Jul 29, 2001
70
US
Hello. I have a MS-Access 2000 database that I would like to query with a search page. On the search page, I would like to query two fields called [Date] and/or [RecordNumber] from table [tblCallDates]. I want to be able to put partial information so that if the user does not know the whole criteria, they could put part of the information in. Once the query is finished, I would like the page to display the results in a table format with the following fields: [RecordNumber], [Date], [RecorderNumber], [DiscNumber] and [SideNumber]. Please advise. Life is too short to waste...
Julius Pelejo
jcpelejo@hotmail.com
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
READ TEXT FILE BASED ON VARIABLE 1
Replies
2
Views
408
guitarzan
guitarzan
leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
507
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
363
penguinspeaks
penguinspeaks
JScannell
  • Locked
  • Question
Border issue with Google Chrome on an Android phone
Replies
0
Views
379
JScannell
JScannell
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
330
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top