Search results

...an insight I missed during my readings. This app will not require concurrency. But my habit is to avoid methods that obviate future features, so I shall take heed re Transaction. Temp table, then, also as Ranman256 also alluded to. I shall ponder my options, including limiting dirty to...

I'm beginning to think that the TRANSACTION is the most idiomatic way of getting the Undo, assuming bound forms where all the controls are paged, as in my case with the Tab Control. My research revealed the clone recordset method and the in-code array alternatives, but I believe this must be...

It's more likely 'tis I the one who knows not what he's doing. Yet another way to get to that double buffering idea...(?) My understanding of the convention for undo is a second recordset, rather than a second table. I've gone for 3NF and my queries involve joins of many tables. This led me to...

[I'm still an Access neophyte, so feel free to treat me as such :-)] I'm seeking advice on how to architect my in-progress, bound form design containing a tabControl. Whichever page of the tabControl is active, the user will move through the Recordset and may make edits to some records and only...

Indeed. ...well, one line doesn't count, does it.

Yes, just the Mainform and one Subform (in continuous mode). Anyway, good sir, updating the Subform's RecordSource was like balm for the aching, salve for a fester. IOW, this solved my issue. Thank you so much Mr. arnelgp! Uncanny how that triggers the magic refresh!

Thank you, arne lgp. Sorry, it's a bit convoluted... Private Sub cboSiteList_AfterUpdate() g_intFromParentForm = Me.cboSiteList.Value BuildFormQuery End Sub Function BuildFormQuery() Dim strSql As String strSql = "SELECT * FROM tblSitesDetail WHERE " & _...

Thanks all. I'll post again tomorrow upon returning to my workstation. In these posts I prolifically used "refresh" but meant "requery" in each case. --Bob

Well Pat, I was not sure what to place there. The Mainform's RecordSource seems to have no effect. The only thing on the Mainform is a combo box. It does the replacement of the query's SQL (the query that is the RecordSource for the Subform) and then triggers a Subform refresh. The...

​ I have a Mainform and one Subform. They both have the same query as their RecordSource. I dynamically update the SQL of that query via an event in the main form -- the AfterUpdate() of a combo box. I'm having a dickens of a time getting the Subform to Requery after that event fires. When I...

Jon, it seems only the first four of these point to a valid U2b video. Links decay over time, don't they. I'm in the US, could it be a regional issue, as BernieAnne above registered no complaints?

...another gem from this marvelous forum. I shall file this wisdom away. Thanks Pat.

You're hard core, Doc :--)

Thanks for the heads up, Paul.

This I understood from the previous replies. I do recall being on a project, at least 15 years ago now, where Access was FE to SQL Server. The db designer liked the ease and friendliness of the query side, including ad-hocs, IIRC. I was directly involved on the server side because my data...

Phew, takes me back. You ARE an old programmer :--) I'm a young programmer (okay, I'm in a state of denial!). The bulk of my DEC experience was under PDP-11 RSX-11. Thanks, Doc, for the additional perspective. I understand it all, so, no further questions. ...well, until I'm fully into the...

OMG, thanks Pat. So very helpful! --Bob

That's a very fine thing to know, thanks ridders. I think it's a good solution, at least for the demo that my client and I will iterate on during the specs development phase. For the production version of the app, I was recommending emulation of his legacy Word doc as a backup in case of server...

Thanks for jumping in, Pat... That was a deployment phase-two aspiration. That does put me into a bit of a quandary. Are there any local net (i.e., hard-wired ethernet) options with Access? I'd even consider behind the router WiFi (only two workstations, in the same building -- a private home)...

Doc, I'm grateful for such an expansive reply to an OP I worried was too meandering. I suspected this to be the case. I was bewildered by what seemed to be two or three possible architectures with a couple different automation libs (OLE, DDE) to choose from. I should have written "large text"...