I made this change, but I am still receiving the same error message as previously stated. It seems to me I'm doing something wrong in the initiation of the recordset. This is the first instance of this I've done, and all the help files I have seen include connection objects pointing to external data sources, not within the same Access mdb file as I am trying to do.
Still seeking guidance,
Mark...
breadhead
Last Activity: Jul 16 '07, 07:49 PM
Joined: Jul 6 '07
Location:
-
The newCat text would be something like...
Christmas card recipient
Small Business Loan luncheon
member of the Country Club
These values will be stored in a two field table, with the first column an autonumbered key and the second a 150 character text field.
I'll try your changes this morning and let you know how it goes. Thanks for your advice.
Mark...Leave a comment:
-
Steve,
What you're describing seems like a task for a do...while loop, not a query. If you're not restricted to queries, I think the right approach might be to create a pair of recordsets - one for the dates and another for the individual records for each date, then loop through the second recordset a row at a time, writing the text to a variable and updating the table at the end of the recordset.
All that being said,...Leave a comment:
-
error opening a recordset in MS Access 2002, vba script
Good morning, all.
I am creating an Access 2002 application to run on XP clients and I'm struggling with the task of testing whether a single-field record exists before allowing the user to add it to a look up table. I considered creating a unique index on the field in the table, but the users here would not know how to handle the error message. From there, I moved to creating a recordset that tests for the presence of a matching...
No activity results to display
Leave a comment: