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

Tortise@Paradise tortise at paradise.net.nz
Thu Jul 31 23:25:09 CDT 2003


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

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


More information about the AccessD mailing list