Recent content by kchernak

I have an access97 db (HMDA.mdb)I created that is used by folks in various locations to enter cutomer data. It's not that heavily used, perhaps a dozen records a month or so, but the number of potential peaple who might enter a record are perhaps a few hundered, and they're located in separate...

Bradles - sorry - noticed as I hit the send button - meant to type 'thanks' for your help - not 'that's' for your help.

Thanks drctx - I didn't have any luck getting the sendkey statements to work - tried everything. I spent some time looking through the snapview help files and ended up having to create a form with a snapshot control where I could manipulate the snapshot path property using code, and then cycle...

I have an A2K app that generates 100+ individual snapshot reports and saves them to a time/date stamped folder. Later, I need to print these snp reports, but doing it one-at-a-time is killing me. I found some code using the filesystemobject that seems to do everything I need to locate and...

AceMan - Thanks! Works like a charm. and Thanks for such a speedy response!

I have a form that has a combo box to allow users to lookup a record based on a name field. It works fine except if the name field value as an apostrophy - then I generates a syntax error - missing operator. so it finds "Joes Bakeshop" but not "Joe's Bakeshop". The db is...

Larry I tried this code and get a run time 3265 error on the line " strTemp = db.QueryDefs(ObjName).Name" if the qry does not exist. Is it just me? I try exact code cut an paste. thanks

GingerR OK - my typo in referencing a child ID rather than the parentID when renaming with actual field names. WORKS BEAUTIFUL! BIG THANKS!

GingerR I tried working with your function solution as a function and as a sub routine on a skinnied down test file to 16 records, but the results only produce 1 record in the ChildTable. It appears to end up in an infinate loop with the strIDtoFind stuck on the second record. any ideas? thanks

Thanks willir and GingerR - I just wanted to thank you both very much for your suggestions even before I try them out. I manually ran a series of unmatched, make table and append queries to get a table of records with the Prime parent so I could at least have something to begin working with to...

Thanks GingerR and willir I don't think I did a good job of labeling or explaining the relationships - the 1st number (12345-18, 12345-0) I called the parent because it is the unique record identifier - however, I should have labeled the list Child, Parent: child, parent: 12345-18, 12345-0...

No, my kid ain't misbehavin'. I have account records that I need to associate with the parent record. the records have a unique record id (12345-26) and a parent ID (12345-18). The parent ID can also be 0 (no parent record) or it could refer to a parent ID that no longer exists. These...

Well, I have a master list (list A) of perhaps 20k records with names and account numbers. One department does work relating to some of these records and provides the results in a separate file (the List B). For various political and attitudinal reasons, the simple act of providing the account...

I have a list B of customer names (sloppy, typo's, variations, etc), and I need to identify potential matching names from a master list A. for every record in list B, I want to seach through all records in list A and have the resulting field vale for the function be a list of reference numberf...

Subform prevents undo problem I have a form with a tabctl and about 8 pages. Most of the pages display various fields from a record (customer data related page, financial data requirements page, etc). A few pages display a subform. to add/edit data on a record, the user clicks an edit...