UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Filter property    
 
   
josno
post Feb 23 2005, 05:38 AM
Post #1

UtterAccess Member
Posts: 42
From: Somerset, UK
Hi

I'm probably being really stupid here, but I'm trying to filter records on a form. In the 'Filter' property in the Data tab of the form's properties, I entered HireDate=Date(), but it still returns all the records anyway. Any ideas?

Thanks

Joe
Go to the top of the page
 
+
jsitraining
post Feb 23 2005, 05:49 AM
Post #2

UtterAccess VIP
Posts: 5,231
From: Scotland (Sunny Glasgow)
Set the filterOn property to yes

hth
jim
Go to the top of the page
 
+
josno
post Feb 23 2005, 05:52 AM
Post #3

UtterAccess Member
Posts: 42
From: Somerset, UK
Sorry, I'm being dense. Where's the filterOn property? I have the 'Allow Filters' property set to yes.
Go to the top of the page
 
+
Chaga
post Feb 23 2005, 07:30 AM
Post #4

UtterAccess VIP
Posts: 2,579
From: Abu Dhabi, U.A.E
That's the same property Jim suggested...
Try:
(YourRecordSource.Hiredate=Date())

HTH
Go to the top of the page
 
+
jsitraining
post Feb 23 2005, 07:42 AM
Post #5

UtterAccess VIP
Posts: 5,231
From: Scotland (Sunny Glasgow)
Oops, sorry about that, I miss-represented the name (IMG:http://www.utteraccess.com/forum/style_emoticons/default/blush.gif) .
Cheers Charles (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)
Jim
Go to the top of the page
 
+
Chaga
post Feb 23 2005, 07:48 AM
Post #6

UtterAccess VIP
Posts: 2,579
From: Abu Dhabi, U.A.E
Not much of a difference since FilterOn is used for reports (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

o!
Go to the top of the page
 
+
josno
post Feb 24 2005, 12:16 PM
Post #7

UtterAccess Member
Posts: 42
From: Somerset, UK
Ok, the form is set to allow filters, but e.g. tblCustomer.Forename = 'Joe' won't work and neither will (tblCustomer.Forename = 'Joe'), nor using [] around the different parts and replacing the . with a !. Any ideas?
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th June 2013 - 03:02 AM