Search results for query: *

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

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

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

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

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

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

Hopefully this is one of those problems with a quick solution! I've got an option group box on a form with 2 option buttons inside it. This collection of objects works fine with various screen changes occuring quite correctly when each option button is chosen. I now want to refine the...

Hi Have set up a mail-merge using Access and Word 97 based upon MS Knowledgebase sheets Q159328 (Automation techniques) and Q199963 (Stopping another instance of Access using ODBC). All works fine when there are records to mail-merge. However, when there aren't any records I firstly get a MS...

Is it possible to access the info available to a default confirmation message that appear in Access? To explain, with the specific instance I'm considering, how can I produce my own version of the message &quot;Relationships that specify cascading deletes....&quot; &quot;Are you...

Not sure if this is easily possibly in Access 97, but I thought I'd ask. I want to be able to switch on and off the Cascade Delete setting in a relationship. On one of my screens the user can cascade delete records and on another they cannot. I've discovered in the VBA Help the example which...

Hi A database I created a couple of years ago has accumulated some records which should have been deleted by the system (bad design!). What I've decided to do is construct a select query to identify these records and then use this query to delete the offending records and so tidy things up...

Objective: How can I successfully set the DateTimePicker on an Access form (Access 97) to a default date other than the current date? Have come across the following in VB6 book: DTPicker1.Month = (DTPicker1.Month Mod 12) + 1 which sets the date to one month in the future. I've adapted this...

I have a combo box in an Access 97 form of people's names which is populated by a stored query derived from a table called 'Caller'. The people, in question, phone into the user. Sometime these people don't give their name and my user wanted a button to choose the 'Not Given' name from the...

I'm using the 'Application.Quit' VBA command in Access 97 within a button's click code to enable my users to close the database and leave Access. When I use the button to exit, all is fine. However, when my users do it, Access remains open on the Windows 98 task bar and it's not possible to...

In an Access 97 database,I have a form with a combo box which I populate with one of two queries at run-time. Both queries are parameter queries and the query which runs is decided by which button I click in an option group. If I run both queries outside of the form (ie as straight queries)...

Does anyone know what's the maximum number of rows that can be displayed for smooth scrolling in a combo box(CB)? I have an application in which I want to display a list of all the companies my organisation ( ~18,000) deals with. I have associated a query with the CB and when I run the query...

Does anyone know how I can set the properties of a memo box on a form so that the first letter is automatically capitalised? I thought the 'Autocorrect' property would do this but although it will capitalise the first word after a full stop it won't recognise the first word in the field as the...