Recent content by Cads

Magic! I knew there was a simple answer. Thanks

Been asked to create a query in Access 2002 that looks through a large table of records of personal data for entries in a 'Salutation' field that does not begin "Dear" (eg "Dear Mr Bloggs"). I've tried '<> "Dear*"' but no joy. I'm sure the answer's an easy one but in 8 years of using Access I...

Thanks for your FAQ. I changed the code to only select controls that can be enabled/disabled. Still not sure why the 'On error resume next' doesn't cater for non-enable controls, nor why the list of properties for a control (eg ctl.) doesn't list 'enabled' or 'controltype', but sometimes you...

Don't know if anyone's had a simlar problem when migrating from 97 to XP but the following code (lifted from the popular 'Solutions' database, once available from MS as a download) won't work in XP. The code seems to loop indefinitely on first accessing and then it subsequently throws up an...

Sure did! Thanks anyway. I did try your link but Internet Explorer came back with an HTTP 404 page - 'The page cannot be found'. Also tried to look at variations on the address but no joy. Is the site still active?

Does anyone know if a filter could be added to a form which is based on a Top query in Access 2002? I'm fairly new to filtering by form but for my current project here at work it's proving to be particularly useful. My user would like to be able to browse a subset of records in the form based...

Does anyone know if a filter could be added to a form which is based on a Top query in Access 2002? I'm fairly new to filtering by form but for my current project here at work it's proving to be particularly useful. My user would like to be able to browse a subset of records in the form based...

Unfortunately this doesn't seem to change things - still getting the same error message. however, thanks for responding. Perhaps I should have said that the 'frm' is the subform control in the main form and I'm basing my approach on Knowledgebase article Q209099 which says to refer to a control...

I've recently been upgraded here at work from Access 97 to Access 2002. Since that happened, I've hit a problem with changing values in a subform, which in 97 worked fine. The following code relates to a checkbox which displays the subform to allow data entry. The code handles the situation...

Hi I had this problem a year or so ago with an application I'd developed here at work for a group of users who were using a range of screen resolutions. (One user is visually impaired). To solve this problem you need to invoke Windows API routines. Tricky! However, if you access the SMART...

When I saw your request my immediate thought was Excel rather than Access. Comparing 8 fields in every record in a query and extracting the top 2 seems a little hairy to me! In Excel, by using the MAX function it would be easy to find the highest; however, for the second highest you'd need to...

Thanks for your various comeents. Decided to restructure the code to use Public Constants. It's worked fine.

Unfortunately not the case. Tried changing the name of the Enum to a few different names but VBa still doesn't like the syntax. Knowledgebase article 160500 says how the keyword Enum is now restructed without clearly explaining how. I'm still fairly certain its Enum that it doesn't recognise...

I've been sent a useful set of procedures by another Access developer which were written in Access 95 and (according to my source) worked fine. When I transfered the code into Access 97, it baulked at the Enumerated Type code with a syntax error: example Private Enum CharType CharAlpha =...

Recently moved to Outlook/Exchange here in my organisation. Unlike in the previous Email product, IT management have put a fixed size limit on the mailbox with no warning when the size has been reached. Annoying, because when it happens you have to delete and/or archive before being able to...