423,309 Members | 2,163 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,309 IT Pros & Developers. It's quick & easy.

Button Control on Tab-Control Pages

P: 25
I have a single form with a Tab Control containing 4 tabs with list boxes on 2 tabs. I have navigation tabs on the first tab and it controls all the tabs. The list boxes contains different data.

I want the navigation tabs to work only in tabs 1 and 2 but a second navigation tab to work on tabs, 3 and 4.

How do I go about that?
Jul 12 '18 #1
Share this Question
Share on Google+
51 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,532
ijared,

I would love to help, but your description is a bit confusing.

I know what a Tab Control is, but what do you mean by "navigation tabs"?

Is this within the confines of a Navigation Form?

Any additional information you can provide would help guide us to a solution.
Jul 12 '18 #2

P: 25
It is the Navigation Buttons that starts with First Back Next Last New to create or edit records.
Jul 12 '18 #3

twinnyfo
Expert Mod 2.5K+
P: 2,532
ijared,

This is not helping much.

At this point, I have no idea whatsoever what you are talkling about.

There are Navigation Forms--which is a type of form) and there are Navigation Controls that can be displayed on your ordinary forms. You can also create Command buttons that perform the same functions as the Navigation Controls.

However, you still haven't explained anything about the navigation buttons/tabs/controls being on the first tab of your Tab Control, nor what you are really trying to do.

You have to give us ample information if you want any type of assistance on this forum.
Jul 12 '18 #4

NeoPa
Expert Mod 15k+
P: 30,996
TwinnyFo:
You have to give us ample information if you want any type of assistance on this forum.
Or anywhere. That's the point.

We don't demand you work for your supper. We merely request the most basic understanding of what you're trying to ask about. No-one anywhere can help you unless you express what it is you want help with. We're not here to demonstrate psychic abilities.
Jul 12 '18 #5

zmbd
Expert Mod 5K+
P: 5,279
From ijared second description it sounds like the record-navigation controls


iJered
Open your form... windows 7 and newer has the Snipping tool, use that tool to capture an image of your form.

Under the reply box there is a button labeled [Advanced]


click on this button which will take you to the advanced post editor where you can upload the image to your post...


please don't use links to third-party image sites as these are often blocked by company firewalls - upload image from your PC to the site.

In this case, a picture will be worth a thousand words!
Attached Images
File Type: jpg BoundFormRecordNavigation.jpg (18.3 KB, 282 views)
File Type: jpg forumAdvanced.JPG (16.0 KB, 285 views)
File Type: jpg attach.jpg (16.8 KB, 287 views)
Jul 13 '18 #6

P: 25
It directs the images I have on the different tabs. I want the navigation tabs to work only for 1 and 2 tabs and a second button to control tabs 3 and 4 but a second navigation tab to work on tabs, 3 and 4.

Attached Images
File Type: jpg navigation buttons.jpg (18.2 KB, 275 views)
Jul 13 '18 #7

twinnyfo
Expert Mod 2.5K+
P: 2,532
I want the navigation tabs to work only for 1 and 2 tabs and a second button to control tabs 3 and 4 but a second navigation tab to work on tabs, 3 and 4.
Please explain what you mean, as you have mentioned this before and it didn’t make sense either. Your picture, although it might have helped, now adds more confusion, because you have now shown us TWO sets of navigation buttons.

Please provide more details of what you are trying to do, not just repeating what we don’t understand.
Jul 13 '18 #8

zmbd
Expert Mod 5K+
P: 5,279
@ ijared
While I appreciate the effort to provide only the pertinent parts of your form - what I asked you for was a FULL capture of your form so that we can see what you have done.

Also do you understand what the main intent of the TabControl was originally designed for? Are you using subforms within your TabControl?

@ twinnyfo
:)
Piecing together what we have:
- I would appear that OP has found a form or control that is similar to what is needed
- From the sniped image it looks like a Main Form with some home-grown-record-navigation buttons (HGRN)with the HGRN siting on main form and OP has neglected to remove the standard form-record-navigation when the TabControl was inserted on the main form

