473,326 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Invalid Reference to the Property 'Apptitle'

This is the first time I'm trying this in an ADP. I'm using Access
2003 and trying to change the Apptitle Property using the below:

With Application.CurrentProject
.Properties("AppTitle").Value = "somethingelse"
.RefreshTitleBar
End With

I'm getting Invalid Reference to the Property 'Apptitle'. In an MDB,
I'd just Create the Property...but that was using DAO. Can someone
tell me how to add the AppTitle property?

Jul 31 '06 #1
6 5241


"Dave" <Ki************@Verizon.Netwrote in message
news:11*********************@s13g2000cwa.googlegro ups.com...
This is the first time I'm trying this in an ADP. I'm using Access
2003 and trying to change the Apptitle Property using the below:

With Application.CurrentProject
.Properties("AppTitle").Value = "somethingelse"
.RefreshTitleBar
End With

I'm getting Invalid Reference to the Property 'Apptitle'. In an MDB,
I'd just Create the Property...but that was using DAO. Can someone
tell me how to add the AppTitle property?
Dim db As CurrentProject
Set db = Application.CurrentProject

db.Properties.Add strPropName, varPropValue

(david)
Aug 1 '06 #2
david epsom dot com dot au wrote:
Dim db As CurrentProject
Set db = Application.CurrentProject

db.Properties.Add strPropName, varPropValue
Is there some value/usefulness in setting a reference/pointer to
CurrentProject?

And "db"????

Aug 1 '06 #3
Have you tried it?

(david)

"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
david epsom dot com dot au wrote:
> Dim db As CurrentProject
Set db = Application.CurrentProject

db.Properties.Add strPropName, varPropValue

Is there some value/usefulness in setting a reference/pointer to
CurrentProject?

And "db"????

Aug 1 '06 #4
Only in this way:

' establish the current build
With CurrentProject.Properties
CurrentBuild = .Item("CurrentBuild")
CurrentBuild = CurrentBuild + 1
.Add "CurrentBuild", CurrentBuild
.Item("CurrentBuild").Value = CurrentBuild
End With

"david epsom dot com dot au" <david@epsomdotcomdotauwrote in
news:44***********************@lon-reader.news.telstra.net:
Have you tried it?

(david)

"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
>david epsom dot com dot au wrote:
>> Dim db As CurrentProject
Set db = Application.CurrentProject

db.Properties.Add strPropName, varPropValue

Is there some value/usefulness in setting a reference/pointer to
CurrentProject?

And "db"????
--
Lyle Fairfield
Aug 1 '06 #5
Yes...It works Great!

Thanks David

david epsom dot com dot au wrote:
Have you tried it?

(david)

"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
david epsom dot com dot au wrote:
Dim db As CurrentProject
Set db = Application.CurrentProject

db.Properties.Add strPropName, varPropValue
Is there some value/usefulness in setting a reference/pointer to
CurrentProject?

And "db"????
Aug 1 '06 #6
Useful to people porting DAO code, because those lines
are a direct replacement of the DAO lines in the standard
sample code. Using the same variable names helps show
where the alterations go.

Standard code uses a reference/pointer because the same
pointer is used for update code and then for add code
if the update fails.

(david)

"Lyle Fairfield" <ly***********@aim.comwrote in message
news:Xn*********************************@216.221.8 1.119...
Only in this way:
>"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@i3g2000cwc.googlegr oups.com...
>>Is there some value/usefulness in setting a reference/pointer to
CurrentProject?

And "db"????

--
Lyle Fairfield

Aug 2 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Magnus Andersson | last post by:
I really need some help with a Visual Basic problem. I am using Visual Basic .NET and want find some text with a certain style in an MS Office document. I have written something like: Dim oFind...
2
by: Arnold | last post by:
Hey there, I just put the following code: DoCmd.GoToRecord , , acLast in the On Open event of my form, which has 2 subforms. The following error message appears when the form now opens: ...
0
by: John Hunter | last post by:
I've recently had a nasty problem with the "Invalid reference to the property Form" error in subforms - nasty because it doesn't seem to consistently happen to all forms which contain the same...
1
by: Jordan Fee | last post by:
I'd like to perform some conditional formatting in the OnFormat Event of my Parent Report. This works fine, until my subreports are blank, then the invalid references start happening. I understand...
4
by: Bill Coan | last post by:
NOTE: This was posted earlier to vsnet.vstools.office under a different subject line but received no response. I'm having a problem automating Word's Find object from a .NET application, using...
2
by: David W. Fenton | last post by:
I think at various times we've all encountered this problem: A subform is on a main form. From the code of the main form we refer to some property of/control on the child form thus: ...
14
by: (PeteCresswell) | last post by:
I've got a form (frmDeal) that has a subform (frmDeal_Tranche) that has a subform (frmDeal_TrancheCusip). When I try to refer to properties on the "Cusip" form at the end of the chain, MS Access...
0
by: paulodonnell99 | last post by:
Hi, I am trying to build an installer application to run on the compact framework, I want to produce a netmodule using CSC.exe, then use AL.exe to embed resouce files and produce an exe. My...
3
by: MyWaterloo | last post by:
I am trying to open my purchase orders form and go to the last record. In the on open command I do: DoCmd.GoToRecord , , acLast Seems straight forward enough...but I keep getting this message...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.