vba - How to use a function in filter string in access report? -



vba - How to use a function in filter string in access report? -

i have function defined in vba:

function isinweek(refdate date, checkdate date) boolean startdate = startofweek(refdate) enddte = endofweek(refdate) if (checkdate >= startdate , checkdate < enddate) isinweek = true else isinweek = false end if end function

i want utilize within filter clause of study follow:

strfilte = "isinweek(#" + format(indate, "dd/mm/yyyy") + "#, calanderdate)" docmd.openreport reportname, acviewpreview, reports(reportname) .filter = strfilter .filteron = true end

but doesn't work. study contains records. problem , how can solve it? using access 2003.

note: can utilize between implement function on filter string, looking find why above technique doesn't work.

edit 1

this not working too:

strfilte = "isinweek(#" + format(indate, "dd/mm/yyyy") + "#, [calanderdate])= true" if application.currentproject.allreports(reportname).isloaded = true docmd.close acreport, reportname end if docmd.openreport reportname, acviewdesign, strfilter docmd.openreport reportname, acviewpreview

the docmd.openreport method takes it's lastly parameter optional filter clause. maybe:

docmd.openreport reportname, acviewpreview, ,"isinweek(#" + format(indate, "dd/mm/yyyy") + "#, [calanderdate]) = true"

as far reason method tried doesn't work, remember access beingness particularly fussy reports (as opposed forms) regarding filter property; not sure if can on fly that. accomplish trying without using docmd.openreport filter option, think have open study in design mode, alter property, alter preview mode. remember forms beingness more forgiving this, however. that's memory, though.

edit: syntax incorrect, have added in comma between parameters; per http://msdn.microsoft.com/en-us/library/office/aa220304%28v=office.11%29.aspx, filtername 3rd param, wherecondition fourth. looking wherecondition.

vba access-vba ms-access-2003

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more