Search results

Thanks, R. Hicks.

Private Sub txtDate_BeforeUpdate(Cancel As Integer) If IsDate(txtDate) Then MsgBox "Valid Date entered" 'Msg1 Else MsgBox "Invalid Date entered!" 'Msg2 End If End Sub The code above works OK for: a valid txtDate (Msg1 is displayed), and an empty txtDate (Msg2 is displayed). However, if I...

Private Sub txtDate_BeforeUpdate(Cancel As Integer) If IsDate(txtDate) Then MsgBox "Valid Date entered" 'Msg1 Else MsgBox "Invalid Date entered!" 'Msg2 End If End Sub The code above works OK for: a valid txtDate (Msg1 is displayed), and an empty txtDate...

To Fizzio: I need the Word doc to populate in an empty Access Form for viewing purpose only; assuming MS Word is not loaded on my computer.

Please Help. I need to know how to display an MS Word document as a popup Form when a command button is clicked. Thanks.

Thanks to llkhoutx and WayneRyan for the suggestions. Basically, I'd like to create something similar to an Access Form with only labels(?); each label's content would be a short sentence/paragraph. There would be another command button in the form's footer to close the form. Being a Junior...

I'd like to display a Help screen (non-Web based, vertical scrolling would be a plus) when a command button is clicked. Please advise. Thanks.

I got it working. Thanks.

Please Help. I'd like a click procedure to copy data from 3 unbounded Text Boxes (txtNum, txtText, and txtDate) on a form, to the corresponding fields TempQty, TempTxt, and TempDate in Table tblTemp. Table tblTemp was created and is empty. Thanks. Also, thanks to ChrisO and Mile-O-Phile for...

Mile-O-Phile: Your additional suggestion (Call Form_Current) in Form_Load produced 2 MsgBox PRIOR to the form display, if the first record is applicable. Please HELP!

I need to know how to display a message whenever the value of a bounded Text Box (Enabled = No) on a form is ZERO when navigating. Thanks. Mile-O-Phile suggested the following code: ------------------------------------------------------ Private Sub Form_Current() If Me.txtYourTextbox = 0...

I need to know how to display a message whenever the value of a bounded Text Box (Enabled = No) on a form is ZERO when navigating. Thanks.

I need to know how to remove the New Record button on the navigation bar at the bottom of a form (which is based on a table). Also, I would like to disable the New Record button on the toolbar when this form is activated. Thanks.

HELP! I set up a hazardous material table named tblReceivals with the following fields: MaterialName, QtyReceived, QtyDisposed, QtyRemained, etc. I also set up a data entry form named frmReceivals where the user can populate the QtyReceived field for adding a new record. The QtyRemained...