Eljefegeneo
Still trying to learn
- Local time
- Yesterday, 21:13
- Joined
- Jan 10, 2011
- Messages
- 904
Problem on Split DB
I have a split DB, front end on workstations, back end on server in my office. I have some very simple calculated fields inn unbound text boxes that have always displayed the correct data until recently. Now some of them will not display the data; some will when the field is clicked, some won't at all:
This is in the header of one form, will only display data if I click on the form:
These will not display any data even if I click on the field:
However, if I have the following in an unbound text box it will display:
I suspect it may have something to do with the local network, but before I spend money on calling the outside consultant – the server and its network is way beyond my expertise, I would like to know if anyone has any suggestions as to what might be causing the problem or how I might fix it myself with the Access program.
I have a split DB, front end on workstations, back end on server in my office. I have some very simple calculated fields inn unbound text boxes that have always displayed the correct data until recently. Now some of them will not display the data; some will when the field is clicked, some won't at all:
This is in the header of one form, will only display data if I click on the form:
Code:
="Client Has" & " " & DCount("[SequenceNumber]","qryCountBillingChanges","[ClientID] = " & [ClientID]) & " " & "Record(s) in Billing Changes With The Same Sequence #" & " " & [SequenceNumber]
Code:
=Sum([ReplySent]+1)
=Sum(Abs([ReplySent]))
Code:
=DCount("Name","qrylLetterWritersNotSentNoDupes","Duplicate=False")