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
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies