Access Run Time Limitations

[Guest]

Hello,

I have observed 2 limits with Access 2000 run time, and wondered if I am
doing something incorrect in my coding, run time set up, or if these are
actually limitations:

1. In a form, with a subform in datasheet view, the ability to RIGHT CLICK
on a column to HIDE/UNHIDE a column is not available.

2. Some messages don't appear in the full Access version which appear in the
run time, such as: "Are you sure you want to run an append query".

Thanks.

 

[Douglas J. Steele]

No right-click menus are present in the run-time. If you want them, you have
to code them yourself.

To prevent the messages, either put DoCmd.SetWarnings False before you run
the query and DoCmd.SetWarnings True afterward, or else use the Execute
method of the Database or the QueryDef objects.

 

[Guest]

Douglas,

Thanks for your reply. My response? Ouch...

If I want to code them myself, and I want to have HIDE COLUMN and SORT
functionality on a datasheet subform, any suggestions on how to go about that?

 

[david epsom dot com dot au]

Create a new menu (popup), and drag the controls you want
on to it. Set the forms shortcut property to your new menu.

The limitation is that these menus are associated with
the DATA on the datasheet subform, not the COLUMN HEADER.

Normally, to hide or sort a column, you would right-click
on the column header. When you have your own menu, that
doesn't work. You have to right-click in the data area.
It takes a little getting used to, and it's not the way
you expect it to work.

(david)

 

[Guest]

David,

Thanks for your reply.

I think this is getting me close. A few follow up questions:

1. I created the menu, added SORT ASC, SORT DESC to it, and made it the
FORM's SHORTCUT MENU. Do I need to make it the subform's SHORTCUT MENU?
Reason I ask: I don't see the option in PROPERTIES to make it the subform's
SHORTCUT MENU. I have created a subfrm ctl within this form, and am
dynamically creating the content based on a query, so there is no FORM
definition in the traditional sense.

2. Is there the ability to add the HIDE/UNHIDE column menu option to this
menu?

Thanks.

 

[david epsom dot com dot au]

The form menu applies to the form, and what ever you have
bound the form to.

The subform menu applies to the subform, and what ever you
have bound the subform to.

The subform control on the form doesn't have a menu property,
because the menu from the subform is used instead.

To set the menu property on the subform, either close the
form and open just the subform in design view, or carefully
select the form inside the control after you have select the
control.

(david)

 

[Guest]

David,

I cannot edit the subform in Design mode. It is not a form in the
traditional sense. I created a subform control within the form, and am using
VBA code to assign the .SourceObject as a query. So, in this case, how would
assign the shortcut menu to the subform?

Also,is HIDE/UNHIDE and FREEZE COLUMN available options for this custom
popup menu?

Thanks.

 

[david epsom dot com dot au]

I've got hide/unhide and freeze on my subform pop-up.

I don't know how to set the popup menu for a query in data sheet mode.

I suggest that you repost with that specific question.

"Set the popup menu for a query in datasheet mode?"

(david)

 

[Guest]

David,

You have the hide/unhide and freeze on your datasheet view pop-up, in Access
RUN TIME?

 

[david epsom dot com dot au]

Yes, I've got hide/unhide and freeze, on my pop-up menu, in run time.

(david)