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!

  • Congratulations gkittelson 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: *

  1. chriscriswell

    NameSpace Logon problem - wrong code, or just possessed?

    Thanks for responding, Brian! Yes, I use code similar to that to mail in various ways. However, this time I must use the NameSpace method so notices may be sent without opening Outlook (coming from a production line box; a valid profile set up on the box to allow the mapi login but no Outlook...
  2. chriscriswell

    NameSpace Logon problem - wrong code, or just possessed?

    Hi folks, it's been another grand frustrating day! I'm trying to mail from Access using the NameSpace Logon method with embedded profile and password. However, I cannot seem to get it to work. The code breaks with an error at the last line of this segement. ********** Dim objOutlook As...
  3. chriscriswell

    The Amazing Disappearing Scrollbar...

    Yeah, that's ok, the thing that is whacking my brain is it's only happening to about 10% of the displayed records... the rest show just fine! I've looked over and over at the individual records and there doesn't seem to be any pattern in the "non-show" problem *that I can see*.
  4. chriscriswell

    The Amazing Disappearing Scrollbar...

    Hi guys, this is one of those "Huh???" situations. On one of my forms, I have two subforms. One is normally hidden, and becomes visible only with a click action. Everything works just fine EXCEPT... certain records displaying in this subform lose their vertical scrollbar with no apparent rhyme...
  5. chriscriswell

    sending e-mail from access - what is a template file

    Hey scottian, I just finished dealing with a similar problem last week. I have email going both to the person/department being notified, and an email coming back with their acknowledgement. Really simply, I just used the form fields to populate the emails and it is really working smoothly...
  6. chriscriswell

    Append Writing Duplicate Records...

    Doh! Thats it, JonFer! Thanks for the Christmas present! Now I can start pasting back in the hair i've pulled out....
  7. chriscriswell

    Append Writing Duplicate Records...

    Hi guys, thanks for responding. First of all, here is the sql from the query: INSERT INTO tbl_Calibration_Record SELECT tbl_GageOut.* FROM tbl_GageOut LEFT JOIN tbl_Calibration_Record ON tbl_GageOut.[Device ID] = tbl_Calibration_Record.[Device ID] WHERE (((tbl_GageOut.[Date In]) Is Not Null))...
  8. chriscriswell

    Append Writing Duplicate Records...

    Hi folks, I know I must be just not seeing something that's wrong but I just can't see it... I have three tables... master gage, gagehistory, and gageout. All have deviceID field. Mastergage and gageout have deviceID as primary w/no dup, gagehistory deviceID as foreign with dups allowed (this...

Part and Inventory Search

Back
Top