UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> ? Query Datasheet , 2455 ,you Entered An Expression That Has An Invalid Reference To The Property Selheight., Access 2016    
 
   
pacala_ba
post Jan 16 2020, 07:45 AM
Post#1



Posts: 676
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi
i am using custom Table/query browse procedure
For tables it is working OK.

But by browsing queries , there is small Problem, pullhair.gif
if i am calling another procedure from datasheet.Row-toolbar after opening Table/Query
CODE
? screen.ActiveDatasheet.SelHeight
Err=  2455 ,You entered an expression that has an invalid reference to the property SelHeight.

after debugging i found this
CODE
ln_OpenObjType = acQuery
lc_TAB..query/table name
    DoCmd.Save ln_OpenObjType, lc_TAB   '...after this command , there are lost many Datasheet properties, Err=  2455 ,....
....
DoCmd.RunCommand acCmdSave ' the same  '...after this command , there are lost many Datasheet properties, Err=  2455 ,....

I am saving Table/Query Prperties to avoid Dialog...do you want to save changes..

Question: Why this happen only by Queries, and not by Tables ? iconfused.gif


--------------------
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th January 2020 - 10:56 PM