Recent content by phual

I'll give that whirl and see where it takes me. Thanks Stuart

Hi all I've got a somewhat specific problem that I'm sure must have an answer, but I'll be blowed if I know how to approach it. We have a print-and-post-room that is set up with plenty of hardware to make bulk mailing easier (folding machines, envelope-stuffers, etc.). However, we need to...

jdraw, I've done a quick test on your revised code and it's worked a treat (entering a value of 0 for the DateUK parameter)! It looks like the problem was indeed that Microsoft's documented solution failed to take account of UK date formats. Thanks Stuart

Brian, I've not included the actual SQL due to its complexity, but this simple example shows the same result: SELECT [tbl BaseQuery].RefID, [tbl BaseQuery].ReferralDate, [tbl BaseQuery].inPlanningDate, DateDiffW([ReferralDate],[inPlanningDate]) AS Diff FROM [tbl BaseQuery] WHERE ((([tbl...

The thing is, I'm not using strings. The two dates that I'm comparing are from a table, where each field I'm compaing are in date format. The function executes happily (and delivering the correct result) for other dates (when executed via a query): 05/11/2012 to 06/11/2012 = 1 05/11/2012 to...

I've fallen foul of the error in the DateDiff function (MS Access 2002) when trying to find the number of working days between two dates. I've had no end of problems working round the issue, but the last problem has stumped me. I've implemented the MS provided workaround as detailed here...

My mother is a collector of folk dances and a number of years ago I made her a database to manage the thousands of dances and tracks. This is the only thing that my mother uses MS Access for, so it is not a good investment for upgrading to newer versions. Therefore, I've a long-term goal of...

Thanks for the response, but unfortunately this does not address my problem. The solution you link to only checks an individual record with external parameters - my problem requires comparisons between records. The solution as linked would return all three of my examples activities, when I need...

I've got a problem for which I'm far from convised there is a solution. Consider this scenario: You have a client for whom you can have any number of activities / events / whatever, each with an associated start and end date. I need to return all activities that 'open' a new episode of...

No, that definitely wasn't the problem, though I don't know what was. The [Event Procedure]s were there and code was trying to run, but it was giving errors instead of running. Anyway, it's fixed now and that's what's important. Stuart

How fantastically irritatingly stupid! I can't recall what exactly I'd done, but I do know that I had been playing around with it (renaming amongst other things). Turns out that commenting out and recreating sorted the problem, despite it being the same code as I'd tried previously (same as...

I'm aware that command buttons come only in a less than stylish grey, but I've also found a simple alternative of using On Mouse Down/Up events to make a label appear and operate like a button. Problem is, I would swear it worked at the end of last week (when I was prototyping), and isn't...

Some time ago I asked this question, got to the verge of success, and then disappeared into a block hole for many fun and exciting adventures... that's my argument and I'm sticking to it! :D Anyway, I finally returned to get the problem sorted and express my appreciation for assistance given...

I'd not really considered it. It never crossed my mind to use a query to update unassigned controls on a form. At least, I assume that your suggestion is in response to resetting those values rather than to applying a filter. I can't really visualise how it may work, but the concept seems...

I want to understand how to use an alternative to DLookup :p but I presume your curiosity is more targeted towards what I want my specific code to do. I have a large table with various yes/no fields that represent available services. These services can be grouped into wider categories...