Home

Data Form

%3CLINGO-SUB%20id%3D%22lingo-sub-771823%22%20slang%3D%22en-US%22%3EData%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20files%20that%20utilize%20the%20Data%20Form%20and%20Data%20Queries.%20Last%20week%2C%20the%20data%20form%20in%20both%20of%20these%20files%20stopped%20working.%20When%20I%20click%20the%20Form%20button%20in%20the%20ribbon%2C%20excel%20crashes.%20When%20I%20click%20my%20activex%20button%20with%20the%20.ShowDataForm%20VBA%2C%20a%20second%20button%20pops%20up%20while%20i%20am%20holding%20the%20button%20down...if%20i%20click%20that%20one%20while%20it%20is%20popped%20up%20excel%20crashes.%20If%20i%20run%20the%20line%20of%20code%20directly%20from%20the%20VBA%20Editor%2C%20I%20get%20the%20following%20error%20message%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BRun-time%20error%20'-2147417848%20(80010108)'%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20Automation%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20The%20object%20invoked%20has%20disconnected%20from%20its%20clients.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20around%20the%20time%20this%20stopped%20working%2C%20our%20company%20had%20a%20network%20upgrade%20where%20all%20of%20our%20IP%20addresses%20were%20changed.%20I%20thought%20this%20might%20be%20the%20cause%20of%20the%20problem%20so%20i%20remade%20these%20files%20and%20copied%20the%20data%20over.%20The%20file%20worked%20for%20me%2C%20opening%20and%20closing%20them%20until%20another%20employee%20opened%20the%20file%20on%20another%20computer.%20This%20broke%20BOTH%20of%20the%20files%20even%20though%20they%20only%20opened%201%20of%20them.%3C%2FP%3E%3CP%3EThe%20data%20queries%20only%20reference%20tables%20within%20the%20same%20file%2C%20so%20I%20am%20not%20sure%20if%20they%20are%20part%20of%20the%20problem.%20The%20other%20odd%20thing%20is%20that%20if%20I%20convert%20the%20tables%20to%20normal%20ranges%2C%20then%20the%20Form%20button%20works.%20AND%20I%20can%20create%20a%20new%20table%20and%20the%20Form%20button%20will%20work%20for%20those%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-771823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
nmonte365
Visitor

I have 2 files that utilize the Data Form and Data Queries. Last week, the data form in both of these files stopped working. When I click the Form button in the ribbon, excel crashes. When I click my activex button with the .ShowDataForm VBA, a second button pops up while i am holding the button down...if i click that one while it is popped up excel crashes. If i run the line of code directly from the VBA Editor, I get the following error message:

 

     Run-time error '-2147417848 (80010108)':

    Automation error

    The object invoked has disconnected from its clients.

 

Right around the time this stopped working, our company had a network upgrade where all of our IP addresses were changed. I thought this might be the cause of the problem so i remade these files and copied the data over. The file worked for me, opening and closing them until another employee opened the file on another computer. This broke BOTH of the files even though they only opened 1 of them.

The data queries only reference tables within the same file, so I am not sure if they are part of the problem. The other odd thing is that if I convert the tables to normal ranges, then the Form button works. AND I can create a new table and the Form button will work for those tables.

 

Any help would be appreciated.
 

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies