The form shows this message when I attempt to update a field. In the 'Open' event, the VBA retrieves records based on criteria defined in the 'where' clause. ...
Thomas- It would help to see the Record Source of the form (the SQL if a query) and the code that's applying the filter. John Viescas, author Microsoft Office...
Connie- Tell the users they can enter a list of values: Hancock, Morris You probably don't want to train them to select "IN" as the operator, so your code will...
Hi Giorgio, are you opening the database on its own? Did you compile the code first? What references are checked or missing? from VBE --> Tools, References Do...
correction: to change what line executes next, right-click on a line and choose --> Set Next Statement Not all the procedures have error handlers, I will fix...
John, It seems like having several values in a field goes against normalization rules. Is there a benefit to this or reason to go this route? Also, our goal...
Connie Even though it's the 4th of July and my wife would kill me if she knew I snuck into my office to check email, I'm going to step in a bit here. You are...
John, The Record source of the form is blank - nothing. The Event procedure for the 'On Open' Set db = currentdb() Set ts = db.Openrecordset(strSQLSelect) ...
Thomas- Curious why you're not just doing: Me.RecordSource = strSQLSelect What I want to see is what's in strSQLSelect - the SQL defined there must be ...
Connie- Bill is correct, but in this case, you're creating an internal filter that the user will never see. I had forgotten that what the user sees is a...
Hi Crystal, yes the database is opened on its own and I decompiled it first and no references are missing and the checked ones are VBA, Access 12 object...
John-- Ah! I believe I've got it! The only thing I anticipate is that we will need to check/change the buyer's criteria from time to time. So is there a way...
Hi Giorgio, ... in debug mode, right-click on the next line, RESUME,and choose --> Set Next Statement then press F8 to go to the statement that is causing...
Connie- Well, you could include a multi-value field (horrors!) in which you store all the selected valued from the list box. It's a bit tricky in code because...
John, That's interesting. I didn't realize there are restrictions on select statements which cause the record set to be not updatable, where can I find more...
Thomas- In general, not updateable queries include: 1) Totals queries (GROUP BY, HAVING) 2) Queries that include a Totals query as a subquery 3) Any query...
John, You are correct. The query joins 2 tables to retrieve the resultant rows. I guess I will have to code 2 separate queries to get the row I need to...
Thomas- Why don't you post the SQL in a reply? We can help you see why it's not updateable and perhaps tell you how to fix it. John Viescas, author Microsoft...
This is not specific to one database. It appears my machine name is being entered into the lock file twice. Even if I open the database after first opening...
Thomas Put a break opint on the line right after that one and then type ?strSQL in the Immediate window and press Enter. That will print out the string as a...
99837
Embrey, Darrell
DEmbrey@...
Jul 5, 2012 7:51 pm
It's HP Support Services (formerly EDS). Darrell From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of...
Our guys are all in-house. They must have gone to the same training class as yours. No one seems to want to check specific problems anymore. We're going to...
Thomas That looks simple enough...only one table. Did you include the primary key? Without it or other required fields, it might be non-updatable. If...
Bill, Are you suggesting to go back to the original SQL (with a table JOIN) and modify the Set statement for the Recordset? According to John, the resultant...
Thomas As John said, certain queries are not updatable. Can you build the query with the joined tables in design view and then switch to SQL view and paste the...
