Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dsum form problem - MSACCESS remains open

Status
Not open for further replies.
redbase

redbase

Technical User
Nov 21, 2002
21
GB
I am using an unbound textbox with a Dsum calculation as the source to work out totals on an access form. The Dsum is a follows:

=DSum("[SumofDaysLost]","qrySickCount","StaffID =[SickList].Form![StaffID]")

The problem I have encountered is that with this calculation on the form I have trouble closing Access as it causes the MSACCESS.EXE process to remain open.

Is there a way that I can prevent this from happening?

Thank you.


 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
244
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
201
TrekBiker
TrekBiker
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
166
renigar
renigar
caykamanj1966
  • Locked
  • Question
Continuous Form Updating
Replies
1
Views
126
dhookom
dhookom
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
154
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top