I found the error, and it works well now. I know I have probably hit my limit
for questions, but last one. A persistent problem from the beginning has been
this dbs tendency to crash while entering results. This is the message I get:
Access has encountered a problem and needs to close.
AppName: msaccess.exe AppVer: 11.0.6566.0 AppStamp:42cdb33e
ModName: unknown ModVer: 0.0.0.0 ModStamp:00000000
fDebug: 0 Offset: 0d4901bd
This only occurs when I am entering survey data. I thought it was something
I did, but I went back to the original model and used that and I still get
the same problem. The entry form is linked to the event procedure each time a
new resonse is entered, and I can't enter more than one or two results before
it dies. Could it be a problem with the form itself or the action? It only
happens after I click new response, but not every time. The event procedure
is:
Private Sub cmdAdd_Click()
On Error GoTo Err_cmdAdd_Click
DoCmd.GoToRecord , , acNewRec
Exit_cmdAdd_Click:
Exit Sub
Err_cmdAdd_Click:
MsgBox Error$
Resume Exit_cmdAdd_Click
End Sub
Thanks again
:
Can you provide the SQL view of the query that is causing the error message?
--
Duane Hookom
Microsoft Access MVP
:
I want to thank everyone for coming together and trying to solve my problem.
I think there is still something wrong with the copy I have. I went to the
report and traced its lineage, as it is based on a select query, which is
based on the associated qxtb query, based on a few of the tables. I have
corrected the error (which I don't believe existed, but I copied and pasted
just to be sure) and I still get the same error. I have triple checked the
syntax in the affected criteria areas, and they are correct yet the error
persists. Any additional suggestions before I take this line by line and
rebuild fresh using the wonderful model Duane built?
:
Thanks John. I believe you have hit the nail on the head. I'm not sure
why but I have experienced Access changing the bracketing of
parameters during upgrading from one version to the next. John's
suggestion should work.
Duane Hookom
MS Access MVP
The bracketing should be
[Forms]![fmnuReportSelect]![cboSrvID]
You will need to find where the invalid bracketing is occuring. It
usually is in the Parameters section of a query. So I would open the
relevant query or queries in SQL view and look at the beginning of the
query. If it start with Parameters ... then check the Parameters
section and edit it if necessary
Parameters [Forms!fmnuReportSelect!cboSrvID] Text (255);
SELECT ...
Would need to be changed to
Parameters [Forms]![fmnuReportSelect]![cboSrvID] Text (255);
SELECT ...
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
debinnyc wrote:
I am still having problems. I re-downloaded the copy and imported only the
structure of the database, no data. I successfully added the new table for
employees, and was able to link the associated surveys to each employee being
surveyed. Now, whenever I try to run the existing reports, I get the
following error:
Error 3126 Invalid bracketing of name '[Forms!fmnuReportSelect!cboSrvID]'
Now I am not sure if I did something, or I still have a bad file because I
was seeing this error before.
Is there anyone who can contact Mr. Hookom (or someone who has the file) and
assist? I really want to be able to learn how to do this, but I am faced with
having done this three times now, completely from the structure with no
results. Any help you can provide would be greatly appreciated.
:
Sounds as though your copy may have got corrupted.
Try downloading a new copy and see whether it still has the same problem.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
Thanks for the quick response!
I think I found the problem, one of the select queries (that a summary
report is based on) that collects the responses is creating the following
symbols instead of pulling the data from the table:
?
?
etc.
I checked the associated tables and the data is correct in the table. The
data being pulled "rspns" are in the format 5 - Excellent, 4 - Very Good,
etc. Could that be the problem? Should I change the response to 5 alone
and
quantify that response somewhere else? If this is described
insufficiently,
let me know what else you need. Here is the select query that is
malfunctioning:
SELECT DISTINCTROW qxtbQstnTextRspnsxCount.*, tblSurveys.SrvName,
tblSurveys.SrvDescription
FROM tblSurveys INNER JOIN qxtbQstnTextRspnsxCount ON tblSurveys.SrvID =
qxtbQstnTextRspnsxCount.SrvID;
Thanks again.
:
I've heard of no reports of instability with Duane's survey tool. You
might
try creating a new database and importing everything from the copy you've
got: that sometimes clears up problems. You could also try Decompiling:
Tony
Toews has instructions athttp://
www.granite.ab.ca/access/decompile.htm
I don't have a copy of the survey tool on this machine, but I would
assume
that there's a table that contains one row for each survey responder.. You
could add a key pointing back to your Employee table to that table.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
I am using the survey database template at your survey created by Duane
Hookom. I am hoping he (or someone else that knows the file) can help
me,
as
I have posted several questions in the past and received no response.
First, I would like to add a table to link the surveys back to
particular
employees (if identified by the customer). I have created a table as
such:
tblEmployees
Employee ID autonumber pk
First name text
Last name text
phone number, etc.
Second, in using the database and simply entering data the program
keeps
terminating on its own, and says the program has to restart. Are there
any
known instabilities with the file? I am not sure what I can provide
related
to this to determine the problem.
Thanks- Hide quoted text -
- Show quoted text -