Search results for query: *

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

Just a simple one this. My company has moved from Novell Groupwise to MS Outlook 2002. True to form they've just plopped it on desktops with little support / documentation. As I've been nominated in my dept (130+ people) as the first-line support person, I#m on a fairly steep learning curve to...

Thanks for suggesting the problem might lie with database corruption. I used the Repair Database facility and then compacted, and it was fine.

Unfortunately that's not the case. Database is 34Mb. Available disk space 9.26Gb. Thanks for replying.

We have an Access 97 database here at work which I've developed and now administer. It's been in use for ~18 months by 6-8 people. Each month, because of data imports from another system, I compact it in the usual way through Database Utilities and, up until now, no probs. As usual I make sure...

Have you managed to get anywhere with this since you posted your request for help? I have the same problem. Thanks Steve House shouse@icaew.co.uk http://www.icaew.co.uk