Doug Murphy
dw-murphy at cox.net
Fri Sep 20 16:59:49 CDT 2013
On further playing it was the ∆ in the control name that causes the error. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, September 20, 2013 2:44 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access error - A problem occurred while Microsoft Accesswas communicating with the OLE server or Active X Control. Found the problem. This application is for gathering and reporting on the chemistry in a water plant. The client gave me an excel file of the data they collect. I linked to the file and created a table from it. One of the fields had the character ∆ in the name. That is what was causing the problem. Thanks to your questions I took out half the fields and then started adding them back until I got the error. Good to have some outside thoughts. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, September 20, 2013 2:19 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access error - A problem occurred while Microsoft Accesswas communicating with the OLE server or Active X Control. This form has never worked. I am thinking it has something to do with the number of fields in the data source or on the form. Will see what happens as I add more and more fields to the form. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Friday, September 20, 2013 1:32 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access error - A problem occurred while Microsoft Accesswas communicating with the OLE server or Active X Control. Was it working before and now it's not -- for no apparent reason. Susan H. > Folks, > > This is driving me nuts. I created a new Access 2010, accdb database. > Created some tables. Created one form with one table as the recordsource. > The form has a total of 269 controls on it, labels, text boxes, etc. > There is no code on the form aside from a close button that runs 'Docmd.close'. > When I attempt to close the form using the button I get an Access error " > A -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com