<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I think we crossed messages. </FONT></DIV>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2>Still a problem though.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Code is:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Private Sub Form_Current()<BR>'MsgBox ("Calling
Titlebar from current")<BR>Call Titlebar<BR>End Sub</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Function Titlebar()<BR>Dim Cap1, Cap2, Cap3,
space1, space2, final As String</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> If Me![First Name] <>
"First Name" Then<BR> Cap1 = Me![First
Name]<BR> Else<BR>
Cap1 = ""<BR> End If</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> If Me![Surname] <>
"Surname" Then<BR> If Me![First Name]
<> "First Name"
Then<BR>
space1 = " "<BR>
Else<BR>
space1 = ""<BR> End
If<BR> Cap2 =
Me![Surname]<BR> End
If<BR>
<BR> If Me![Company] <> "Company"
Then<BR> If Me![Surname] <>
"Surname" Or Me![First Name] <> "First Name"
Then<BR>
space2 = ", "<BR>
Else<BR>
space2 = ""<BR> End
If<BR> Cap3 =
Me![Company]<BR>
Else<BR> Cap3 =
""<BR> End If</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Me.Caption = Cap1 & space1 & Cap2 &
space2 & Cap3<BR>final = Cap1 & space1 & Cap2 & space2 &
Cap3<BR>Dim intX As Integer<BR> intX =
AddAppProperty("AppTitle", dbText, final)<BR>
RefreshTitleBar</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>End Function<BR></FONT></DIV>
<DIV>Kind regards,<BR>David
Hingston<BR>_________________________________________________________________________<BR><A
href="mailto:tortoise@paradise.net.nz">mailto:tortoise@paradise.net.nz</A><BR>Personal
Webpages: <A
href="http://203.79.82.163/">http://203.79.82.163/</A><BR>Engines2Go - Now
THAT's a Search Engine!<BR>Automated major search engine manager<BR>Makes
searching quicker and easier - Have you tried it? <BR><A
href="http://www.engines2go.com/">http://www.engines2go.com/</A> <BR><A
href="http://www.cheqsoft.com/">http://www.cheqsoft.com/</A> The home of
Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=SDSSoftware@optusnet.com.au
href="mailto:SDSSoftware@optusnet.com.au">Software Design & Solutions Pty
Ltd.</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 01, 2003 2:20
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Control + (Add
record) and which Event is triggered???</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=tortise@paradise.net.nz
href="mailto:Tortise@Paradise">Tortise@Paradise</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 01, 2003 12:07
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Control + (Add
record) and which Event is triggered???</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>mmm Thanks Kath</FONT></DIV>
<DIV><FONT face=Arial size=2>Didn't work for me, the form is already loaded
is the case I want to catch.</FONT></DIV>
<DIV><FONT face=Arial size=2>I already catch it on loading with the forms
current property, but it doesn't catch the "Ctrl +" case....</FONT></DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV>Kind regards,<BR>David
Hingston<BR>_________________________________________________________________________<BR>Engines2Go
- Now THAT's a Search Engine!<BR>Automated major search engine
manager<BR>Makes searching quicker and easier - Have you tried it? <BR><A
href="http://www.engines2go.com/">http://www.engines2go.com/</A>
<BR><A href="http://www.cheqsoft.com/">http://www.cheqsoft.com/</A>
The home of Clipboard Express, MP3 Detective, TimesOwn and Break
Reminder.</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=SDSSoftware@optusnet.com.au
href="mailto:SDSSoftware@optusnet.com.au">Software Design & Solutions
Pty Ltd.</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion
and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 01, 2003 1:54
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Control + (Add
record) and which Event is triggered???</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>In a form? If so, then in the
'on load'event of the form, 'if me.newrecord = true' etc.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=tortise@paradise.net.nz
href="mailto:Tortise@Paradise">Tortise@Paradise</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion
and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 01, 2003 11:17
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Control + (Add
record) and which Event is triggered???</DIV>
<DIV><BR></DIV>Hi<BR>Can anyone tell me which event to put my title
update code to apply when someone adds a record using Ctrl
+?<BR>TIA<BR>Kind regards,<BR>David
Hingston<BR>_________________________________________________________________________<BR>Engines2Go
- Now THAT's a Search Engine!<BR>Automated major search engine
manager<BR>Makes searching quicker and easier - Have you tried it?
<BR><A
href="http://www.engines2go.com/">http://www.engines2go.com/</A>
<BR><A
href="http://www.cheqsoft.com/">http://www.cheqsoft.com/</A> The
home of Clipboard Express, MP3 Detective, TimesOwn and Break
Reminder.<BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>