!! now for the huge guess
OP wants one set of HGRN to work for
Me.ctrlTab.Pageindex = 1 and 2

and a different set of HGRN for
Me.ctrlTab.Pageindex = 3 and 4


There is really no need for a second set of HGRN as one can simply pull the index:
https://bytes.com/topic/access/answe...tab-active-vba
and then perform a set of actions depending on the active page.

You can get a bit more granular by naming the tab-pages and calling them directly... FMSINC has a nice tutorial and a sample database that shows this code.
FMS: Reference Tab Pages by its PageIndex Rather than Tab Value on Microsoft Access Forms

I further suspect that the native record controls need to be hidden; however, without the full form image capture it's impossible to tell.
Jul 13 '18 #9

NeoPa
Expert Mod 15k+
P: 30,996
BTW As FMS Inc is a web page provided by another Access MVP (My friend and colleague Luke Chung) I believe that linking to there is acceptable.
Jul 14 '18 #10

P: 25
Hi,
I hope this image will help. As I said before, I want the navigation tabs to work only for 1 and 2 tabs and a second button to control tabs 3 and 4.but a second navigation tab to work on tabs, 3 and 4.
ijared

Attached Images
File Type: jpg test22.jpg (62.2 KB, 273 views)
Jul 14 '18 #11

twinnyfo
Expert Mod 2.5K+
P: 2,532
Apparently we are not making ourselves clear enough. Your description still does not make any sense.

As I said before
The first few times you said the same thing, and we still don’t understand. Perhaps describe it differently, rather than saying the same thing and assuming we will somehow figure out what you mean.

I want the navigation tabs to work only for 1 and 2 tabs
What are “navigation tabs”?? If all your tabs are linked to the same set of records, then it doesn’t matter, and navigation will affect all tabs.

a second button to control tabs 3 and 4
Is this “button” the same as your “navigation tabs”? Consistent language is not just helpful, it is a necessarily when working on a forum like this. Concerning just tabs 3 & 4, see above.

but a second navigation tab to work on tabs, 3 and 4.
Is this a typo? Is this something different than your “second button”? Is this another control? What is a “navigation tab”?

I hope you can appreciate the immense level of patience many of the experts on this forum have already exercised with this thread. Believe it or not, we really do want to help you. However, every time we ask for additional details, you never answer our questions directly and seem to only restate what you have already stated. We cannot help you if you don’t provide us meaningful descriptions of what we ask for.
Jul 14 '18 #12

PhilOfWalton
Expert 100+
P: 1,290
Unlike Neopa, I am psychic ( well partially).

I think what ijared wants is to show his custom command buttons for "First", "Next", "Back" & "Last" only when Pages 1 and 2 of his Tab control are active.

I am not psychic enough to understand on which pages he wants to display "Delete" & "New"

"but a second navigation tab to work on tabs, 3 and 4." eludes me completely.

If, ijared, when you reply, please use the correct terms, and then we will be able to help.

At the bottom of your form you have 6 Command Buttons:- "First", "Next", "Back", "Last", "Delete" & "New"

The 4 items at the top of the form which I can't read but start with "vo" or "No Longer" are Pages on a Tab Control

If you click immediately to the right of the last page "Volutoor #" the property box will confirm that you are on a Tab Control

Phil
Jul 14 '18 #13

P: 25
Sorry for the disturbance it is taking. The navigation tabs are the 6 Command Buttons:- "First", "Next", "Back", "Last", "Delete" & "New" showing in the picture and I understand that the navigation will affect all tabs.
I waant it to affect only the first 2 tabs so the 3 and 4 tabs will not be affected.

