ACCESS FEED: Re: [MS_AccessPros] Re: Using subforms that are split forms

Rod,

Further to my previous post, for each copy of main form, it would also be necessary to have separate copies of datasheet & reference suforms. For example:

Say your forms meant for single form portion of split form are F_1 and F_2
Create copies of sample form F_Main as F_Main_1 and F_Main_2
Create copies of sample form FSub_DS as FSub_DS_1, FSub_DS_2
Create copies of sample form FSub_Ref as FSub_Ref_1, FSub_Ref_2

On first page of tab control:
Place form F_Main_1
Assign form F_1 as source object for top subform control SF_A
Assign form FSub_DS_1 as source object for bottom subform control SF_B
Assign form FSub_Ref_1 as source object for hidden subform control SF_Ref

On second page of tab control:
Place form F_Main_2
Assign form F_2 as source object for top subform control SF_A
Assign form FSub_DS_2 as source object for bottom subform control SF_B
Assign form FSub_Ref_2 as source object for hidden subform control SF_Ref

Note:
Hidden subform control SF_Ref is located at top left corner of F_Main.
Before taking up multiple split forms, you might like to first get thoroughly well versed and fluent with the arrangement having single split form.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: A.D. Tejpal
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 29, 2012 09:41
Subject: Re: [MS_AccessPros] Re: Using subforms that are split forms - revisit

Rod,

If you wish to display separate split forms (as per my sample db) with different data sources on multiple tabs, you can make required number of copies of the main form under different names e.g. F_Main_A, F_Main_B etc, and place these on individual tab pages.

Separate single forms can be assigned as source object for top subform control of respective main forms. Class and general modules, as already existing in the sample, would take care of multiple forms.

Yes - my samples are completely free. Persons making use of such samples can render service to access community by providing feedback so that further enhancements if any, could be incorporated.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: rodbevill
To: A.D. Tejpal
Sent: Wednesday, August 29, 2012 08:40
Subject: SplitForm Simulated Question

I have started working with your splitform simulation as you recommended on a resent post I submitted. It appears that it will do the job. However, I have a question. I have tried using one copy on my app inside a tab ctrl but would like to add others to a couple of the tabs. Can the form be used on multiple tabs or will I need to make copies and rename each with their own support files?

Currently reading your design and since I am less than an expert it may take me some time to understand everything. I understand this is your design. Is it fee based or public domain? Again thanks for the response to my post.

Rod

----- Original Message -----
From: rodbevill
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 29, 2012 05:17
Subject: [MS_AccessPros] Re: Using subforms that are split forms - revisit

Crystal, I approach is to use the split style form in the tab control so the user can see the records associated with the particular tab. The user can then select a record from the for edit or add a new
record. The record being edited would be displayed in the form view. When adding a new record the form would show blank fields that would be populated for the record creation. By creating the split
form manually, I thought I could satisfy the requirement.

In the approach you described would it be possible to have the datasheet view that would allow the user to switch to a single form (programmatic) to edit or add new record then switch back to the
datasheet view when completed. I am trying to set up the application to a very simple interface because the users don't have much experience with database apps and prefer point and click.

In the app, all the tabs ctrls will work similarly. So 5 tabs have been identified all linked thru taxpayer id.

Hope I am making sense and any suggestions would be greatly appreciated.
Rod

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> thanks for clarifying, John :)
>
> Rod, I am not sure that using the same RecordSource will generate the same bookmark ... are you assigning one RecordSource from the other or are they independent ? Also, it would be a good idea to make one of the RecordSources snapshot (no edits) since you are opening more than one.
>
> Why not simply allow datasheet view and form view? Just takes a moment to switch ... personally I like this better if there is lots of data because I look at the forms differently. Then I throw a bunch of combos to find records in the header of the single form.
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: John Viescas <JohnV@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, August 27, 2012 10:37 PM
> Subject: RE: [MS_AccessPros] Using subforms that are split forms - revisit
>
> Rod-
>
> Yes, having no data might be something to do with it. Also, the sequence of
> forms loading when you have forms / subforms can sometimes be a bit strange. It
> is possible to have the subform load first (Load, Current events fire) *before*
> the parent form is there. Consider adding an On Error Resume Next in the code
> that assigns the bookmark to avoid attempting to assign the bookmark before the
> "parent" form is there.
>
> Crystal-
>
> Rod can't use a split form in this case because he's wanting to embed it as a
> subform. Split forms display the Single Form view part only when embedded as a
> subform. He is "emulating" a split form by embedding a Datasheet form on his
> Single View form.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
> Sent: Tuesday, August 28, 2012 6:11 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Using subforms that are split forms - revisit
>
>
>
> Hi Rob,
>
> bookmarks are temporary numbers based on a particular recordset -- they are NOT
> record numbers. Can you explain
>
>
> > I thought the datasheet view would use the other have the split
> > form as the parent. Is this a wrong assumption?
>
>
> yes, it is wrong. both forms use Me. Look where the code is ...
>
>
> in a split form, the top and bottom will synchronize automatically
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
> ________________________________
> From: rodbevill <desertscroller@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, August 27, 2012 7:42 PM
> Subject: Re: [MS_AccessPros] Using subforms that are split forms - revisit
>
> My main form contains information about a taxpayer (sales tax). This form
> contains a Tab Control with several tabs. The first tab contains information
> about property being taxed. This property form
> was created as a split form manually. The top view is various bound controls.
> The lower half of the split form is a datasheet view.
>
> When the application is opened as error occurs within the split form. The error
> message is as follows:
> Run-time error '3159':
> Not a valid bookmark.
> on line
> Me.Parent.Bookmark = Me.Bookmark
> Currently the database tables are blank (no data) I suspect that this may be the
> issue. Each of the tabs are designed the same and may cause the same issue. If
> blank data is the issue is there a simple fix because as new taxpayers are added
> the associated tables would have no data until either imported or manually
> entered.
>
> Hope this explains the issue.
> Rod
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Rod-
> >
> > I'm having a hard time picturing what you've done. Even when you put a
> Subform
> > control on a Tab control, the "Parent" of the form inside the Subform control
> is
> > still the outer form. Is the "split" form (form + subform) now in a subform
> on
> > a tab in some other form? Should still work fine. Which exact statement is
> > getting the error, and what is the complete error text?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
> > Sent: Monday, August 27, 2012 5:29 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Using subforms that are split forms - revisit
> >
> > I have developed a split form using the manual approach described in an
> earlier
> > post. The main form is defined as a single form then a second copy is created
> > using the datasheet view as the default. This datasheet view is added to the
> > single form to create the split form. The link fields are blank and the
> > following code is use in the current method of the datasheet view:
> >
> > Private Sub Form_Current()
> > ' If on a new Record,
> > If Me.NewRecord Then
> > ' Move the outer form to a new record
> > Me.Parent.SetFocus
> > RunCommand acCmdRecordsGoToNew
> > Else
> > ' Sync the outer form by copying the Bookmark
> > Me.Parent.Bookmark = Me.Bookmark
> > End If
> > End Sub
> >
> > This process appears to work fine with the form is opened. However, when I
> add
> > the split form to tab control on the main application form I get an error 2449
> > invalid method. I thought the datasheet view would use the other have the
> split
> > form as the parent. Is this a wrong assumption? If so what would I call the
> > other half of the split form once it is added to the Main application?
> > Currently no data has been entered into the system, just trying to get the
> > initial system to accept data with new data by user.
> >
> > Rod

[Non-text portions of this message have been removed]