Re: Unbound Nested Subform Simulating Continuous Form

Bri,

Thanks.

Have included temp table and array in options for converting from the
Optionbuttons & Checkboxes entries/combinations.

Am now trying to determine best way to loop through optionbutton, checkbox
and textbox controls on the nested
subform to form the record (either directly or via a temp table or array) to
add to the underlying tblProjectProducts using
Insert Into... query



"Bri" <not@xxxxxxxx> wrote in message news:aqfuf.9354$tl.2103@xxxxxxxxxxx
>
> Robert wrote:
>> Allen,
>>
>> Started with a bound subform but switched to using an unbound subform for
>> better error control, more control over saving records (single button on
>> parent subform) and for more user friendly data capture (option buttons &
>> check boxes rather than combo boxes on continuous subform).
>>
>> Parent subform has "Project" (one) details and nested subform has (many)
>> "Products" that can be selected via option buttons or check boxes and
>> layout of the form is not on a one record (Product) per row basis.
>
> I understand your issue and I have a different approach to solving it. I
> create a temp table (in a temp database - linked) that I then use in the
> bound subform. The Save button then does an Update query that moves the
> data from the temp table to the permanent table. This gives me the
> flexablility that a bound form gives with the ability to save all the
> changes or none of the changes (like a transaction commit or rollback but
> in a form rather than in code).
>
> --
> Bri
>


.

Relevant Pages

  • RE: How to program Subform as select list
    ... Hey Thanks for the response Barry. ... then rebuilt my subform to use a combo box to ... What i do is i have a temp table (on the Front end if you have a split ... Private Sub ButtonClearList_Click ...
    (microsoft.public.access.formscoding)
  • Help with Master/Detail UI in ADPs
    ... temp table for the Detail rows with OK, Apply and Cancel buttons on these ... from the unbound fields to the Master table on the server and from the local ... bind it to the Detail subform. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Different @@SPID for same user/connection ?!?!?!
    ... you could create temp tables named after the current user? ... connection to retrieve the data source of a subform." ... the sub-forms display the contents of a specific record. ... I use @@SPID, also in the stored procedures which I use to load/save ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Form OnClose vs. subform BeforeUpdate validation: the showdown
    ... I think the subform current event only fires on a record change (and ... Validate automatically, but do an end-run around the Access event ... records in the temp table. ... to cancel the main without validating the sub. ...
    (comp.databases.ms-access)
  • Re: Importing data from a textfile
    ... I don't know how many different types of string there are beforehand. ... temp = textscan; ... You can use it to break an arbitrarily long comma delimited list into a cell array of parts, then operate at will on the parts. ... Another think you might experiment with to speed things up is to read the entire file into memory with the 'fileread' command, and then use regex and cellfun to search the contents in memory. ...
    (comp.soft-sys.matlab)