My command buttons have the follwing codes:
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdBack_Click()
  2.     On Error Resume Next
  3.     DoCmd.GoToRecord , , acPrevious
  4. End Sub
  5.  
  6. Private Sub cmdFirst_Click()
  7.     On Error Resume Next
  8.     DoCmd.GoToRecord , , acFirst
  9. End Sub
  10.  
  11. Private Sub cmdLast_Click()
  12.     On Error Resume Next
  13.     DoCmd.GoToRecord , , acLast
  14. End Sub
  15.  
  16. Private Sub cmdNew_Click()
  17.     On Error Resume Next
  18.     DoCmd.GoToRecord , , acNewRec
  19. End Sub
  20.  
  21. Private Sub cmdNext_Click()
  22.     On Error Resume Next
  23.     DoCmd.GoToRecord , , acNext
  24. End Sub
To PhilOfWalton,
The last tab says No Longer Volunteer. It's just a title.
ijared
Jul 15 '18 #14

NeoPa
Expert Mod 15k+
P: 30,996
IJared:
I want it to affect only the first 2 tabs so the 3 and 4 tabs will not be affected.
In that case convert the code to use the VBA objects rather than the DoCmd macro commands. It does mean you'll have to issue each command for both Pages though. There are no Tabs. Tab Controls have Pages, not Tabs.
As an example, your cmdFirst_Click code might look something like :
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdFirst_Click()
  2.     With Me
  3.         Call MoveRec(frmMe:=.{NameOfSubformOnTab1}.Form, strType:="First")
  4.         Call MoveRec(frmMe:=.{NameOfSubformOnTab2}.Form, strType:="First")
  5.     End With
  6. End Sub
  7.  
  8. Private Sub cmdLast_Click()
  9.     With Me
  10.         Call MoveRec(frmMe:=.{NameOfSubformOnTab1}.Form, strType:="Last")
  11.         Call MoveRec(frmMe:=.{NameOfSubformOnTab2}.Form, strType:="Last")
  12.     End With
  13. End Sub
  14.  
  15. ...
  16.  
  17. Private Sub MoveRec(frmMe As Form, strType As String)
  18.     With frmMe.Recordset
  19.         Select Case strType
  20.         Case "First"
  21.             Call .MoveFirst
  22.         Case "Last", "New"
  23.             Call .MoveLast
  24.             If strType = "New" Then Call .MoveNext
  25.         Case "Previous"
  26.             Call .MovePrevious
  27.         Case "Next"
  28.             Call .MoveNext
  29.     End With
  30. End Sub
This all assumes the forms are not related or linked.
Jul 15 '18 #15

twinnyfo
Expert Mod 2.5K+
P: 2,532
I do think the long pole in the tent is the records behind the tab control in the first place. Based on the description so far, the navigation controls on the form already affect all the pages in the tab control. If this is the case, then I don’t know how to change the record on pages 1 and 2, and maintain the same record on tabs 3 and 4. Wouldn’t this require a restructure of the tab control to include sub forms on each page?
Jul 15 '18 #16

NeoPa
Expert Mod 15k+
P: 30,996
Probably. Hard to know unless we're told though.
Jul 15 '18 #17

PhilOfWalton
Expert 100+
P: 1,290
I'm sorry ijared. Unless you use the correct terms we are going to struggle. You correctly refer to command buttons one moment, and then refer to them as tabs. Very confusing.

If you select a control with your cursor, you will find it's correct Selection Type in the properties window. Please ONLY use those terms.

Here are some images of forms, and those images in design view, I have indicated where to will find the correct type of control.

This is a Tab control.



This is a Page Control



In form view these are some of the form's components.



I suggest that you refer to the things at the bottom of your form as Navigation Command Buttons, and at the top of your form you have a Tab Control with four Pages on it.

Using the correct terms, I'm sure we can help

Phil
Attached Images
File Type: jpg Tab Control.jpg (92.3 KB, 262 views)
File Type: jpg page.jpg (73.1 KB, 267 views)
File Type: jpg Navigation.jpg (63.5 KB, 266 views)
Jul 15 '18 #18

