Popup Menu

[Jose Perdigao]

I created a popup menu to use on the forms, queries and tables. It Works
fine.

However, if I open the database in runtime mode, the popup doesn't work in
the tables and queries. I mean, when I do right click, doesn't appears the
menu.



There is way to show the popup menu if I open the database in runtime?



Any suggestions?



Thanks,

José Perdigão

 

[Rick Brandt]

I created a popup menu to use on the forms, queries and tables. It
Works fine.

However, if I open the database in runtime mode, the popup doesn't
work in the tables and queries. I mean, when I do right click,
doesn't appears the menu.
There is way to show the popup menu if I open the database in runtime?

Any suggestions?

Did you actually create an entirely NEW popup menu or did you modify one of the
built in ones? ALL built in command bars are unavailable in the Runtime. New
ones that you create should work fine though.

 

[Jose Perdigao]

my popu menu is from access 97 and when I do right click on the querie or
table, It doesn't appear. But on the form I can see the popup menu.

What is wrong?

thanks

 

[Jose Perdigao]

I created in MS access 97 and I don't remember how made it.
Do you think popup menu from access 97 doesn't work in access 2003 in
runtime mode?

Thanks
José perdigão

 

[Albert D.Kallal]

I created in MS access 97 and I don't remember how made it.
Do you think popup menu from access 97 doesn't work in access 2003 in
runtime mode?

It should work just fine. I would check the tools->startup options. I
suspect that the "allow full menus" is un-checked....

 

[Rick Brandt]

my popu menu is from access 97 and when I do right click on the
querie or table, It doesn't appear. But on the form I can see the
popup menu.
What is wrong?

You cannot use a popup menu in the Runtime against a query or table. A form
or report has a property where you can specify "use this popup menu".
Queries and Tables have no such property so the only popup menus available
for them are the built in ones (which are not available in the runtime).

 

[Jose Perdigao]

Hi Albert,

In allow full menus, I did un-checked but unfortunately don't work.

In forms, shows the popup menu in tables and queries doesn't show. I don't
know what is wrong. The popup menu is a good tool to filter, sort and so on.

If the application is opened not in runtime, when I open tables or queries
and the popup menu is, showed if I do right click. In runtime, doesn't show.

Any Ideas?



Thanks,

José perdigão

 

[Albert D.Kallal]

If the application is opened not in runtime, when I open tables or queries

and the popup menu is, showed if I do right click. In runtime, doesn't
show.

Any Ideas?

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options.

Take a look at the options....and compare it to your database. If mine works
ok, and yours does not, then it is your application. If mine does NOT work,
then it is the ms-access install.....

 

[Albert D.Kallal]

The popup menu is a good tool to filter, sort and so on.

Ah, wait!. You not talking about a your own menu bar anymore ..then are
you???

I don't believe those work in the runtime (you can always test using the
/runtime switch-- thus, you don't have to "move" to a test box).

You don't mention what kind of filter button your are using (sounds like
filter by selection --- you can check, but I believe that built-in menu is
NOT availing when you deploy using the runtime. You have to code your own
version.....

 

[Jose Perdigao]

Hi Albert,

I download your file Wordmerge20.mdb

I open it and on contacts form, I added a button to open query1



Private Sub cmdQry_Click()
DoCmd.OpenQuery "Query1"
End Sub



I create a shortcut an in the target a type the following text to open your
mdb as runtime mode.

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe"
"C:\A_Samples\WordMerge20.mdb" /runtime



From your contacts form, I click on cmdQry button and opened query1. I did
right click and the popup menu doesn't show.

When I said filter, I mean filter by selection, excluding and etc.



Do you have any suggestion?



Thanks.



I appreciate a lot your code about merging and I have one question.

I did a test, merging all records and the word shows one page for each
record. I would like to see all records together in the same page. When
finish a record, start the next one with a paragraph or not or I can merge a
table?

How can I do?



Thanks a lot,

José Perdigão