[AccessD] Control + (Add record) and which Event is triggered???

Software Design & Solutions Pty Ltd. SDSSoftware at Optusnet.com.au
Thu Jul 31 23:36:01 CDT 2003


So David - are you trying to set the application title to the person's name - if so then you really want to call that for a new record, do you? Not until after the name has actually been entered? Why not do this on the after update event of the name fields (all).

Is there more to it? And why do you want the app title to be the person's name?
Kath
  ----- Original Message ----- 
  From: Tortise at Paradise 
  To: Access Developers discussion and problem solving 
  Sent: Friday, August 01, 2003 2:25 PM
  Subject: Re: [AccessD] Control + (Add record) and which Event is triggered???


  I think we crossed messages.  
  I am not sure adding the If in makes a difference as I run the function in current anyways and it doesn't work in the new record case.   Maybe the problem is in the function?
  Still a problem though.

  Code is:

  Private Sub Form_Current()
  'MsgBox ("Calling Titlebar from current")
  Call Titlebar
  End Sub

  Function Titlebar()
  Dim Cap1, Cap2, Cap3, space1, space2, final As String

      If Me![First Name] <> "First Name" Then
          Cap1 = Me![First Name]
      Else
          Cap1 = ""
      End If

      If Me![Surname] <> "Surname" Then
          If Me![First Name] <> "First Name" Then
              space1 = " "
          Else
              space1 = ""
          End If
          Cap2 = Me![Surname]
      End If
              
      If Me![Company] <> "Company" Then
          If Me![Surname] <> "Surname" Or Me![First Name] <> "First Name" Then
              space2 = ", "
          Else
              space2 = ""
          End If
          Cap3 = Me![Company]
      Else
          Cap3 = ""
      End If

  Me.Caption = Cap1 & space1 & Cap2 & space2 & Cap3
  final = Cap1 & space1 & Cap2 & space2 & Cap3
  Dim intX As Integer
      intX = AddAppProperty("AppTitle", dbText, final)
      RefreshTitleBar

  End Function

  Kind regards,
  David Hingston
  _________________________________________________________________________
  mailto:tortoise at paradise.net.nz
  Personal Webpages: http://203.79.82.163/
  Engines2Go - Now THAT's a Search Engine!
  Automated major search engine manager
  Makes searching quicker and easier - Have you tried it? 
  http://www.engines2go.com/  
  http://www.cheqsoft.com/  The home of Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.
    ----- Original Message ----- 
    From: Software Design & Solutions Pty Ltd. 
    To: Access Developers discussion and problem solving 
    Sent: Friday, August 01, 2003 2:20 PM
    Subject: Re: [AccessD] Control + (Add record) and which Event is triggered???


    Strange...I just tried it with that code on the forms current property and it caught the Ctrl+ and executed the code...what code have you got attached?

    ----- Original Message ----- 
      From: Tortise at Paradise 
      To: Access Developers discussion and problem solving 
      Sent: Friday, August 01, 2003 12:07 PM
      Subject: Re: [AccessD] Control + (Add record) and which Event is triggered???


      mmm Thanks Kath
      Didn't work for me, the form is already loaded is the case I want to catch.
      I already catch it on loading with the forms current property, but it doesn't catch the "Ctrl +" case....
      TIA
      Kind regards,
      David Hingston
      _________________________________________________________________________
      Engines2Go - Now THAT's a Search Engine!
      Automated major search engine manager
      Makes searching quicker and easier - Have you tried it? 
      http://www.engines2go.com/  
      http://www.cheqsoft.com/  The home of Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.
        ----- Original Message ----- 
        From: Software Design & Solutions Pty Ltd. 
        To: Access Developers discussion and problem solving 
        Sent: Friday, August 01, 2003 1:54 PM
        Subject: Re: [AccessD] Control + (Add record) and which Event is triggered???


        In a form? If so, then in the 'on load'event of the form, 'if me.newrecord = true' etc.

        Kath

          ----- Original Message ----- 
          From: Tortise at Paradise 
          To: Access Developers discussion and problem solving 
          Sent: Friday, August 01, 2003 11:17 AM
          Subject: [AccessD] Control + (Add record) and which Event is triggered???


          Hi
          Can anyone tell me which event to put my title update code to apply when someone adds a record using Ctrl +?
          TIA
          Kind regards,
          David Hingston
          _________________________________________________________________________
          Engines2Go - Now THAT's a Search Engine!
          Automated major search engine manager
          Makes searching quicker and easier - Have you tried it? 
          http://www.engines2go.com/  
          http://www.cheqsoft.com/  The home of Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.


          _______________________________________________
          AccessD mailing list
          AccessD at databaseadvisors.com
          http://databaseadvisors.com/mailman/listinfo/accessd
          Website: http://www.databaseadvisors.com



------------------------------------------------------------------------


        _______________________________________________
        AccessD mailing list
        AccessD at databaseadvisors.com
        http://databaseadvisors.com/mailman/listinfo/accessd
        Website: http://www.databaseadvisors.com



--------------------------------------------------------------------------


      _______________________________________________
      AccessD mailing list
      AccessD at databaseadvisors.com
      http://databaseadvisors.com/mailman/listinfo/accessd
      Website: http://www.databaseadvisors.com



----------------------------------------------------------------------------


    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030801/00809d3d/attachment-0001.html>


More information about the AccessD mailing list