BABL: Recreate aclocal.m4 with macros from libtool 2.4

Question

I'm trying to develop a query based on parameters entered into a form. I want to make sure that the query will still work even if the user chooses not to enter parameters (ex. start and end date) or if the user only enters half of the parameters (ex. user only enters start but not end date or end but not start date). This is what I want:

If start date and end date is null, then return all dates,

else, If start date is null, then return dates less than or equal to the given end date,

else, If end date is null, then return dates greater than or equal to the given start date,

else, Return all dates between the given start and end date

What I've come up with doesn't seem to evaluated beyond the first true statement and I'm not sure why.

IIf(IsNull([forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_Start_Date]
And [forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_End_Date]),  
[Volunteer_Date],  

IIf(IsNull([forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_Start_Date]),  
<= [forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_End_Date],  

IIf(IsNull([forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_End_Date]),  
>= [forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_Start_Date],  

(Between [forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_Start_Date] 
And [forms]![Volunteer_Hours_By_Person]![Volunteer_Hours_By_Person_End_Date]))))

Solution 1

Try running

autoreconf 
./configure
make

in the root directory of your project.

If that doesn't work, try running make maintainer-clean first and then go to step 1.

If that still doesn't work, run make maintainer-clean, then delete every generated file in the root directory of your project; including aclocal.m4, any m4 directory, any autom4te.cache directory, configure, Makefile.in, config.h, config.h.in, config.status, libtool, ltmain.sh, etc. Then go to step 1.

From user mspoerr over at our friends at Stackoverflow.

Solution 2

In Gentoo this works:

$ phpize 
$ aclocal && libtoolize --force && autoreconf
$ ./configure bbbb#again

Might work in Ubuntu too.

Comments

[Dalen]

i think it would be easier checking dates with vba macro

[David-W-Fenton]

"VBA macro" is contradictory in Access, where you have Macros (which don't use VBA) and VBA (which is not a macro). In Word/Excel, terminology is different. I think what is meant is coding it in VBA. Macros are just not a good solution at all in Access (until A2010, where they get error handling).

[David-W-Fenton]

What is the query used for? If it's the Recordsource of a form or report, then don't include any criteria, and just open the form/report with the criteria as the WHERE parameter of the DoCmd.OpenForm/OpenReport command.

[abel]

did that. thanks. However I am stuck at the next step. even after instal babl, the gimp configure step says. No package 'babl' found. Guess that is for another question.

[Rinzwind]

yes that's the general idea of AU ;)

[Eliah Kagan]

Are you suggesting that this might be helpful for Ubuntu users as well? If so, I recommend editing your answer to state that, and possibly also to explain why. If, on the other hand, you don't think this would help people who are running Ubuntu rather than Gentoo, then this is probably not suitable as an answer for this Ask Ubuntu question.