473,324 Members | 2,456 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Tabstrip on a form

9
Hi,

I am pretty new to access and have created a booking database. I have a form, which has a tabstrip on that contains all the details about a person on one page of the tabstrip and all the bookings they have on another page.

I have another form where the user selects the person whose details they would like to see, then the form with the tabstrip on is displayed, and linked to the previous form but the PersonID.

However, if the person in question has not made any bookings, then the tabstrip is not visible.

How can I solve this?

Thanks in advance.
Mar 25 '07 #1
10 3800
MMcCarthy
14,534 Expert Mod 8TB
Hi,

I am pretty new to access and have created a booking database. I have a form, which has a tabstrip on that contains all the details about a person on one page of the tabstrip and all the bookings they have on another page.

I have another form where the user selects the person whose details they would like to see, then the form with the tabstrip on is displayed, and linked to the previous form but the PersonID.

However, if the person in question has not made any bookings, then the tabstrip is not visible.

How can I solve this?

Thanks in advance.
Put a command button on the form to open a form to allow bookings to be made then requery the first form.
Mar 26 '07 #2
hwt
9
Put a command button on the form to open a form to allow bookings to be made then requery the first form.
I'm not quite sure what you mean.

On the form with my tabstrips, I have a tab that enables the user to add bookings to each person stored in the database. So should I create a new form to make these bookings and take it off the tabstrip?
Mar 26 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
I'm not quite sure what you mean.

On the form with my tabstrips, I have a tab that enables the user to add bookings to each person stored in the database. So should I create a new form to make these bookings and take it off the tabstrip?
What do you mean by a tab/tabstrip?
Mar 26 '07 #4
hwt
9
The tab control in the form designer
Mar 26 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
So have you just added the fields to the tab page without putting them on a subform. Or are the bookings on a subform on the tab page. All a tab is is a page i.e. Each tab is a different page on the same record. This doesn't explain how your bookings are working. For instance if you have more than one booking how is that being represented on the page.
Mar 26 '07 #6
hwt
9
Ahh sorry.

I am using my tabs to display all the data about 1 person at a time, so 1 tab has the personaly details about the person, the next has a subform on that shows all the sessions that the person is booked in for and I have a another tab to add new sessions for the person.

Would it be easier to create a seperate form to add sessions for each person?
Mar 26 '07 #7
MMcCarthy
14,534 Expert Mod 8TB
Ahh sorry.

I am using my tabs to display all the data about 1 person at a time, so 1 tab has the personaly details about the person, the next has a subform on that shows all the sessions that the person is booked in for and I have a another tab to add new sessions for the person.

Would it be easier to create a seperate form to add sessions for each person?
Yes, instead of the third tab to add new sessions have that on a separate form. Add a command button to the second tab under the subform to open this new form and in the Close event of the new form add the code to requery the subform.
Expand|Select|Wrap|Line Numbers
  1. Forms![MainFormName]![SubFormName].Requery
Mary
Mar 26 '07 #8
hwt
9
The add session part of my database now works just as I would like it to! So many thanks for your help there.

However, I still have the problem that my tab control is only visible if there is any data present on the subform that one page of it contains, even though the first tab always has data present. Do you have any ideas as to how to solve this?

Thanks.
Mar 26 '07 #9
MMcCarthy
14,534 Expert Mod 8TB
The add session part of my database now works just as I would like it to! So many thanks for your help there.

However, I still have the problem that my tab control is only visible if there is any data present on the subform that one page of it contains, even though the first tab always has data present. Do you have any ideas as to how to solve this?

Thanks.
I don't know why this is happening. It is not usual behaviour.

Mary
Mar 26 '07 #10
hwt
9
ok no problem. Thanks for all your help!

hwt
Mar 29 '07 #11

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

Similar topics

4
by: Eric | last post by:
I'm currently using the TabStrip control, but am having slighly difficulties. I've managed to retrieve the Items from the TabStrip using the Items property. But how can I enforce the changes that...
2
by: tottigang | last post by:
Hi, I have a tabstrip and I have some tabs in it. On the first page, all the tabs are enabled, I need to disbale part of the tabs at a specific point in the application and again enable them. I...
0
by: mehul | last post by:
CheckBox template always evaluate to False even if checked in a DataGrid hosted inside a TabStrip in ASP.NET Hi, I am trying to develop an ASP.NET application. I am using TabStrip (which is...
0
by: yufufi | last post by:
Hi, I want to use tabstrip on my webpage. I found the tabstrip page and installed webcontrols from msdn. But I couldn't make tabstrip to work at client side. It always does a postback. I copied...
0
by: Greg Taylor | last post by:
I'm using the IE webcontrols (obviously) trying to dynamically generate a tabstrip based of a DTS package. I can get the tabstrip to show if I assign the generation after the page completely loads...
0
by: Dave | last post by:
Greetings, I am using a tabstrip in a user control (ascx) in a web application (aspx) that is used to navigate between the different aspx pages. Whenever I click on one of them, the...
2
by: Bart Schelkens | last post by:
Hi, I've created a webusercontrol that contains a tabstrip (Microsoft.Web.UI.WebControls.TabStrip. I want to raise the event when the selected index of the tabstrip changes. I wrote the...
0
by: ae | last post by:
can someone help me? i copied this from msdn, and can't get it to work on the Response.Redirect. I think it should be that, and I also tried Page.Navigate("www.yahoo.com"), but that gave me an...
9
by: Mardy | last post by:
Hello I've been using the tabstrip and multipage controls and really like the way this combination allows users to switch between tabs without a postback. I'd like to get more detailed...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.