Search results

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...

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...

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...

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...

I've fallen foul of the 'DLookup is slow as hell' issue for a loop that I've coded. Whilst I can find plenty of references that alternative to DLookup exist, I've found nothing that explicity says how they work! Following information from this link, I'm assuming that the ideal solution uses...

I've produced the following code: Function FilterServiceUser() Dim SUFilter As String Dim varFilter_Surfacs As String Dim varFilter_Surname As String Dim varFilter_FirstName As String Dim varFilter_DOB As String 'Set values, making sure to set them empty strings if the filed id empty (by...

I'm working on a database which uses a form to filter results from a table. The plan is to have three unallocated fields (filter fields) at the top of the form (in the header) and the corresponding fields from the table underneath. The user enters the details in the filter fields and the results...

I'll admit that I'm out of my depth with this (not a programmer, but needing to make use of some simple programming), but hope that this is an easy answer. I've got a sting variable that is the name of a field on my form. I want to be able to use this to retrieve the value from my form. In...

I'm helping out with a database at work and we have a need for a complex filter function. Due to our 'low-to-no tech' user base, the perfect solution (the built in 'filter by form' function) is neither obvious nor intuitive enough. The approach we want to take is something like this (very...