Search results

Hi, I have forms that disable the Page Up and Page Down keys utilizing the following coding for Key Down in the Form properties. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case 33, 34 KeyCode = 0 End Select End Sub However, I have Memo...

I use Access 2000 and do the following which works great: **********MODULE********** (called LogIn with following coding) Option Compare Database Option Explicit Public lngMyEmpID As Long ' Below moved to Gloval Variables Module ' Global intLogonAttempts As Integer Public...

Hi dcb, Thanks, yes - works using a command button. I am attaching two files, #1 is the original coding used that causes problems, and #2 is the coding using the command button as you suggested. Not sure why #2 works and #1 does not work (??? - any work around?). Mark

Thanks. I put in to close the Modules and Forms (see coding below, although not sure option acQuitSaveNone does anything because same problem occurs with and without the option). It did not work to prevent the Message Box about Quit not being available although the application does quit. I...

Access 2000 (9.0.6926 SP-3)

Yes, I receive same error, but application does quit (as opposed to not quiting with DoCmd.Quit) with same MsgBox still on screen: Run-time error "2046": The command or action 'Quit' is not available now. with same buttons available End and Debug active (but Continue and Help buttons grayed...

Hi, I am having a problem with an On Open Event Procedure. I have a main form - fMainForm1 that loads on Startup with a subform - frmHelpAbout, which is designed to display certain information and check to see if certain Tables are present. If the Tables are present, after a short time delay...

Hi missinglinq, I inserted the above code as stated (substituting the names I use for the combo boxes) to try it, but on Compile got Compile Error that state for intMonth and intDay "Variable not defined." Help. Thanks.

Thanks, looks like that is the way to go. I did try things with the Input Mask and Format in the Table, but it seems it will not work, so going with combo boxes solves the problem.

Hi, hope someone can help me. I have a table where a Field Name has Data Type of Date/Time with Format "mm"/"dd" and Input Mask of Short Date 99/99/0000;0;_ In the form the Text Field with source from that Field Name has Input Mask as 99/99;_ The text field in the form shows __/__ in the...

Hi everyone, While there were a good many views of my issue, there was no reply; which is OK because being a novice I am not sure I explained it adequately perhaps. Anyway, a friend of mine who knows Access and VBA a whole lot more than me, came up with the solution. For a command button's On...

I am learning Access, using Access 2000. I created a database to have a Main Menu form (which has a picture for the background showing command button background pictures for places where I have command buttons) with command buttons (transparent) on the form that open other forms and closes the...