2 small problems

J

Joanne

Problem 1
When i enter my cbobox, I would like it to drop open, but I don't see
anything in the list of properties that will allow me to do this.
AutoExpand is already set to yes, and Locked is set to no. Can this be
done?

Problem 2
When I look at print preview, it shows only the top half of my form -
and sure enough, when I send it to the printer it prints only the top
half of my form. I haven't a clue why the controls on the bottom half
will not print. Visible is yes, display is always on all controls.

Problem 3
When I tab through my form, it goes thru stop 1, 2, and 3, then goes
back to stop 1. I can click in stop 4 and then tab through the rest of
the form, but I cannot go from stop 3 to stop 4. Looked at the
settings and they seem to all be equal to me, all have the correct
stop number on them, and in view tabs they are in the correct order. I
don't know what gives here either.

Any help you can offer on any of these little anoyances will be
greatly appreciated.

TIA
Joanne
 
J

J. Goddard

#1
Pressing F4 opens the dropdown. You can use sendkeys in the On Enter
event to do that. I think it is Sendkeys "{F4}"

#3
The Tab Stop property for control 4 may be "No" - it should be "Yes"

I'll leave #2 to the "experts" - I don't think it is due to Access directly.

John
 
J

Joanne

Thanks for your help
J. Goddard said:
#1
Pressing F4 opens the dropdown. You can use sendkeys in the On Enter
event to do that. I think it is Sendkeys "{F4}"

#3
The Tab Stop property for control 4 may be "No" - it should be "Yes"

I'll leave #2 to the "experts" - I don't think it is due to Access directly.

John
Click to expand...
 
D

Duane Hookom

#1 I would not use Sendkeys. Try add a little code to the Got Focus event
Private Sub cboEmployee_GotFocus()
Me.cboEmployee.Dropdown
End Sub
#2 Forms are for entering and view data as well as navigation etc. Reports
are for printing.
 
J

Joanne

Figured out the printing problem. My line controls got extended
lengthwise and made the form too long to print landscape. After fixing
their length, the problem disappeared.
Whew, that one was pretty easy.

I now have my app running the way I want it, but I still cannot get it
to write to the tables when I add a new choice to the combo boxes.
Tried lots of stuff I found on the net, plus advice from this forum,
but I simply cannot get it to do the job.

I figure I must have some basic something wrong that is stopping the
procedure.

At any rate, I sure do appreciate the help I always get from these
forums.
Joanne
 
J

Joanne

Whoops
Forgot about the tab stop on control 4. It is set to tab stop yes, is
actually numbered tab stop #4, but tabbing will not proceed from tab
stop 3 to tab stop 4. Instead, it goes back to tab stop 1.
Any ideas anyone?
Appreciations for you time and expertise
Joanne
 
J

J. Goddard

I doubt it is this but -

Is tab stop #4 control disabled?

Other than that I don't know. What kind of control is #4, and is there
any code in its events?

John
 
D

Dirk Goldgar

Joanne said:
Whoops
Forgot about the tab stop on control 4. It is set to tab stop yes, is
actually numbered tab stop #4, but tabbing will not proceed from tab
stop 3 to tab stop 4. Instead, it goes back to tab stop 1.
Any ideas anyone?
Click to expand...

Is that control by any chance in a different section of the form? In
the form footer section, perhaps?
 
J

Joanne

No it is in the same section as all the other controls. There actually
is only one section on the form. No headers, footers, etc.
Thanks for your input
 
J

Joanne

No, tab stop 4 is enabled - it is a simple text box, the previous
control is a cbobox. The form is full of these types of controls and
the tabs work everywhere except when moving from stop3 to stop4.
This is really wierd.
Thanks for your input
 
R

Rick Brandt

Joanne said:
No it is in the same section as all the other controls. There actually
is only one section on the form. No headers, footers, etc.
Thanks for your input
Click to expand...

Can you use your mouse to give that control focus? If so, if you then press
Shift-Tab where does focus go? It should go to the control that is one step
prior in the TabOrder. Does it go to the control you expect?

Have you looked at the TabOrder dialog instead of relying on the TabStop
position to see if the order is what you think it is?
 
D

Dirk Goldgar

Joanne said:
No it is in the same section as all the other controls. There actually
is only one section on the form. No headers, footers, etc.
Click to expand...

This is sounding peculiar. Let me double-check all these conditions:

1. The control's properties are set as follows:

Enabled: Yes
Tab Stop: Yes
Tab Index: 4

2. The control is a text box (or other control type that is capable of
receiving the focus).

3. It's in the Detail section of the form with all the other controls.

If you click menu item View -> Tab Order, thus bringing up the Tab Order
dialog, do you see the control where you expect to see it in the list?

The only thing I can think of now is that you may have code (or a macro)
in the previous control's Exit or LostFocus event that explicitly sets
the focus to some other control. Have you checked that?
 
J

Joanne

Rick
I can use my mouse to give the errant control focus.
When I use Shift-Tab, focus goes to the control immediately preceeding
the errant control.

I have checked the tab order in View/Tabs, and the order is what I
would expect, with stop4 being correctly listed.

What a puzzle!!

Thanks for your response. I hope you have some good idea to move
forward with on this.

Joanne
 
D

Duane Hookom

Sounds like some form of corruption. I would select the last control I want
in the tab order and set its tab order number to 1. Then select the second
to the last and set its tab order to 1. Then select the third to the last
and set its tab order to 1. Follow this pattern.
 
J

Joanne

Duane
As it turns out the culprit was a docmd.requery attached to stop3.
Once I deleted that the tab order was in good shape.
Thanks for your ideas and help.
BTW, I took your advice and coded the cboboxes to drop instead of
using sendkeys. I assume this is more reliable and that's why you
offered me that advice
Joanne
 
J

Joanne

RIck
The problem was a docmd.requery in tab stop3. Once deleted, the order
works properly.
Thanks for your time and input - it always helps lead me in the right
direction.
Joanne
 
J

Joanne

Peculiar is certainly a good description for this - but I found that
the problem was a docmd.requery on tab stop3. Once removed, tab order
started working correctly.
Thank you for helping me with this problem
Joanne
 
Top