Searching records

[Black Tie - Orland Park]

Hello,

I was hoping someone would be able to help me out with this. I have a
database that sorts all types of information. Mainly what is records is two
names on each record (future wife, husband), date they are to be married,
where they originally registered at.

I need a way to use a form to search these records and filter out the ones
based on what I provide the search form. (I need to find a wedding that is
taking place 10/20/04 and I need to beable to narrow down any weddings that
will be happening that weekend).


Any one have a clue how to do this or could direct me to a place that can
tell me how to do it?


Any help would be MUCH appreciated!

Thanks,

Matt

(PS: Please also send a copy of the reply to my e-mail address orlandpark
@ blacktietuxes.com)

 

[Ernie]

Included with your Access installation disk is a sample
database (Northwind.mdb). Look through that and see how
they set up their tables, queries and forms.

You might also want to pick up and browse through one or
more books on using Access. Some titles that I can think
of right off hand would be Access 2003 Complete, Access
2003 Bible, or Getting the most from Access 2003. (you
might have to settle for Access XP but almost everything
in there still works as early as access 2000.

After that, if you have a more specific question, please
come back and repost (and include your table layout).

 

[German Saer]

You have to do a subform with the whole list

And a form with all the fields unbound and the subform previuosly created on
it.

on the event AfterUpdate of each field on the main form call a procedure
(Sub) for example: "filterlist"

Then create the filterlist procedure with instructions like these:

Sub filterlist()
If Not IsNull(mDate) Then
mFilter= "DateOfMarriage = #" & mDate & "#"
End If
If Not IsNull(mRegisteredAt) Then
mFilter= mFilter & " And RegisteredAt = " & mRegisteredAt
End If
If Not IsNull(mPlace) Then
mFilter= mFilter & " And Place = '" & mPlace &"'"
End If
subformListofCouples.FilterOn= True
subformListofCouples.Filter= mFilter
subformListofCouples.Refresh
End Sub

Of course, this is only an example but that's the idea.

 

[brittany laughman]

I don't know but i like eminem's music i think he's hot.

 

[yu]

ÄãÃǺÃ:
¿ÉÒÔ½ÌÎÒ·¢ÓʼþÂð?

 

[John R Borges III]

I know a guy that will find it quickly, he's not cheap,but he will do it for
a modest price... His name is James Bond. You really need a spy to pull that
one off...