137e0 Code to adjust query criteria
Sign Up |  Live StatsLive Stats    Articles 37,469| Comments 178,637| Members 19,494, Newest Kartarsingh| Online 509
Home Contact
 (Forgotten?): 
    10 years of Excellence
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Click Here to Register/Sign Up Daily Hukamnama Member Blogs Downloads Website Navigation Help Fonts Tags

Code to adjust query criteria

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 500 USD, Received: 0 USD (0%)
Please Donate...
     
Related Topics...
Thread Thread Starter Forum Replies Last Post
Query Criteria wal50 Information Technology 3 28-Jul-2006 08:28 AM
query criteria Chey Information Technology 0 28-Jul-2006 08:27 AM
Code in Excel - adjust for Access ddunks Information Technology 1 28-Jul-2006 08:27 AM
Access changing query criteria when saving a form's VBA code Michael Lysons Information Technology 2 28-Jul-2006 08:03 AM
query criteria Jessica Information Technology 1 27-Oct-2005 12:27 PM


Tags
code, adjust, query, criteria
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 28-Jul-2006, 08:34 AM
Francophone's Avatar Francophone
Guest
 
Posts: n/a
   
   
Code to adjust query criteria

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
Currently I have a switchboard for printing reports that track performance
over:
1. the current month
2. the previous 90 days
3. the current year
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13149-code-to-adjust-query-criteria.html

The way I am doing this is by creating 3 different queries for those time
periods and referencing those to create the 3 different reports via 3 control
buttons.
(ie. >=DateSerial(Year(Date()),1,1) - for current year)

I think I can better do this by writing code for the 3 control buttons and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13149
automatically setting the 3 different criterias for the queries. Problem is
I don't know how to do this. Can anyone please help?

TIA


Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 28-Jul-2006, 08:34 AM
Ofer Cohen's Avatar Ofer Cohen
Guest
 
Posts: n/a
   
   
RE: Code to adjust query criteria

  Donate Today!  
If the filter are used for reports, you can use the WhereCondition section on
the OpenReport command line

Dim MyCondition As String
MyCondition = "Year([DateFieldName]) = " & Year(Date())
Docmd.OpenReport "ReportName" , , , MyCondition

--
Good Luck
BS"D


"Francophone" wrote:

> Currently I have a switchboard for printing reports that track performance
> over:
> 1. the current month
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13149
> 2. the previous 90 days
> 3. the current year
>
> The way I am doing this is by creating 3 different queries for those time
> periods and referencing those to create the 3 different reports via 3 control
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13149
> buttons.
> (ie. >=DateSerial(Year(Date()),1,1) - for current year)
>
> I think I can better do this by writing code for the 3 control buttons and
> automatically setting the 3 different criterias for the queries. Problem is
> I don't know how to do this. Can anyone please help?
>
> TIA

Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
English Sri Guru Granth Sahib Ji Translations
Today 18:56 PM
4 Replies, 67 Views
Can Sikhs worship...
By Ishna
Today 18:54 PM
6 Replies, 46 Views
Difference in Bowing...
By Kamala
Today 15:08 PM
11 Replies, 253 Views
What Really Happened on...
Today 12:46 PM
13 Replies, 198 Views
Free Online Gurbani...
Today 03:56 AM
13 Replies, 4,339 Views
English Sri Guru Granth...
Today 03:51 AM
5 Replies, 170 Views
Edward Snowden: the...
Today 03:34 AM
3 Replies, 173 Views
Rozana Reports (ਪੰਜਾਬੀ...
Today 03:23 AM
407 Replies, 9,434 Views
Sikh Spokesman (ਪੰਜਾਬੀ...
Yesterday 17:57 PM
255 Replies, 6,064 Views
What Is Difference...
Yesterday 09:18 AM
6 Replies, 183 Views
First There is Water by...
By Ishna
Yesterday 05:03 AM
3 Replies, 190 Views
Cooking Without Alcohol
Yesterday 02:12 AM
12 Replies, 198 Views
Learning from Baba...
Yesterday 01:38 AM
0 Replies, 312 Views
Eckhart Tolle
17-Jun-2013 18:08 PM
2 Replies, 129 Views
Thought of the Moment!
17-Jun-2013 16:35 PM
115 Replies, 6,094 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +6.5. The time now is 19:45 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.34257 seconds with 32 queries
0