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

    Subform - Limit: one record's 'Active' field to TRUE

    Thanks AceMan... Solved the problem myself. Here is VBA code I insereted for the subform. You might wanna paste this into notepad with word wrapping turned off: Private Sub Update_Active() Dim SQL As String SQL1 = "UPDATE Applications " & _ "SET Applications.[Active] = ""No"" " &...
  2. datalore

    Subform - Limit: one record's 'Active' field to TRUE

    Cheers AceMan, but not what I am looking for exactly... Say a doctor has an application already entered, and I wish to enter a new one. As soon as I INSERT a new application record, I still want the previous one displayed (I am using a Datasheet view in the subform), but I want to set the...
  3. datalore

    Subform - Limit: one record's 'Active' field to TRUE

    Hi all, Hope everyone is well! Quickie for you: Two Tables: Doctors & Applications, 1 - M relationship. Main Form shows Doctors info, with Subform based on Applications. Simple enough. In the Applications table, I have an Active field. What I need to ensure is that JUST BEFORE creating a...
  4. datalore

    Form date field to default to unlinked table value

    thanks Ken... I tried that but I fail to see how I could run this in real-time. As I create a new record in Data Entry, I need Date to reference the Work Date each time - basically I need it to populate the Date field in realtime. I think an update query will not run like this...but maybe I...
  5. datalore

    Form date field to default to unlinked table value

    Hi all, Hope you are well in this very cold new year (Dublin, Ireland). I have a table set up, called Work Date, with a field called Work Date, default value set to Format(Now(), "dd/mm/yyyy"). I have an Autoexec macro set up, so that it opens up a form that has been created based on...
  6. datalore

    Setting up a personal signature

    Thanks a million - I hope to learn as much as I can advise! Cheers lads, Datalore
  7. datalore

    Setting up a personal signature

    Or even this one: http://www-128.ibm.com/developerworks/lotus/library/ls-mailsignaturesmarticon/ Datalore
  8. datalore

    Setting up a personal signature

    Try this link in TekTips: http://www.tek-tips.com/viewthread.cfm?qid=539775 Datalore
  9. datalore

    Notes 4.6 - Button to open Stationery

    I found the following on this Forum, but Google turns up blanks, as the links that I need actually no longer exist... Help! Datalore ========== If you search www.support.lotus.com for the document below, it describes how to create your own letterhead. Number: 137371 and Title: How to Add Your...
  10. datalore

    Notes 4.6 - Button to open Stationery

    Hi all! Hope you are well! I would like to create a SmartIcon button to open a stationery document called 'New Memo'. I am a newbie and there appears to be very little support for 4.6. Having tried buttons, LotusScript and Agents, I am not having much luck, apart from composing a normal memo...

Part and Inventory Search

Back
Top