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>