Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2008 > Visual Basic 2008 Essentials
|
Visual Basic 2008 Essentials If you are new to Visual Basic programming with version 2008, this is the place to start your questions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2008 Essentials section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 28th, 2009, 11:33 AM
Registered User
 
Join Date: Apr 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using VBA to Search in Access 2007

25 categories, 32


i have a database at work that that is used to track project progress for environmental cleanup projects. I am trying to create a form (in Access) that uses check boxes to select which criteria to search for and then then have a "Go" button that will launch the search. I want the search to return only those records with info in them. For example if I select criteria 1 and criteria 5 I want that data to return only records that have info in criteria 1 AND critiera 5 not one or the other. Once the search is complete I would like the information to be displayed in a report.

There are only 500 records that contain 32 fields of data per record. There are only 25 criteria that I would like to let people search for. But I would like the report to show all 32 fields.
The fields I wanted searchable are:
contract task order
Phases
Active/Inactive
Category
FDE Date
INPR Status
INPR Date
PA/APA Date
SI Date
RI/FS Date
RD Date
RA-C Date
RA-O Date
LTM Date
IRA Date
EE/CA Date
RmD Date
RmA-C Date
PCO Status
PCO Date
Project NDAI Date
Project Concurrence Date
Property NDAI Date
Property Concurrence Date
Concurrence Status

I am a coding retard and have no clue how to begin. Any info would be greatly appreciated.
culleng
 
Old May 25th, 2009, 09:30 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi Culleng

Can you post your queries to http://p2p.wrox.com/access-vba-80/

Your post will get good response there

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
RS-232 and Access 2007 VBA database Gajun BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 1 June 2nd, 2010 11:08 AM
Word 2007, undo, VBA FredrikH Word VBA 0 April 16th, 2009 04:20 AM
excel 2007 vba UDF DavidReese BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 1 February 24th, 2009 01:10 AM
TreeView in VBA (Access 2007) linhqhta BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 1 August 6th, 2008 04:14 AM
VBA Print preview in Excel 2007 solnajeff Excel VBA 1 June 23rd, 2008 01:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.