Recent content by dmillj

Remou, Thanks. I tried some of things on the website but they did not work. It looks like it may be quicker to import the non-corrupt files to a new database and remake the form and report that are corrupt. Thanks, dmillj

When I try to open my MS Access 2000 database, I receive the following error: "9 errors occurred when you loaded the form or report" followed by "You loaded a form or report that has controls or properties that Microsoft Access doesn't recognize and will ignore". I have been using the...

I am geeting the following error in my database: The LinkMasterFields property settting has produced this error: 'A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control' My database will work for about an hour than this error occurs not allowing any...

PH, Thanks for the quick response, that seems to do the trick. dmillj

I submitted a similar post about two months ago. I am trying to average five fields in a query which are named [Result 1], [Result 2], [Result 3], [Result 4], and [Result 5]. I received the following code from PHV which worked great for (4) result fields, but now when I try to use the same code...

PVH, Awsome! This works perfectly. Thanks for your help!!

PHV, To show my complete ignorance of writing code, where would I put the code that you posted? Does that get entered into the 'On Click' event for the average field in my results 'Form', or does it get entered into the query? Thanks.

Thanks everyone for your quick response and great suggestions. PHV, I have a question regarding the code you posted since I am new to writing code. Am I able to use the code as is, or do I need to add in my fields that I want to calculate? If I need to add in my [result] fields, can you show...

I have a query in which I am gathering measurement history. I have four fields named as follows: Result 1; Result 2; Result 3; Result 4. What I am trying to do is add the four result fields together and divide by four to get the average. I know how to do this much, my problem lies when one...