Go Back   Access World Forums > Search Forums

 
Showing results 1 to 22 of 22
Search took 0.01 seconds.
Search: Posts Made By: AvantGuy
Forum: General 10-13-2018, 01:30 PM
Replies: 7
Views: 495
Posted By AvantGuy
Re: In a Tab Control moving thru Recordset, dirty/undo questions

...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...
Forum: General 10-13-2018, 07:59 AM
Replies: 7
Views: 495
Posted By AvantGuy
Re: In a Tab Control moving thru Recordset, dirty/undo questions

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...
Forum: General 10-13-2018, 07:58 AM
Replies: 7
Views: 495
Posted By AvantGuy
Re: In a Tab Control moving thru Recordset, dirty/undo questions

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,...
Forum: General 10-12-2018, 09:11 AM
Replies: 7
Views: 495
Posted By AvantGuy
In a Tab Control moving thru Recordset, dirty/undo questions

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...
Forum: Forms 04-19-2018, 06:07 PM
Replies: 12
Views: 418
Posted By AvantGuy
Thumbs up Re: Troubles Referencing Subform from Mainform; Requeries

Indeed. ...well, one line doesn't count, does it.
Forum: Forms 04-18-2018, 10:48 AM
Replies: 12
Views: 418
Posted By AvantGuy
Re: Troubles Referencing Subform from Mainform; Requeries

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....
Forum: Forms 04-18-2018, 08:29 AM
Replies: 12
Views: 418
Posted By AvantGuy
Re: Troubles Referencing Subform from Mainform; Requeries

Thank you, arne lgp. Sorry, it's a bit convoluted...

Private Sub cboSiteList_AfterUpdate()
g_intFromParentForm = Me.cboSiteList.Value
BuildFormQuery
End Sub

Function BuildFormQuery()...
Forum: Forms 04-17-2018, 11:27 PM
Replies: 12
Views: 418
Posted By AvantGuy
Re: Troubles Referencing Subform from Mainform; Requeries

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
Forum: Forms 04-17-2018, 08:33 PM
Replies: 12
Views: 418
Posted By AvantGuy
Re: Troubles Referencing Subform from Mainform; Requeries

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...
Forum: Forms 04-17-2018, 07:06 PM
Replies: 12
Views: 418
Posted By AvantGuy
Troubles Referencing Subform from Mainform; Requeries


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...
Forum: Microsoft Access Tutorials 03-31-2018, 04:09 PM
Replies: 16
Sticky: Video Tutorials
Views: 30,658
Posted By AvantGuy
Re: Video Tutorials

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?
Forum: General 03-28-2018, 01:27 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

...another gem from this marvelous forum. I shall file this wisdom away. Thanks Pat.
Forum: General 03-28-2018, 01:24 PM
Replies: 19
Views: 993
Posted By AvantGuy
Forum: General 03-28-2018, 01:21 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

Thanks for the heads up, Paul.
Forum: General 03-28-2018, 10:06 AM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

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...
Forum: General 03-27-2018, 09:21 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

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...
Forum: General 03-27-2018, 09:01 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

OMG, thanks Pat. So very helpful!

--Bob
Forum: General 03-25-2018, 01:58 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

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...
Forum: General 03-25-2018, 01:45 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

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...
Forum: General 03-25-2018, 12:49 PM
Replies: 19
Views: 993
Posted By AvantGuy
Re: Help Architecting MSWord as Access Front

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...
Forum: General 03-24-2018, 06:56 PM
Replies: 19
Views: 993
Posted By AvantGuy
Help Architecting MSWord as Access Front

My first post here; I'm nothing close to a seasoned MSOffice developer. Since this application doesn't seem unusual, I figured there are use-cases out there, but I couldn't find anything that seemed...
Forum: Introduce Yourself 03-24-2018, 06:52 PM
Replies: 1
Views: 269
Posted By AvantGuy
Greetings from Southern Colorado

I'm a bit of a fish-out-of-water here. I've been a process-control, telecom data acquisition, mostly embedded systems, C/C++ realtime operating system kind of bloke for decades. I'm not even close...
Showing results 1 to 22 of 22

 
Forum Jump



All times are GMT -8. The time now is 07:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World