P: 25
Thanks a lot. It is taking me some times to wrap my head around these names and the way you call them. On the first page I have a list box and I may have to move the name to the list box on the third page.
I will have to leave the command buttons the way they are.
Jul 16 '18 #19

PhilOfWalton
Expert 100+
P: 1,290
So I now read your original question as

I have a single form with a Tab Control containing 4 Pages with list boxes on 2 of the Pages. I have navigation Command Button on the Page 1, and it controls all the Records?????. The list boxes contains different data.

I want the navigation Control Buttons to work only on Pages 1 and 2 but a second navigation Button to work on Pages 3 and 4.

How do I go about that?


So please confirm I am correct.

Please also confirm the navigation Control Buttons are for changing records, NOT for changing Pages

If so, please confirm that you want an set of navigation Control Buttons on Page 2, identical to those on Page 1.

Precisely what do you want on Pages 3 and 4?

Phil
Jul 16 '18 #20

P: 25
I thought the answer I asked for was finished.
I stand by what I said from the begining and yes, the navigation Control Buttons are for changing records, NOT for changing Pages. I want an set of navigation Control Buttons on Page 2, identical to those on Page 1.
On Pages 3 and 4, I only want the record selected in list box1 is moved to list box 2.
Jul 16 '18 #21

twinnyfo
Expert Mod 2.5K+
P: 2,532
the navigation Control Buttons are for changing records
I don't see how this is possible without hte use of sub-forms, which you have given us no indication this is what you have.

On Pages 3 and 4, I only want the record selected in list box1 is moved to list box 2.
This makes absolutely no sense at all.

list boxes do not contain records--they contain lists. Additoinally, this has nothing to do with the navigation command buttons/controls on the pages we have been talking about.

Please, take some time and thoroughly explain what it is you want to do. We are willing to help.
Jul 16 '18 #22

Rabbit
Expert Mod 10K+
P: 12,247
If I gather correctly, you want a command button that will move a selected item from one listbox to another listbox.

What's throwing everyone off is that we are trying to use the official terminology that Microsoft uses but you're taking some of the terminology and applying it elsewhere. The problem with that is we have no idea what you're referring to because we only know of one type of navigation controls. What you're referring to as navigation controls are not navigation controls. And what you're trying to do with the new set of controls has nothing to do with "navigation" in the context in which Microsoft uses the phrase navigation controls.
Jul 16 '18 #23

zmbd
Expert Mod 5K+
P: 5,279
ijared

You have a moving target here and that is beginning to frustrate me

I thought the answer I asked for was finished.
How so?
If we've answered your question then you need to let us know so that we can move on to someone that needs our help.
I stand by what I said from the begining and yes, the navigation Control Buttons are for changing records, NOT for changing Pages.
... and from the beginning you have been somewhat ambiguous in your terminology by refusing to use the correct nomenclature for the control objects in question.

At least in post #7 the image started us on the correct path and finally in Post #11 you showed us most of your form... you missed the very bottom where the form's default record navigation buttons are located.

I want an set of navigation Control Buttons on Page 2, identical to those on Page 1.
AHH now we get to the point
This is easy enough to accomplish and I have attached a database that has a very generic form that shows this.

To get the control button on the PAGE of the tab control you have to select the page not the form and then add your controls to the page.


On Pages 3 and 4, I only want the record selected in list box1 is moved to list box 2.
This is a separate question altogether from your first

>>Next Post...<<
Jul 16 '18 #24

zmbd
Expert Mod 5K+
P: 5,279
So that we have things straight this is how I will refer to the controls in the design view of the form
<step1>



To get the control on the page of the tab control, first click on the page (the little tab looking thing in the tab control - in this image "page 1") of the tab control. This should highlight the page control and any objects within
<step 2>


Now click on the command button tool and then move your mouse pointer over the area on the page you wish to add your command button (or for that fact any control) and draw in your control...
>>Take special note here, the Page area turned black when I moved the mouse over the page control after selecting the command-button tool
<step3>


