Forms :: Context Menus Don't Work When Access Window Is Minimized
Sep 24, 2013
I recently completed a db for a client and they have since asked that the access window be hidden for certain types of users.This I did using
Code:
ShowWindowAsync Application.hWndAccessApp(), SW_HIDE
if a relevant user opened the db. All well and good, except they then wanted to be able to see the Access link in the taskbar (which SW_HIDE doesn't do) - so I changed it to SW_MINIMISE and they were happy again until..They then realised (and it was a surprise to me as well) that the right click context menus used to filter and sort continuous or datasheet forms were no longer available to these users - nor was the context menu for datasheet columns to freeze or hide columns - see attached.
I've experimented with a number of options and these context menus are available if ShowWindowAsync is not called or if called with SW_HIDE, but not for SW_MINIMISED, SW_SHOWMINIMISED, SW_SHOWMINNOACTIVE, SW_SHOWNOACTIVE.
Why the shortcut menus are not available when the Access window is minimised? The requirement being that the context menus are available to all users the Access link appears on the task bar for all users the access window is hidden for some users.I should say that due to hiding/minimising the access window all forms are popup and modal.
View Replies
ADVERTISEMENT
Mar 29, 2007
I already have this working by means of:
doCmd.RunCommand acCmdAppMinimize in Form_Load (or Form_Open) events.
This works great to hide Access and only display the main form (like a standalone app).
But I have 2 issues:
1. The PopUp form (main or "switchboard" if you like) opens, then Access is minimized, but then the form looses focus. If there are other programs running, form will be behind them!
2. Access is first seen opening (for a moment) and THEN minimized (see 1.). Is there a way NOT TO SEE IT at all? :)
Thanks!
View 3 Replies
View Related
Apr 12, 2005
Hi all,
I have a main form which is open in a maximized window (which i want to leave as it is), i have a command button which opens a form, now i want the form to open up as the size of a box i have created in the form, without altering the size of the first form. Also is it possible to move the 2nd form to the bottom left hand corner of my screem.
This is code i have so far does minimize window to what i want it to but also restores first form, which i want t leave maximized:
Code: Me.InsideHeight = Me.Box15.HeightMe.InsideWidth = Me.Box15.WidthDoCmd.Restore
Thanks in advance for any help,
M-.
View 2 Replies
View Related
Sep 21, 2005
I have written an Access (2000) Db that uses the SendObject function to send an email. Works quite happily for my Windows 2000 Op System users, but not on XP machines. XP machines error with message something like "access denies, not available in this context". Any ideas?
View 2 Replies
View Related
Apr 8, 2015
I have three forms:
Form_A (main form for the application - should always be open)
Form_B (always open, but sometimes has visibility set to false)
Form_C (opens from button on Form_B)
When I press the button on Form_B, the only code behind it is DoCmd.OpenForm "Form_C". This seems to hide Form_B, and open Form_C behind Form_A (which is the main form of the application) inside of an Access window.
I would like Form_C to open in front of Form_B. I suspect that I set up the form incorrectly or something when I created it, and it is therefore opening inside an Access window.
View 1 Replies
View Related
Oct 21, 2013
My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.
View 3 Replies
View Related
Aug 9, 2005
This happened yesterday at work.
The access form froze and they could do other things but Access remained frozen. They logged off and when they went back in Access opened but none of the form buttons or links were working.
The database is not split because it is used only by one station at a time.
Has this happened to anyone and does anyone know the cause?
Five people were trying to fix it when I walked into work (5 people who no nothing about Access other than using that one database) and I couldn't get a straight answer.
Thanks
Kim
View 5 Replies
View Related
Feb 26, 2008
Hi all,
After searching through the "search" field, I realize lots of us are having problems with the menu's in access 2007.
After converting my 2003 DB to 2007, my menus are still there, but displayes as Add-ins instead of as the menu bar. I can't find any options to change during the conversion.
I have tried importing my Logon window with the options "menus and icons" clicked, but this didn't change anything.
If I open the DB in 2003 Format, then go to the options in Access 2007 I can choose the menubar, but if I convert to 2007, the menubar is only available as add-ins. Is there any way round this?
Appreciate any help - it is so time consuming trying to figure this out - and I seem to go round in circles, ticking options on and off... perhaps some dear soul has already found the answer!
View 2 Replies
View Related
Mar 22, 2008
Hi, I have hidden all the menus and added one of my own custom menus to a DB that I was creating. That DB has been completed. Now when I open a blank DB to commence again, I have the same hidden menues and my one custom menu. Is there away in Access 2003 that I can replace the template, for example, MS Excel and Word have .dot and personal.xls. Is there an easy way to bring them all back. I checked in startup for a restore defaults, however this does not work. Any ideas. Garry
View 1 Replies
View Related
Feb 6, 2014
I created a small database with a user login form, along with a password reset form. Running it in my sandbox as an accdr file, the password value resets just fine, but on my test machine with the Access 2010 runtime installed, the password reset form doesn't reset the password. I will try to describe the state of things as of this point.
1. The LoginF presents with a combo box for the user to choose their name, and a text box to enter their password. The code below is on the After Update of the password text box.
Code:
Private Sub txtPassword_AfterUpdate()
'Check if user has been chosen
If IsNull(Me.cboUser) Then
MsgBox "Please Select User Initials", vbInformation, "Warning"
[Code] ....
2. The password reset form has two text boxes for the new password and to re-enter the same, as well as a command button with this code.
Code:
Private Sub cmdResetPassword_Click()
If Me.Password = Me.PasswordTest And Len(Me.Password) & "" > 0 Then
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close
DoCmd.OpenForm "LoginF"
[Code] ....
As I say, this works as an accdr file, but not in the actual runtime environment.
View 1 Replies
View Related
Nov 14, 2006
I started access today and all my icons and menus are gone from the interface. I am forced to right click on all my queries and tables to perform any action. All I have at the top of my window is the usual "Microsoft Access" caption. Absolutely nothing else. Other than that, Access is fully functional provided I can use the right click commands. Has anyone encountered this? Help!
-Nino
View 14 Replies
View Related
Sep 13, 2006
Is there a way in a form to have a combo box that causes other fields to show based on the value of the combo box? For example, if there are 3 selections to choose from in that combo box, selecting option 1 causes 5 fields to show up in the form. 5 other fields show up if option 2 is selected, and a different 5 fields for option 3.
I'm trying to track different details for each combo box selection. Right now I have a field for every detail of every option showing, and the form is pretty cluttered. I'm trying to only show the pertinent data.
If it's a built in Access function, that'd be great. If not, and it requires some coding, please know that while I'm very comfortable with computers and have done some programming, I've never done any coding specifically in Access, so I don't even know where to go to edit the code. So if you could point me there, too, I'd appreciate it.
Thanks in advance for the help.
View 8 Replies
View Related
Apr 9, 2014
I have quite a simple function. I am calling it in a query (through the Build window) like this:
Code : AbsMag: getAbsoluteMagnitude([Tbl]![m],[Tbl]![Distance])
When the input value for m is empty/Null, the response returned in the query is #Error. Problem is, any way I try to test for this in the function, it still returns #Error.The Watch for m reads "<Out of Context>" for these errors. Anyway to test/trap for this within the function itself?
Code:
Public Function getAbsoluteMagnitude(m As Double, d As Double, Optional dUnit As String = "Mpc") As Double
Dim absoluteMag As Double
' IsError(m) returns False
' IsNull(m) returns False
' IsEmpty(m) returns False
[code]...
View 3 Replies
View Related
Sep 9, 2005
Hi
with the help of this site, i have made big advances in learning and adapting code, in building my access FE on an SQL BE.
however, i have a problem, i cant find any information on in how to resolve.
i am using menus to navigate between forms, but i cannot synchronise the critical value between the forms.
so i am on a form with critical value, say hullID
i use a menu command to open another form, but i need the form to open with the same hullID as the critical value as the previous form which is about to close.
because i can go to the new form from any form, using the menu command, i cannot directly link the critical value,
is there a way to use the critical value from the current focus form, to the new opening form
many thanks in advance
View 8 Replies
View Related
Feb 4, 2006
I have written a DB for work that collects information on a range of events (eg safety incidents, improvement suggestions, etc) and reports on them. I am now trying to improve the security & integrity of the data by restricting user access to menus.
I can use the start up options to turn off menus, etc but want to allow users to use the default right click menu in forms to sort & filter the forms. But I don;t want users to have access to the other default menus (eg the one containg form deisgn). Is there a way to just select this particular menu to pop up on a right click?
Because I have not been able to find an answer to this I tried designing my own toolbar containig the sort & filter commands I needed. I created a custom tool bar using the menu/customisze options and called it "tbarSortFilt".
As soon as I place it in the menu bar it goes "dim" and I cannot select the options. When I over ride the start up options ("shift" key) and then right click in teh form both the default menu come up (as expected) and the "tbarSortFilt" menu lights up -- but is not active.
I have also tried
DoCmd.ShowToolbar "tbarSortFilt", acToolbarYes
to no avail.
Clearly there is something pretty basic I am not doing. How can I use the strat up options to turn off toolbars and then show AND activate my customized toolbar?
Regards Stephen :confused:
View 2 Replies
View Related
Dec 18, 2007
I have set up a secured database using access 2003 which I want to roll out to users who will only have access runtime installed on their pc's.
The problem is there are some additional options that I want to add to a new menu (export, change password etc) that I need them to be able to view in runtime - when I set up a new menu in access 2003, it doesn't seem to be visible on anybody else's PC when they are logged into the database regardless of whether they have full access or runtime.
Can anybody help?
Many thanks
View 3 Replies
View Related
Apr 11, 2006
It has been ages since I visited the forum, feb 23 to be more exact...
Life has been hell and am crammed for time... This time I have run into something I cannot get a handle on...
On just about any PC this db I build works perfectly, but on one I having some trouble (see attached). I have never experience this.
If I (or the customer) opens the database either by double clicking on the database on the network, double clicking the shortcut it looks like [see attachments OnOpen]
This is not very nice offcourse but is simply solved by clicking the maximize button. After which we see this... [see attachments AfterMax]
From this I can maximize the database screen, but not the form. It stays like that, unless I click design and then Form view. After which the database works normal.
Does anyone have any clue?
View 1 Replies
View Related
Dec 14, 2007
:eek: Our office is planning to switch over to MS Office 2007 including Access 2007. I've just been looking into converting our Access 2003 databases to the new version. One thing I noticed about the datasheets appearing as subforms is that each field header/label/caption/column selector thingie has a dropdown menu. The down arrow of the dropdown menu takes up valuable realestate where the field name is being displayed.
Question:
Is there a way to turn off those individual datasheet dropdowns and get rid of the arrows so that the form doesn't have to be redesigned, due to increased column width considerations which the down arrows cause, just to display the full field labels as they always have been in Access 2003?
Thanks in advance for any help!
Cheers!
Goh
View 9 Replies
View Related
Mar 14, 2006
I have developed an application and packed it into a runtime version.
However, in the runtime version the shortcut menus do not work. The reason why I want the user to have that possibility is that the application has two hyperlink fields and it is much easier for the users to be able to browse to the documents instead of typing each link with all the errors that might give as well.
Any help would be appreciated.
View 4 Replies
View Related
Jul 18, 2014
How I can create an MDE with all options disabled including shift key bypass.
I want to remove all options in Tools>Startup except for the status bar.
I have tried using this code but am not getting anywhere with it
CurrentDb.Properties("AllowByPassKey") = 0
View 8 Replies
View Related
Oct 11, 2007
Hi..
I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.
The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..
How can i see the tables and bva script behind this access file?
I tried F11 and Alt-F11, but is does nothing.
He won't tell me how he did it, because he doesnt like to share what he knows...
Can anyone help me??
Thanx !
View 6 Replies
View Related
Nov 15, 2014
In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.
View 4 Replies
View Related
Jul 24, 2014
I have made a database. I have gotten to the point where I use a form to get the information. I am trying to get the information to auto populate fields after using 3 drop menus. They are department name, shop and shift. All of the information comes out of tbl department name, tbl shop and tbl shift.
I also have a table with department name, shop, shift, line, employee total, shift leader total, ratio of shift leaders per line and total employees off. I am trying to figure out once use the 3 drop down how can I Auto populate the remaining fields. Also I am trying to figure out where and how to put in the code.
View 1 Replies
View Related
Sep 30, 2013
I'm trying to use this command:
Code:
Shell "C:WINDOWSexplorer.exe """ & Me.txtSource & """, VbMaximizedFocus"
to open a folder from within Access 2007 & Windows7. It works, but it always opens the folder minimised, whether I use VbMaximizedFocus or VbNormalFocus. It used to work properly in Access 2003 & WinXP.
View 2 Replies
View Related
Aug 13, 2015
I'm having trouble with a shell() command in my vba.
I'm trying to call up the picture viewer showing the file of the photo I clicked on in a form. Everything is happening as expected - the file opens in Windows Photo Viewer, but it is minimized.
I can open a picture fine from Windows Explorer, but something about my shell command is forcing a minimize.
Here is my code:
Code:
Dim sFile As String
PicFile = "C:Pics" & Me!PicName & ".jpg"
Shell "RunDLL32.exe C:WindowsSystem32Shimgvw.dll,ImageView_Fullscreen " & PicFile
I would have assumed ImageView_Fullscreen would do what I want!
View 4 Replies
View Related
Jul 10, 2006
Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!
View 2 Replies
View Related