switchboard issue

[razoRjaw]

I'm using 2007 in vista.
when i use the switchboard manager and set the properties to popup the width is normal, but the length goes all the way to the bottom of my screen.
anyone else experience this phenomenon? and what can i do about it? the footer is at the bottom of the blue box on the left hand side, but when i enter form mode the blue box stops where the footer should be and its white all the way to the taskbar

 

[ajetrumpet]

I'm using 2007 in vista.
when i use the switchboard manager and set the properties to popup the width is normal, but the length goes all the way to the bottom of my screen.
anyone else experience this phenomenon? and what can i do about it? the footer is at the bottom of the blue box on the left hand side, but when i enter form mode the blue box stops where the footer should be and its white all the way to the taskbar

is your form actually that long in design view? if it is, shorten it, then save it before going back to form view. also, is the form WINDOW that long, or is the form DETAIL section that long in design view?

 

[razoRjaw]

neither. see attached.
this is my second DB i have had this issue with using the switchboard manager in access. maybe i just have to manually make a switchboard?
and if i change it out of continuous it is only one command long...

 

[ajetrumpet]

neither. see attached.
this is my second DB i have had this issue with using the switchboard manager in access. maybe i just have to manually make a switchboard?
and if i change it out of continuous it is only one command long...

i'm not sure what to tell you i guess. seems like something that may be a corruption. i'm not sure. hopefully someone else can help

 

[boblarson]

Try changing from the Tabbed format of Access 2007.

 

[razoRjaw]

nope didnt work, i just trashed the switchboard and made my own from scratch
but those were great links guys and i learned a lot of other stuff that is helpful

 

[Simon_MT]

When you are using a Continuous Form in Popup Access 2007 is not bright enough to limit the size of that Form. The only way I found a way around this problem was the DoCmd.OpenForm but is is not a solution if the form is opened when the application starts - there is no call to the Form as it is the default Form.

I use fixed sized Forms as a Menu system - nothing fancy but it works.

Simon

 

[Uncle Gizmo]

The more I use MS Access 2007 the more minor annoyances I find!

1) You can’t import from another database unless you click on a table, so if you haven’t got the table you can’t import anything!

2) You can’t rename by just clicking on the name.

3) There are a few others, I will add to the list when you think of them, does anyone else have any to add?

4) Has anyone come up with any workarounds?

 

[boblarson]

1) You can’t import from another database unless you click on a table, so if you haven’t got the table you can’t import anything!

I'll have to test that but I've imported tables into a completely brand new accdb file before so I'm not sure what is happening to you when I could do it.

2) You can’t rename by just clicking on the name.

True, they did change that, although that was a bit of consternation as you could accidentally change it by just clicking on it and hitting something, so it may be something that some users hate and others love.

 

[Simon_MT]

Uncle Gizmo,

Personally, I hate to admit it, but I quite like Access 2007. I didn't think I would. Yes there are annoyances but overall it has a much better User Interface. I will say the Ribbon is as useful as a fanny full of cement.

I don't mind the renaming convention Right Click Rename as in terms of of project the times you need to rename files, time wise is quite small. I think it is the Append Query does work properly as all the fields being updated an contained in brackets and you have to into SQL view to get the [] removed.

What I do like are the Command Buttons and object stored in their native format not OLE bitmaps. Picture format is better but good enough.

Going back to the issue at hand I don't use the feature autoexec Macro anymore but if this feature still works you could write a Macro to open the switchboard:

DoCmd.OpenForm "Switchboard", acNormal, "", "", , acDialog

Simon

 

[boblarson]

Going back to the issue at hand I don't use the feature autoexec Macro anymore but if this feature still works you could write a Macro to open the

Actually, just like other versions you don't need to use a macro to open the switchboard. You can just set it in the startup options.

 

[Simon_MT]

Bob,

I know that but it is the treatment of height of a pop-up as a continuous form. Previous versions of Access you could set the height of popup even if it was a Continuous Form now you can't except doing it on Docmd.OpenForm ...

Simon

 

[boblarson]

Bob,

I know that but it is the treatment of height of a pop-up as a continuous form. Previous versions of Access you could set the height of popup even if it was a Continuous Form now you can't except doing it on Docmd.OpenForm ...

Simon

You can in the Open event of the form itself