Search results

The DB tracks a workflow. Different tables are different processes, and fields the steps of those process. The DB essentially tracks what has been completed, by whom, and when. For example: Table A is equipment maintenance... the fields are the steps required for maintenance. Table B...

Hello all, I've got a mental block on this one - and could use someone's help knocking it loose... I have a rather unusual application - but to simplify it: the user of the DB needs to be able to generate a "troubleticket" on any ID number (autonumber), from any field, on any table. Every...

Well - I got it to work, though not exactly in an elegant manner. By making three duplicate copies of the subform, and then nesting them one inside the other, they will all load and I can access all their controls. It would be much nicer to simply use one form three times (nesting within...

I tried setting focus to the subform control, but get a 2110 error which I guess means I cannot setfocus to a subform control. I also tried setting focus to the form itself... but still it only works to load the first subform, not the nested subform. I would give up were it not for the fact...

Did anything else look out of the ordinary in the file I attached?

Thanks for taking a look. I am going to basically use just that form and swap data in and out as you suggested (most of the data does not require the nested subforms). But how to do that with the data that required nested subforms... But what you said makes a lot of sense. I think it is...

Chris, I was afraid you would ask that... This probably opens a whole new set of problems... but what I am trying to do is dynamically manage my forms and subforms through settings in a table. The database is designed to manage and track a large workflow (tell the user to do this step first...

Ok - learned that access cannot index calculated fields... so this is not possible without allowing inconsistent updates. Thanks though, Bob, the link you provided is most useful and bookmarked...

Hello Access gurus... I have a subform that I initialize in different ways... I use a function to initialize the subform (a function because I on occassion I end up nesting subforms), but cannot figure out how to hand the result of the function back to the form. Dim frm As New...

Clarification: If I set up a query with no calculated value - everything works fine and I have read access. If I perform a calculation, it becomes read-only. This query can be updated: SELECT DISTINCTROW Sheets.* FROM (Sheets INNER JOIN QTest2 ON Sheets.ID = QTest2.ID2) INNER JOIN Lines ON...

That is an excellent reference! Thanks! Unfortunately, now I am more confused on this particular problem. I thought DISTINCTROWS was updatable, even though DISTINCT is not. And going through the rest of the list it is not obvious what is causing the read-only... unless it is related to the...

If I allow inconsistent updates it works fine. Not sure why since I have other similar queries that work with multiple tables and consistent updates... but this fix works.

First time posting - but have learned a lot from this forum in the past... a lot of talent out there! My DB entry is built around a single form that has specific behaviors. I feed it different SQLs to allow the user to access the different sections of the db. It has worked great until now... I...