Recent content by AlanS

I have a genuine Microsoft CDs and keys, one with Office 97 Small Business Edition, and the other with Access 97 (these are both the full version, NOT upgrades). As I got new machines over the years (both Windows 98 and Windows XP SP 2), I installed the software from both CDs without incident a...

Depending on how the form's .Cycle property is set, the user may still be able to scroll through records using the keyboard. You can limit the user to only a single new record regardless of that setting, by making the following settings in the Form_Load event procedure: .AllowAdditions = True...

I have an Access 2003 form which uses three unbound listboxes, all of which are populated by queries on the fly. The first one displays records from a parent table, and the other two display corresponding records from two child tables. As the selection is changed in the first listbox, the...

A few points to consider here (based on U.S. law): 1. The_Doc_Man stated that "The same principles apply to copyright law, patents, and trademarks." That statement is somewhat misleading - while copyrights, patents and trademarks are all elements of intellectual property, and many common...

Pat, there are no timers anywhere in the database. And I'm already doing what you suggest (stopping the code, making the needed changes, and attempting to save those changes), but it just won't let me save ANYTHING until both Access and the VB editor have been shut down and re-started.

I previously posted this in one of the other forums, but now believe this to be of a more general nature, and am still without a satisfactory explanation or any workaround: I'm working on a new database with Access 2003, using the 2002-2003 file format. While debugging a VBA code module in the...

Thanks, llkhoutx and Banana, but the Open mode setting makes no difference - the same thing happens regardless of whether it's set to Exclusive or Shared. And this has nothing to do with live and backup copies of the database (backups are made and preserved at appropriate intervals) - the...

I'm working on a new database with Access 2003, using the 2002-2003 file format. While debugging a VBA code module in the VB editor, whenever I get a runtime error something strange happens - I correct the code and attempt to save my changes, and Access displays the message "Microsoft Office...

Then I'd take a look at the data the query is returning, so you can see the actual values of the fields in question.

Are you sure that [minoftime] and [national standard] are both present in the table(s) the query is based on, and that they are spelled correcrtly?

You could put something like this in the query's SELECT clause: IIf([SwimmingTime] = Forms!MyForm!txtSwimTime, "It matches", "No match") AS SwimText which would cause the query to return a field called SwimText, with a message indicating whether or not each record's SwimmingTime field was...

I maintain a mature Access 97 application, divided into front and back ends. A report is based on Query2, which is in turn based on Query1. Query 1 is the main data table with outer joins to about 2 dozen lookup tables. Query 2 applies selection criteria from a user form to generate the...

On the import clients form, place a hidden text box. In the duplicate clients form, set the value of that text box before exiting the form, with the specific value indicating whether or not you want the import clients form to continue processing. Back in the import clients form, test the value...

Try this: rst2.Find "[AccountNum] = '#" & Me.AccountNum & "# '" I'm assuming that the field rst2.AccountNum contains a string value consisting of a pound sign, followed by an account number, followed by another pound sign, followed by a space. You need to embed the apostrophes when...

There are two problems with the way you have it: 1. Using the IF THEN ELSE construct, Access will always open the form OR execute the subsequent code, but never both. 2. Since you are opening the form asynchronously, the code following the IF THEN ELSE block will run immediately, which is...