Suppress popup on display of custom popup

[Guest]

A popup menu is to be displayed on the right-mouse button mouseup event. How
do you suppress the popup from Access?
Thanks
Terry

 

[Guest]

Hi,
are you actually using a custom shortcut menu or just a form which you open
up on some control's/form event. If you created a custom shortcut then
specify it to be used on this form through the pop up property in the form's
other tab of the property dialog. Set Short Cut menu to 'Yes' and select it
from the choice under short cut menu bar. This default one should not come up
anymore. If you created a custom form or some other similar approach then
just set the Short Cut menu property to 'No'.
HTH
Good luck

 

[Guest]

Thank you

Hi,
are you actually using a custom shortcut menu or just a form which you open
up on some control's/form event. If you created a custom shortcut then
specify it to be used on this form through the pop up property in the form's
other tab of the property dialog. Set Short Cut menu to 'Yes' and select it
from the choice under short cut menu bar. This default one should not come up
anymore. If you created a custom form or some other similar approach then
just set the Short Cut menu property to 'No'.
HTH
Good luck

 

[Guest]

I need your help quickly. i am to make a presentation to some big names in
my company. I need you to walk me thru step-by-step on this topic.

I need to create a one time popup form when Access loads. The form asks to
enter data, i.e. Project Number. When I click a button to close that form,
that data (Project Number) is to be pushed to other forms that carry Project
Number in it's table. Can you tell me what I need to do, step-by-step? I'm
an amateur, but need this asap!

Please respond to my email: (e-mail address removed)

thanks

Ben

 

[Guest]

Hello Bronen
1. Create a Module and in it declare global variables to hold the values you
want to keep using. You may even like to create a User type variable, say,
ValuesRecord and store a range of variables in it.
2. Create a Public function in that or another module (I like to have a
modDeclarations and a modFunctions) and in it create global function Startup.
This function should retrieve all the variables you want to use.
3. Create a Macro with a single command RunCode and in it run the Function
"Startup". Call this function AUTOEXEC (Name IS IMPORTANT but the case is not)
4. In the Load or Open event of the forms check these values and take
appropriate action.
Yell if you need more.
HTH
Terry
(Sorry! Don't do Hotmail - it is blocked on my mail server)

 

[Matthias Klaey]

I need your help quickly. i am to make a presentation to some big names in
my company. I need you to walk me thru step-by-step on this topic.

I need to create a one time popup form when Access loads. The form asks to
enter data, i.e. Project Number. When I click a button to close that form,
that data (Project Number) is to be pushed to other forms that carry Project
Number in it's table. Can you tell me what I need to do, step-by-step? I'm
an amateur, but need this asap!

Please respond to my email: (e-mail address removed)

thanks

Ben

You request a lot, "urgently", without giving too much information
about yourself and the Access version you are using. Is this your
first Access application? How proficient are you in VBA? Can you
explain to me four ways to exchange information between forms?

I propose that you make your start form, say frmStart, where you ask
for the Project number, say, in a textfield named txtProjectNumber.
You also have a command button "Ok".

In the command buttons OnClick event, place the code

Me.Visible = False
DoCmd.Openform "frm_YourMainForm"

In the frm_YourMainForm and any other form where it is used, refer to
ProjectNumer with the expression

Forms!frmStart!txtProjectNumber

This is certainly the quickest, but also the dirtiest and least
maintainable version to keep this global information. But perhaps it
will help for your demo.

HTH
Matthias Kläy