To copy and paste a set of controls from one page to another, you need to first select your controls, <ctrl><c> then click on the Page-tab (or in this image the page is already selected so I clicked on the tab control) so that it highlights as shown above, hover your mouse where you want to paste (the area should turn black (depending on your os theme setting) and the <ctrl><v>
<step4>


<step5>


NOTICE here that there's a different command button on Page2? on Page1 the command button is "Command8" on Page2 it's "Command3"!

<<Continued in the next post>>>
Attached Images
File Type: jpg Step01.jpg (83.2 KB, 257 views)
File Type: jpg Step02.JPG (46.4 KB, 251 views)
File Type: jpg Step04.JPG (46.9 KB, 242 views)
File Type: jpg step05.JPG (47.9 KB, 241 views)
Jul 16 '18 #25

zmbd
Expert Mod 5K+
P: 5,279
Ran out of attachment space in the last post...

>> TAKE NOTE HERE, even though you copy and pasted - the controls are not the same, they have different names!
So in this case when you click on the command button on the form with the caption "Command9" you will get a message box; HOWEVER, you will not get that same message box on the control pasted on the "Page2" of the tab control... you will have to go into the properties for the command button on Page2 and set the code up for the event!
<step6>


Attached is a database that I pulled the above images from and should make the rest of this very obvious to you.
I've broken my usual habit of renaming controls normally I wouldn't use the default names; however, this is only by way of an example
Attached Files
File Type: zip Bytes_971040_CstmRcrdNavBtnsOnTabPgs.zip (52.3 KB, 4 views)
Jul 16 '18 #26

PhilOfWalton
Expert 100+
P: 1,290
@zmbd

Brilliant illustrations, particularly Step 1.Jpg

In an question I posted a few days ago https://bytes.com/topic/access/answe...062-parts-form

I was hoping that someone could provide a definitive article on the parts of a form, and your picture is an excellent start.

I know that you said you would investigate, but even if you can't find an appropriate website, a few illustrations of that calibre would be perfect.

Phil
Jul 17 '18 #27

P: 25
Is there a question I haven't answered yet?
Jul 17 '18 #28

zmbd
Expert Mod 5K+
P: 5,279
ijared
Is there a question I haven't answered yet?
You've answered many questions by restating the same information over and over again...

At this point, read my last post(s), download the example DB, and let us know if you've figured the first part of your question out.

One more hint:

The code for Page1 and Page2 navigation buttons I'd either have in a standard module or on the form as something like:

Expand|Select|Wrap|Line Numbers
  1. Sub pg1n2_First ()
  2.   'your code here
  3.   'check to see which page is active in case something is specific to that page such as a control
  4. End Sub
  5.  
  6. Sub pg1n2_Back ()
  7.   'your code here
  8.   'check to see which page is active in case something is specific to that page such as a control
  9. End Sub
  10. '
  11. 'etc....
then in your on_click events for each button on each page you would call the code...

Expand|Select|Wrap|Line Numbers
  1. sub btnPg1_first_onclick()
  2.   call pg1n2_first
  3. end sub
  4.  
  5. sub btnPg2_first_onclick()
  6.   call pg1n2_first
  7. end sub
  8. 'etc.... 
At this point either we are not explaining things in a manner that you can understand or your question was DOA when posted.

I'm going to send you a boiler-plate that has a lot of my standard references and tutorials please check your
Bytes.com Inbox

This way you only need the code once...
Jul 17 '18 #29

Rabbit
Expert Mod 10K+
P: 12,247
Not sure why you marked my post as the answer seeing as how it's not an answer, just a rewording of your question.
Jul 17 '18 #30

P: 25
1)I have navigation tabs on the first tab and it controls all the records on these tabs (pages).

