Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kchernak
  • Order by date
  1. kchernak

    Please help - Unsolvable Reference Libraries Problem

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

    How can I Print saved SNP files from code?

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

    How can I Print saved SNP files from code?

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

    How can I Print saved SNP files from code?

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

    Please help - Combo Lookup frm problem

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

    Please help - Combo Lookup frm problem

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

    How to check whether a query already exist

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

    Desperate 4 help - Parent-Child relationship qry

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

    Desperate 4 help - Parent-Child relationship qry

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

    Desperate 4 help - Parent-Child relationship qry

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

    Desperate 4 help - Parent-Child relationship qry

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

    Desperate 4 help - Parent-Child relationship qry

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

    str search function help needed

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

    str search function help needed

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

    Subform prevents undo problem I

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

    CancelEvent fails

    maybe add a me.undo befor the cancel event line?
  17. kchernak

    SendKeys problem

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

    SendKeys problem

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

    SendKeys problem

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

    SendKeys problem

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

Part and Inventory Search

Back
Top