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    
post Jan 16 2020, 07:45 AM

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

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
? screen.ActiveDatasheet.SelHeight
Err=  2455 ,You entered an expression that has an invalid reference to the property SelHeight.

after debugging i found this
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    19th February 2020 - 04:37 AM