I want the navigation tabs to work only in tabs 1 and 2 but a second navigation tab to work on tabs, 3 and 4. (It can be the same navigation tab and works the same way but when the first navigation tabe moves, the records in Tab (page 3 and 4 ) doesn't move.

If I go to Tab (or Page 3) the records in Tab (page 1 and 2) doesn't change.
Jul 18 '18 #31

twinnyfo
Expert Mod 2.5K+
P: 2,532
ijared:
If I go to Tab (or Page 3) the records in Tab (page 1 and 2) doesn't change.
Is this the way you want it or the way it is right now?

Either way, because you are talking about Records in the Tab Control, there is no way to do what you are wanting to do without changing the structure of your form and using Sub-Forms which are not linked in a Parent-Child relationship with the main Form.

We have said this before. It does not appear you are using Sub-Forms within your Tab Control Pages, but the data is simply in Text Boxes on those Pages.

It is impossible to move to part of one record on one page and another part of another record on another page without the use of Sub-Forms.
Jul 18 '18 #32

P: 25
All my records in the dtabase are one one page. I am not trying to change anything in the records apart from deleting the record when it is not in need.
Jul 18 '18 #33

twinnyfo
Expert Mod 2.5K+
P: 2,532
Yes, if you delete the record on one Page, you will delete that same record from the other Pages as well. You must restructure your Tab Control and use Sub-Forms.
Jul 18 '18 #34

P: 25
I want things to work just as you say. When I delete or edit something, I want it to affect everything.
Jul 18 '18 #35

twinnyfo
Expert Mod 2.5K+
P: 2,532
That is not how your original post reads.

Exactly what is it that you are trying to do.

Please--do not simply restate the same things you have said many times before, as apparently we are not quite grasping it.

This is what I hear: You want to navigate to different records on Pages 1 and 2 of your Tab Control using Navigation Command Buttons that you have put on your Tab Control on Page 1. You want a different set of Navigation Command Buttons on Page 3 (or 4) of your Tab Control that navigate the records only on Pages 3 and 4. We have grasped all that. However, you can't have it both ways. You can't delete a record that is being displayed on all four Pages, yet still navigate to different records at the same time.

Please help clarify this for us, as we are thoroughly confused.
Jul 18 '18 #36

P: 25
ok. thanks. I will rethink about it.
Jul 18 '18 #37

P: 25
What about if I use the same command button? Will it be the same result?
Jul 18 '18 #38

twinnyfo
Expert Mod 2.5K+
P: 2,532
Moving to a different record is moving to a different record. You can have twelve Command Buttons, but if they change the record, the entire record of the Form will change--unless you completely restructure your Form.
Jul 18 '18 #39

zmbd
Expert Mod 5K+
P: 5,279
ijared:
It appears that you do not understand the tab-control

Basic usage of the tab control, bound to a recordset, is to allow you to group information from a single record in a logical way and display that record's information in a format that allows the user to quickly find that information without scrolling or having a form design that "hurts the eyes" due to clutter

By way of simple example:
For an Employee record
On the main form you might display the Employee name and Badge number
On the TabControl
- Page1 may have the Hire date, Department, Supervisor, Work Email, Telephone-Extension, and picture of the employee
- Page2 may have the Home address, Home Telephone, Mobile number, Birthday
- Page3 may have information about spouse, kids, etc...

Now if you use ANY method of record navigation, doesn't matter if it's a custom command button or the default form record navigation (see here) ALL of the information will change on the main form and ALL of the TabControl Pages.
There is simply, absolutely, no way around this behavior on a bound form - period, dead stop.

IF you have an unbound form with an unbound TabControl then we have a new situation wherein you can setup subforms which could allow you to navigate records between forms independently; however, I do not recommend this method for people that are not extremely proficient in Access (or for that fact any database) and it doesn't sound to me as this is what you are doing.


>> What I'm getting from you now is that
You want record navigation controls on Tab-Pages 1 and 2
AND
on Tab-Pages 3 and 4 you want command buttons that will step thru the listboxes on those pages.

Finally,
Command buttons are NOT TABS
You simply MUST start using the standard names for the controls on the forms or no-one is going to be able to help you and not doing so after several requests show a certain lack of respect on your part towards those that are attempting to help.
Jul 18 '18 #40

Rabbit
Expert Mod 10K+
P: 12,247
I reset my answer because clearly it isn't the answer.

I'm just as confused as everyone else, I have no idea what is going on or what it is you want to do.

You should attach screenshots of what you have and mockups of what you want to do.
Jul 18 '18 #41

P: 25
Any help please. I am adding a subform to my database but I need help as to what I should remove from my original database and put in there that will help my problem of navigation controls on Tab-Pages 1 and 2 etc, and command buttons that will step thru the listboxes on Tab-Pages 1 and 3.
Jul 22 '18 #42

twinnyfo
Expert Mod 2.5K+
P: 2,532
I still think you are going to have to give us more information on this one. Why would you need Command Buttons to step through list boxes? And, how is this tab control and its pages going to be related to your main form.

The more information you can give us the better. We have spent more than 40 posts trying to figure out that you couldn’t do what it was that you originally wanted to do and now we have to figure out a more complex solution—again, without much information on anything.

Please provide as much detail about your form and exactly what it is that you want to do.
Jul 22 '18 #43

P: 25
Hi,
This is what I want to do:
1:Listbox to be able to select volunteers or use command buttons to browse through voluntees.
2.Personal details.
3.Comments
4.No longer volumnteers Yes/No
If No longer volumnteer admin can remove the person to no longer volunteers page when this person decides he/she doesn't want to do this anymore..
5: Why they decide to quit, admins can be able to delete volunteers.
------------------------------------------------------
1. Just like first 2 pages.
2.listbox like in third page like on first page.
3.comments
4.No longer volumnteers Yes/No does not show here.

Members not authorised to edit and change details shouldn't.
I hope this helps.
Jul 22 '18 #44

zmbd
Expert Mod 5K+
P: 5,279
This is what I want to do:
1:Listbox to be able to select volunteers or use command buttons to browse through voluntees. (...)
Ok, this is a standard membership type database - that makes sense.
A tab-control makes a lot of sense here in that by using the standard form-record-navigation controls you can display information in logical groupings.

HOWEVER,
What I gather you want to do with a standard bound form and a standard tab-control simply isn't reasonably possible.

Instead what I would do is create three forms
(I'm going to use a naming convention here that helps me to keep things straight):
Form 1 name it 100_Membership_Navigation
- this is unbound
Form 2 name it 110_Membership_List
- SUBFORM TO 100 - this will be a continuous form bound to a record-set that lists the basic member's identification such as ID number, name, and most likely a field that indicates volunteer status
Form 3 name it 120_Member_Profile
- SUBFORM TO 100 - This form will be bound to a record set with the members details. This will be a "Single" form view using a standard tab-control. Looking at your post#11 it's very difficult to tell how to group the data; however, logical would be Page1 would have availability, special skills, and other information to help match with task at hand, Page 2 would have personal contact information
So on 100_Membership_Navigation I would place a TextBox that will be bound to the 110_Membership_List record's primary key - this way its value changes when the current record changes on 110_Membership_List. This control will be hidden. This control will be used to setup the Parent/Child relationship between 110_Membership_List and 120_Member_Profile

I've ran out of time for right now; however, this afternoon/evening (CST) I'll upload a simple example database showing how this can all be setup.


------------------------------------------------------
1. Just like first 2 pages.
2.listbox like in third page like on first page.
3.comments
4.No longer volumnteers Yes/No does not show here.
This is really just a re-hash of the previous explanation and really doesn't help.

Members not authorised to edit and change details shouldn't.

As for Administrator verses Non-Administrator privileges to delete a member from the database... that's a whole other topic in and of itself and covered many times in other threads.
Jul 22 '18 #45

twinnyfo
Expert Mod 2.5K+
P: 2,532
ijared:
Members not authorised to edit and change details shouldn't.
For a rather involved but very effective means for accomplishing this, please refer to this Article about User Permissions and Customized Menus in MS Access.
Jul 23 '18 #46

P: 25
Hi, there are lots of stuff going on here and don't even know where to start from my old database, attaching te Sub-Forms.
I don't even now what help the Sub-Forms will do.
Ijared
Jul 23 '18 #47

zmbd
Expert Mod 5K+
P: 5,279
ijared...

After how many posts?
One of the reasons that there is a lot going on in this thread is because you've been very unclear with your goals; however, I think I now have an idea where you are going with this so as promised in post#45 the data base.

A few disclaimers:
- I've spent WAY too much time on this database example
- It is NOT fully 3NF - Normally I would have tables for addresses and telephone numbers in addition to the people table
- I would normally split this in to a front/back-end database
- Not everything is completely error-trapped in the VBA and there may be a few glitches here and there :)

The main form will open when you open the database
100_MainMenu
Unbound form - has four controls
+ text box with the datasouce to the subform 110 named [ctrl_Parent_Link]
+ subform control [ctrl_Subform_110] - there are no linked fields for this control
+ Subform control [ctrl_subform_120] - Master Fields = ctrl_ParentLink and Child Fields = pk_people
- You have to hand enter the values for the linking fields, you cannot use the [...] button you will receive an error about unbound forms.
+ Button with the event code to delete the selected individual in the [ctrl_Subform_110].form

110_PeopleList
Bound to the [t_People] table, "continuous forms" view
The toggle button is something I've used in anther database. When the recordsource is True (-1) then you can see the text, when false the text is hidden - all without VBA! It's a trick with the formatting. Other than the toggle button, nothing really fancy here.

120_PeopleProfile
Bound form to [t_People]
Tab_Control with two Pages.
Page1 has a subform control [ctrl_SubForm_121]; Master fields = PK_People and the Child fields = fk_people nothing special about this arrangement. With the value from 100_MainMenu.ctrl_SubForm_110.form![CurrentRecord] captured in 100_MainMenu.[ctrl_Parent_Link] passed to the bound form the related records are filtered out
Page2 has controls that display the related records in [t_people] for the record selected in 100_MainMenu.ctrl_SubForm_110.form![CurrentRecord]

121_PeopleSkillProfile
Bound form to [q_dataset_Form121] continuous forms view for the records related as passed through the parent/child form link

I've added a query that will recover deleted users from the [Copy Of t_People] table back to [t_People] so that one can experiment with deleting members without losing the data

Code behind all of the updating and linking is all at the form level. Really shouldn't be anything too exciting there other than the code to check that the parent form is loaded.

Hopefully this is all fairly intuitive.

A few screen shots...
Randomly selected one of the records...
this shows the page1 of the tab_control which shows the subform loaded into the tab_Page


and here's with page2 of the tab_control which shows the details of the related record selected on left.



>So, at this point, if thing's don't follow for you then I'm at a loss
Attached Images
File Type: jpg 971040_screenone.jpg (112.1 KB, 113 views)
File Type: jpg 971040_screentwo.jpg (108.6 KB, 113 views)
Attached Files
File Type: zip 971040_MembershipDatabase.zip (225.6 KB, 3 views)
Jul 23 '18 #48

P: 25
Hi , On the Sub-Forms I have attached to the form, should I the table with all the fields?
Jul 27 '18 #49

PhilOfWalton
Expert 100+
P: 1,290
A quick look at you Db looks OK

I think it is pretty but unnecessarily complicated

I spent i5 minutes creating a very basic form its ugly, has not been formatted, but works very simply.

I think that gives you what you are after
Attached Files
File Type: zip ijared.zip (260.2 KB, 3 views)
Jul 27 '18 #50

51 Replies

Post your reply

Sign in to post your reply or Sign up for a free account.