I'm working in Access 2000, and everything was running great till yesterday....on my forms I have a simple count record calculation. i.e.
=" The Number of Customers for this Educational facility = " & " (" & Count(*) & "" & ")"
every time I'd open a form it would tell me how many records I had, this calculation is attached to sub forms as well. Yesterday I loaded the database onto the users server, I linked tables from his database and I then made a shortcut and started testing it on one of the user desktop. The test went well, so I grab the short cut and placed it onto a different desktop D'oh! suddenly the calculation field wasn't appearing at the top of the form, then when I click on a button to get to the sub form, crazy things started happening, the check boxes on the sub form start blinking uncontrollably, at the bottom of the sub from was a message "Calculating......"
Does anyone know what would cause this????? Thanks in advance
=" The Number of Customers for this Educational facility = " & " (" & Count(*) & "" & ")"
every time I'd open a form it would tell me how many records I had, this calculation is attached to sub forms as well. Yesterday I loaded the database onto the users server, I linked tables from his database and I then made a shortcut and started testing it on one of the user desktop. The test went well, so I grab the short cut and placed it onto a different desktop D'oh! suddenly the calculation field wasn't appearing at the top of the form, then when I click on a button to get to the sub form, crazy things started happening, the check boxes on the sub form start blinking uncontrollably, at the bottom of the sub from was a message "Calculating......"
Does anyone know what would cause this????? Thanks in advance
