Pop Up Table Via Form Button Press Or Hide Form But Make Form Visible Again When Table Is Closed

[StanJx]

Hi,



In my access database I have created an Admin portal (which is restricted to users) so the system admin could view the table data. Since my form is a pop up and I have disabled control box and control buttons on the form. I was wondering if there was a way to get the table to pop up in front of the form. Or the form hides and once the table is closed it becomes visible again. Any thoughts??

Appreciate your quick response.
Thanks in Advance
Stan

[June7]

Is this for a particular table or any table the admin opens from Navigation pane?

Table/query cannot overlay popup form.

Tables and queries cannot have code behind them (Data Macros don't count for this situation) so I don't see any way to make the form hide/unhide when opening table/query from Navigation pane. Unless you want to build a custom ribbon or shortcut menu or QAT for the admin user (but I think these have limitations with popup form).

[StanJx]

Is this for a particular table or any table the admin opens from Navigation pane?

Table/query cannot overlay popup form.

Tables and queries cannot have code behind them (Data Macros don't count for this situation) so I don't see any way to make the form hide/unhide when opening table/query from Navigation pane. Unless you want to build a custom ribbon or shortcut menu or QAT for the admin user (but I think these have limitations with popup form).

Thanks for the reply June7, Yes it is for a particular table but the admin won't be able to access the navigation pane. I have a menu on where I have added a button to open the table.

I was wondering if there is a method to use with a module?

Thanks in advance
Stan

[June7]

How would a module be useful? Certainly can't make table sit over popup. However, another popup form can sit over a popup form. Open form instead of table. A form in Continuous view can be arranged to look like datasheet and then can have button in form header to close the form.

[StanJx]

How would a module be useful? Certainly can't make table sit over popup. However, another popup form can sit over a popup form. Open form instead of table. A form in Continuous view can be arranged to look like datasheet and then can have button in form header to close the form.

June7,

Thanks a lot I was able to get what I wanted.

However I have another small dilemma. My Reports in my access system is showing the "Design View" and "Layout View" selections on right click. I can't disable the right click entirely because some of the reports are filterable. I got a VBA module code from the web tweaked it to my requirement. It worked when I opened the reports via double click from the navigation pane but when I accessed the report via the buttons on my forms It started giving errors. Do you know the way to customize the right click menu using macro. I am using Access 2013. I found a method on Access 2007 but couldn't figure out how on Access 2013. The macro builder screen is different from the screen shots provided. I need to only have the "Print Preview" and "Filter Menu" on right click at my reports.

Thanks in Advance
Stan

[June7]

I've never built customized shortcut menu. Unless you want to provide db for analysis, I can't help. Even then don't know if I can help because I don't have 2013. You might want to start a new thread on this new issue.

[StanJx]

Thanks will do