CTRL W Shortcut (to Close Form Window) Not Working With Popup
Nov 28, 2011As the title says, ctrl-W works on all my other forms but not on the one which has Pop-up set to "Yes".
View Replies
ADVERTISEMENT
Modules & VBA :: Login To Database - Close A Modal Popup Window
May 2, 2014I've tried to add some basic login (not really security) to my database so that when a different name is entered into the login box a different form is opened.
I got this working but the login form stays in foreground and I can't click anything behind it and can't get to the design view to change any properties of anything.
I've also changed this login form to the startup item so it always loads when i start the database.
Is there way to get back to the design view or do i have to start again from my backup?
Forms :: Disable Delete A Record Shortcut CTRL
Mar 24, 2015I would like to disable the shortcut, CTRL - which allows a user to delete a record. A user accidentally deleted a record while typing in an email address that had an underscore in the email address. While trying to type it she must have hit the CTRL key instead of the Shift key follow by the -. She noticed the delete confirmation, but not thinking, pressed enter and thus confirmed the deletion of the record.
Other than telling her to pay more attention, how can I disable the shortcut in Access 2013?I tried using the Application.OnKey "^-", "" but I continue getting the error method or data member can not be found
Close Popup Menu Form
Sep 17, 2006I've created a popup menu form to be loaded when you cick on another form. I need to know how to get the popup menu form to close when you click off it. I've tried using lostfocus and deactivate but that didn't work. Modal is set to no. What code should i use and where would it go?
View 8 Replies View RelatedModules & VBA :: Form Window To Popup On Opening Database
Dec 4, 2013How I configure my Form Window to pop up as soon as I open my Access Database?
View 3 Replies View RelatedForms :: Requery Form And Subform After Popup Form Close
Aug 19, 2013I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.
Form 1
subform 1 > button to open pop up form
subform 2
subform 3
I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.
On pop up form close, what's the correct syntax for re-querying subform 1?
Open Form On Close Of RelationShip Window
Aug 12, 2005Folks,
i open my relationship window from a form and i after hide its visibility using the code below.
DoCmd.RunCommand acCmdRelationships
Forms![frmRelations].Visible = False
I need to open the hidden form after clicking on the close(x) button of the relationship window.
Are there any ideas please.
How To Disable Save / Close Window In Form
Aug 14, 2012I would like to disable this window : (which appears by right-clicking mouse on form headline)
So the users won't be able to close form by right-clicking. How to do it?
Forms :: Ctrl F Not Working In Navigation From
Apr 8, 2014I am using Access 2010.
In my database forms, i try to use Ctrl + F and its working fine. But when i link that form to a Navigation form and tried ctrl + F , i got the following error message, how to fix it.
Error msg.
You Can't use find or replace now.
I also attached the error msg.
Hiding Close Button When Form Window Maximised
May 8, 2006Hi,
Anyone know in microsoft access 97 is it possible to remove the close button (top right hand corner) when a form is maximised?
Thanks.
Forms :: Disable Or Hide Minimize / Restore And Close Window Buttons On A Form
Mar 9, 2014I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.
I navigation buttons that controls open, close etc already set up.
Default Window Dimension Settings When Opening Via .MAF Desktop Shortcut
Mar 19, 2008Hi there,
My problem seems somewhat simple, but I guess since I'm posting this it was quite the contrary. I've completed my form and have linked all queries and reports and created all my macros for the form. Everything looks great but I when I created a .MAF shortcut to access the form directly from my desktop, it opens the form really big and maximized. Every time I open it, I hit the 'restore down' box-in-box button on the top right and it makes it just how I want it. Can I retain this as a default setting when I open it? I've checked in the Form options but no luck.
Richard
Make Popup Form (Dialog)'s Height As Same As Window/Montior/Screen Height
May 7, 2008Hi,
When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So, I have to make it flexiable change of the height of the popup form.
How can I check the screen/window height by VBA function?
In Excel, it has Application.Height to check. In MS Access Form, I cannot find one for doing that.
Please let me know if you have one.
Thanks.
Javascript Popup Window
Oct 25, 2005I have created an asp popup window that is called by a javascript function from another asp page. The popup window is generated from a database. The code on the mainpage to generate the popup window is:
Code:<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"><!--function showCalendar(i) {// declare variablevar tbm;// assign field name to variable // based on argumentif(i==1) tbm='FrontPage_Form1.PerDate1';if(i==2) tbm='FrontPage_Form1.PerDate2';if(i==3) tbm='FrontPage_Form1.PerDate3';if(i==4) tbm='FrontPage_Form1.PerDate4';if(i==5) tbm='FrontPage_Form1.PerDate5';if(i==6) tbm='FrontPage_Form1.PerDate6';if(i==7) tbm='FrontPage_Form1.PerDate7';if(i==8) tbm='FrontPage_Form1.PerDate8';if(i==9) tbm='FrontPage_Form1.PerDate9';if(i==10) tbm='FrontPage_Form1.PerDate10';// call pop up calendar// passing field name variablewindow.open('../../calendar/calpop.asp?tbm='+tbm,'ncal');}function showDirectory(i) {// declare variablevar dept;// assign field name to variable // based on argumentif(i==1) dept='FrontPage_Form1.TaskOwner1';if(i==2) dept='FrontPage_Form1.TaskOwner2';if(i==3) dept='FrontPage_Form1.TaskOwner3';if(i==4) dept='FrontPage_Form1.TaskOwner4';if(i==5) dept='FrontPage_Form1.TaskOwner5';if(i==6) dept='FrontPage_Form1.TaskOwner6';if(i==7) dept='FrontPage_Form1.TaskOwner7';if(i==8) dept='FrontPage_Form1.TaskOwner8';if(i==9) dept='FrontPage_Form1.TaskOwner9';if(i==10) dept='FrontPage_Form1.TaskOwner10';// call pop up directory// passing field name variablewindow.open('../../ProfDirectory/DeptPeople.asp?dept='+dept);}//--></SCRIPT>...... <tr> <td width="118" height="22" align="center" nowrap> <p align="center"> <input type="text" name="PerDate1" readonly="true" size="8"> <A HREF="javascript:showCalendar(1);"><IMG SRC="../../calendar/10Min200011cal.gif" WIDTH="39" HEIGHT="21" ALT="Click here to select date" BORDER="0" align="center"></A> </p> </td> <td width="160" height="22" align="center"> <p align="center"><input type="text" name="TaskOwner1" size="8"> <A HREF="javascript:showDirectory(1);"><IMG SRC="../../calendar/10Min200011cal.gif" WIDTH="39" HEIGHT="21" ALT="Click here to select date" BORDER="0" align="center"></A></p> </td>
The first popup calls up a calendar. The calendar works fine. The second popup calls up a staff directory. This popup does not work.
Code:The code for the staff popup is:<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"><!--function SetTaskOwner(d) {opener.document.<%=Request("dept")%>.value = d ;self.close ();}//--></SCRIPT>......<%Session.timeout = 1Set conn = Server.CreateObject("ADODB.Connection")txtDSN = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=d:InetPubwwwrootpagescommoncivil.mdb"conn.Mode=adModeReadconn.open txtDSN,"",""Set Session("people_conn") = conn%><%sql = "SELECT WebData.* FROM WebData WHERE (((WebData.class)='faculty')) AND (((WebData.Status)='active')) ORDER BY WebData.LastName"pagetitle1="Faculty sorted by last name"Set rs = Server.CreateObject("ADODB.Recordset")rs.Open sql, conn%>....do while Not rs.eof.... owner = rs.Fields("UWID").Value webpage="javascript:SetTaskOwner(" & owner & ");" %> <tr> <td><a HREF="<%=webpage%>"><%=name%></a></td>.....rs.MoveNextloopconn.close'session.abandon%></table>
The popup appears and the database generate the results as expected. When I click on the hyperlink the javascript gives me an error. I can see in the status bar though that the hyperlink's value is: javascript:setTaskOwner(me), for example. So I think the error is due to the opener.document.<%=Request("dept")%>.value = d or self.close (); lines of javascript.
How Do I Set Up A Popup Window To Inform Me Of A Due Date
Jul 5, 2005I am setting up a database for a group of roll on roll off students. It would be really usefull if i recieved somesort of pop up message informing me 2 weeks before any particular student is due for release from the course. I have all their details plus their release date in a table. :confused:
Thanks in advance
Forms :: Popup Window To Save File At Any Location
Feb 23, 2014I find the following CODE online (Print to PDF). Which work perfectly for me, the only issue and/or modification I am looking for "Popup Window to save the file at any location", instead at fixed location.
Option Compare Database
Option Explicit
Function PrintToPDF(SrcFile As String)
On Error GoTo PrintToPDF_Err
'Function can be called from any report with this: "PrintToPDF(Screen.ActiveForm.Name)"
[Code] ....
Restore Window Size On Close
Jan 12, 2006Hey guys,
I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed.
I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving me the syntax and where to put this code that would be fantastic :)
How Can You Disable The Close (X) Button On The Database Window?
Dec 6, 2006Hi Guys,
I have a database that uses a switchboard with a close button that runs several instructions before it exits. The problem is that some users have access to the database window and I need to prevent them from closing the database by hitting the X in the upper right.
Anyone know how to do this?
Reports :: Display Report In Popup Window And Maximize In Print Preview Layout
Dec 22, 2013I have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file.
Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier?
Forms :: Disable Ctrl F4 Key On Form
Jul 22, 2014I have tried a few combinations with No success! Using Access 2010 32 bit.
Select Case KeyCode
Case vbKeyF4
'MsgBox "The F4 key was Pressed"
KeyCode = 0
Case Else
'MsgBox "No match!" 'testing
End Select
Dim intAltDown As Integer
intAltDown = (Shift And acAltMask)
> 0
None Working "simple Code" On Close Event?
May 16, 2006I have witten a code in the close event of a "Primary" form that would update a Combo boxe on a "secondary" form only if the "secondary" form is open.
ie:
Private Sub Form_Close()
If Forms!frmEnquiry.Open Then
Forms!frmEnquiry!CboCustomer.Requery
Else
DoCmd.Close
End If
End Sub
This code keeps giving me an error, is anybody has got any idea why?
Thanks in advance.
Duplicate Record Command Button Not Working For One Form But Is Working For Other Form
Jan 15, 2015I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.
I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?
Customising A Form Shortcut??
Mar 14, 2006Hi there, this maybe very simple but I can't seem to sort it out... I have a created a shortcut to my form database on my desktop but I want to know if there is a way in which I can make it so whenever I use the shortcut my database will open as a maximized screen as opposed to opening in a small window which it keeps doing, meaning I always have to maxmise (it may seem like something small but it gets quite annoying after a while) Can this be done? Or even better can I make it so that JUST the form opens and not the whole access program, as the other people using the database don't need to see and use anything else but the form. Any help would be much appreciated. Thanks
View 1 Replies View RelatedForms :: Shortcut For Inputting Date Value In A Form
Mar 10, 2014If memory serves me right, I've seen code or maybe a shortcut somewhere for inputting a date value in a form along the following lines.
To input today's date, input "0"
Yesterday = "-1"
A week ago = "-7"
and so on.
Forms :: Disable Shortcut / Right Click On A Form
Oct 21, 2013I am running Access 2010. I have added the following to the "On Open" event on my main form:
Code:
Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
Me.ShortcutMenu = False
End Sub
My main form (frmMain) is displayed when the database opens. As you can see, I am hiding the ribbon and the navigation pane from users. I also want to prevent users from right clicking on the form and opening it in Design view - trying to prevent any monkey business. However, the line:Me. ShortcutMenu = False
is not preventing users from right clicking on the form and getting the shortcut menu and going into Design view.If I go to Options and uncheck: "Allow Default Shortcut Menus" then I lose the ability to print reports because I have the ribbon hidden and this will not allow right click on reports.Converting to .accde is not an option at this time.
Ctrl+Tab Problem
Jul 14, 2005It seems you can use ctrl+Tab to step through the pages on a tab control and bypass normal events. Is there a way to stop this?
View 2 Replies View Related