A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Page tabs keep going AWOL



 
 
Thread Tools Display Modes
  #1  
Old January 28th, 2007, 07:31 PM posted to microsoft.public.access.forms
Phil Davy
external usenet poster
 
Posts: 19
Default Page tabs keep going AWOL

I have a form with 5 page tabs at the top.

In design view they appear ok, but as soon as I go into the normal view the
user sees, they disappear and I can only reshow them by pressing
CTRL-SHIFT-TAB.

Can someone please help?

Thanks
Phil
  #2  
Old January 29th, 2007, 12:08 AM posted to microsoft.public.access.forms
Allen Browne
external usenet poster
 
Posts: 11,706
Default Page tabs keep going AWOL

How do you have the Style property of the tab control set?

Or is the Height of the (Detail?) section of the form inadequate?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Davy" wrote in message
...
I have a form with 5 page tabs at the top.

In design view they appear ok, but as soon as I go into the normal view
the
user sees, they disappear and I can only reshow them by pressing
CTRL-SHIFT-TAB.

Can someone please help?

Thanks
Phil


  #3  
Old January 29th, 2007, 08:10 AM posted to microsoft.public.access.forms
Phil Davy
external usenet poster
 
Posts: 19
Default Page tabs keep going AWOL

Thanks for your reply. I'm out of office today but wil get back tomorrow.

Thanks

"Allen Browne" wrote:

How do you have the Style property of the tab control set?

Or is the Height of the (Detail?) section of the form inadequate?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Davy" wrote in message
...
I have a form with 5 page tabs at the top.

In design view they appear ok, but as soon as I go into the normal view
the
user sees, they disappear and I can only reshow them by pressing
CTRL-SHIFT-TAB.

Can someone please help?

Thanks
Phil



  #4  
Old January 29th, 2007, 02:29 PM posted to microsoft.public.access.forms
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default Page tabs keep going AWOL

I'd like an answer to this mystery also! I have an app with tabbed pages and
everything works fine when the form is invoked from the Objects Dialog box or
when invoked from another form. The behaviour he's referring to (I think)
occurs when you're in Design View and then run the form firectly from there.
The Tabbed Pages disappear and the lower half of the form blanks out.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200701/1

  #5  
Old January 29th, 2007, 07:30 PM posted to microsoft.public.access.forms
Phil Davy
external usenet poster
 
Posts: 19
Default Page tabs keep going AWOL

Yes, that's exactly it.

Infuriating, as this is the only thing preventing us releasing the previous
6 months' work!

"missinglinq via AccessMonster.com" wrote:

I'd like an answer to this mystery also! I have an app with tabbed pages and
everything works fine when the form is invoked from the Objects Dialog box or
when invoked from another form. The behaviour he's referring to (I think)
occurs when you're in Design View and then run the form firectly from there.
The Tabbed Pages disappear and the lower half of the form blanks out.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200701/1


  #6  
Old January 30th, 2007, 11:44 AM posted to microsoft.public.access.forms
Phil Davy
external usenet poster
 
Posts: 19
Default Page tabs keep going AWOL

Style prop = "Tabs"

Height looks ok!

I don't mean to sound cheeky, but would you mind if I emailed you my
database pls? Sorry if I'm causing offence, but I genuinely can't understand
what I'm doing wrong.

"Allen Browne" wrote:

How do you have the Style property of the tab control set?

Or is the Height of the (Detail?) section of the form inadequate?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Davy" wrote in message
...
I have a form with 5 page tabs at the top.

In design view they appear ok, but as soon as I go into the normal view
the
user sees, they disappear and I can only reshow them by pressing
CTRL-SHIFT-TAB.

Can someone please help?

Thanks
Phil



  #7  
Old January 30th, 2007, 12:04 PM posted to microsoft.public.access.forms
Allen Browne
external usenet poster
 
Posts: 11,706
Default Page tabs keep going AWOL

Before you email me, can you do a couple of things.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
Then Compact the database:
Tools | Database Utilities | Compact/Repair

2. Make a copy of the database (so you don't damage your original.)
Open the form in design view.
Set the form's HasModule property to No, answering Yes to the confirmation.
Save and close the form.
Compact the database again.
Does the form still play up without any code?

3. Export the form to a text file, using the undocumented SaveAsText.
This kind of thing:
SaveAsText acForm, "Form1", "C:\Form1.txt"
Then delete the form, and compact the database.
Now import the form again from the text file:
LoadFromText acForm, "Form1", "C:\Form1.txt"
Did that rescue it?

4. If it still plays up, try the divide'n'conquor trick.
Delete half the controls from the form. Compact.
Does it still play up?
If so, delete half again, and so on.
Is there a point where it comes good?
If so, add in half the things from the last delete, continuing until you
pinpoint the culprit.

I'm really under the hammer at the moment, Phil, but if that goes nowhere
you can email me and include the text of this thread.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Davy" wrote in message
...
Style prop = "Tabs"

Height looks ok!

I don't mean to sound cheeky, but would you mind if I emailed you my
database pls? Sorry if I'm causing offence, but I genuinely can't
understand
what I'm doing wrong.

"Allen Browne" wrote:

How do you have the Style property of the tab control set?

Or is the Height of the (Detail?) section of the form inadequate?

"Phil Davy" wrote in message
...
I have a form with 5 page tabs at the top.

In design view they appear ok, but as soon as I go into the normal view
the
user sees, they disappear and I can only reshow them by pressing
CTRL-SHIFT-TAB.

Can someone please help?

Thanks
Phil


  #8  
Old January 30th, 2007, 01:11 PM posted to microsoft.public.access.forms
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default Page tabs keep going AWOL

Granted this is aggravating, Phil, but since it only appears when going from
Design View to Normal View, I don't see why that should hold up deploying the
apps. End users aren't usually granted access to Design View, and this is the
only way I've experienced this particular snafu.

BTW, I've gone thru all of Allen's suggestions without success.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

  #9  
Old January 30th, 2007, 01:21 PM posted to microsoft.public.access.forms
Allen Browne
external usenet poster
 
Posts: 11,706
Default Page tabs keep going AWOL

You killed the code, exported with SaveAsText, and reimported, and the
problem survived?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"missinglinq via AccessMonster.com" u28780@uwe wrote in message
news:6d0ea52f8d961@uwe...
Granted this is aggravating, Phil, but since it only appears when going
from
Design View to Normal View, I don't see why that should hold up deploying
the
apps. End users aren't usually granted access to Design View, and this is
the
only way I've experienced this particular snafu.

BTW, I've gone thru all of Allen's suggestions without success.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com


  #10  
Old January 30th, 2007, 01:25 PM posted to microsoft.public.access.forms
Phil Davy
external usenet poster
 
Posts: 19
Default Page tabs keep going AWOL

Hi chaps,

I solved it thanks to Allen.

The problem was in Normal View, the tabs weren't showing so it couldn't be
deployed in that state.

Basically the problem was two of the six pages were too long. When I
shortened these pages, the headers show ok!!

Hoorah, what a result, at last this problem has disappeared!

Many thanks chaps, and especially Allen I really appreciate all your kind
help.

Cheers
Phil

"missinglinq via AccessMonster.com" wrote:

Granted this is aggravating, Phil, but since it only appears when going from
Design View to Normal View, I don't see why that should hold up deploying the
apps. End users aren't usually granted access to Design View, and this is the
only way I've experienced this particular snafu.

BTW, I've gone thru all of Allen's suggestions without success.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.