Search results

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

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

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

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

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

I have an Access 97 database which is used to design tables which are then built in SQL Server 2000. As new tables and fields are added to the designs, or old ones are modified, I have VBA code which generates an SQL script to build or modify the tables as per the current designs, as well as...

In Access 97, I have an append query involving 1 local table plus 3 tables linked in from SQL Server 2000 (the SQL View of the query is shown below). I also have a macro set up to clear several local tables (including the local table involved here) and then run a number of queries, including...

I've got an Access 97 application with several reports, all of which have opened quickly and without error for some time. All of a sudden, one of them always immediately hangs with the message "Formatting page, press Ctrl+Break to stop..." The report is based on a query which joins two tables...

WIAEnrollmentsDetailQ1 is a select query, which contains a calculated String field named GrantGrp. The query works as intended as the RecordSource for several detail reports, and when opened directly from the user interface. It is also the RecordSource for a summary report, which is intended...

In Access 97, I have a Payees table in a one-to-many relationship with a Trans table, linked to each other on a Social Security Number field (the link is Payees.SSN --> Trans.TransSSN). Both fields are Text, FieldSize 11, InputMask "000\-00\-0000;0;_". Payees.SSN is a key field, while...

I need some suggestions for avoiding the dreaded 2115 Error. I have a form text box bound to a date/time field in an Access 97 table. All along, I've been using the BeforeUpdate event to ensure that the time entered in the text box is not earlier than the time entered in a previous text box -...

I have a relatively small (1.5 MB) database. It contains an unbound form, which includes 4 combo boxes and 1 list box, all of them bound to tables or queries which return very few records. Whenever I save this form, or switch between Design and Form views, I get the hourglass for 10 to 30...

I'm running Access 97 under Windows XP. On an unbound form, I have an unbound list box (lstItems) whose MultiSelect property is set to Extended, and whose RowSource is a select query; some of the query's criteria are based on the values in other fields on the same form. The application...

In my Access 97 application, the normal deletion confirmation message ("You are about to delete ...") no longer appears when I delete a record using a particular form bound to a particular table. Since there is now no deletion confirmation message displayed, the AfterDelConfirm event procedure...

I'm using the following Access 97 code to create a table from specifications stored in another table. It worked fine, until I added the statement "tdf.Fields.Append fld" inside of the Do While loop, and I can't figure out why. The help screen for the Description property (applicable to Field...

I need to manipulate an Access 97 listbox in VBA code. The only way I've found to do this is with code like: MyListBox.Selected(4) = True which will select the fifth item in the listbox, and de-select whichever item was previously selected. So far so good. However, when I then refer to the...

In the following code, there are two "Set dbs =" statements, only one of which is uncommented at a time. When I use the first one, the code works and accurately reports the total number of tables in the current database, along with the name and update date/time of the most recently and least...

I'm using Access 97 under Windows XP, with all Control Panel "locale" options set for the US. I'm reading records from a linked table (in another Access 97 database) using DAO, and it is crucial that I access them in key order. Access won't let me open the Recordset as any type that permits...

I have an append query which, until a few hours ago, ran fine. Now when I attempt to run it, it always fails with a message saying that the records which should have been added were not, due to validation rule violations. However, the table that's being appended to has NO validation rules...

I'm encountering a weird phenomenom: when attempting to edit VBA in a particular modal form's code module, Access begins making changes to my code before I finish a line. Spaces are added or deleted, the cursor (insertion point) is moved, and capitalization is inserted or removed. This makes...