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...
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...
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
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...
OK - more info: Using the following code works fine as long as when I click in the field I do not click at the end of whatever text may be present, or if no text is already present as long as I click on the first line/row. clicking anywhere else in the memo box field seems to cause problems...
Thanks Paul
You are correct - what I tried to accomplish was to have the insertion point end up at "x" as follows:
JSmith 04/14/2003: x
if the memo field is empty, it (incorrectly) ends up in position 1 line 2:
JSmith 04/14/2003:
x
if the field contains prior comments, text (my...
Thanks Paul
The numlock now stays on as desired but the insertion point does not reposition itself to the end of the 1st line following the user/date stamp. You mentioned it was an A97 issue which probably explains why it worked fine when I developed it in A2000 but failed when I converted it...
Is it me or what?
I have a form that containes a memo field which, if the user clicked the 'edit' button, code automatically prepends the user's vba.username and the present date at the beginning of the field, and positions the insertion point for the user following this user/date stamp (i.e...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.