If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Message Box for Form
that's not very informative; if you want detailed help, give detailed
information. what exact error codes and text, and when did they occur? and in what order? "Dave Elliott" wrote in message . com... That code freaked out the form with errors. "tina" wrote in message ... try If Not IsNull(Me!SubformCONTROLName!CheckNo) Then MsgBox "Check Has Already Been Printed" End If make sure you use the subform control name, not the subform name - they may be the same, or may be different. to get the control name, open the main form in design view. click once on the subform to highlight it *in the main form*. in the Properties box, click the Other tab and look at the Name property. that's the subform control name. hth "Dave Elliott" wrote in message m... The code is being triggered by the main form right now ON LOAD Event I need to see the Messabe Box Before the Main form Loads as a Reminder. Thanks, "tina" wrote in message ... to give a more specific answer, i need more detail. the CheckNo control is on a subform, i got that from your first post. but do you want the code to be triggered from the main form? or from within the subform? how are you triggering the code, by a control's AfterUpdate event? by a form's BeforeUpdate event? from a command button? you need to explain what you're doing in the form, and at what point in the process you need to see the message. "Dave Elliott" wrote in message . .. This code does not refer to the sub-form and so it wont work. What can I do? It shows the message box even when there are no checks with a value in (ChkNo). "tina" wrote in message ... try If Not IsNull(CheckNo) Then MsgBox "Check Has Already Been Printed" End If attach the code to whatever event that you want to trigger the message. hth "Dave" wrote in message . com... I have a form named FEmpTotHours with a sub-form on it named PayrollCheck When the sub-form control named CheckNo has a value in it, (a number) I would like for a message box to open and say Check Has Already Been Printed. How can I do this? Thanks, Dave |
#22
|
|||
|
|||
Message Box for Form
use the IsNull() function as demonstrated in my previous post. as for the
syntax of the field reference, usually when you're running code from within the main form, you don't have to reference the subform's Form property - unless you're manipulating a specific form property of the subform such as Filter or Requery. but if it takes the full reference to make it work in this instance, that's fine. "Dave Elliott" wrote in message news I believe it is something like this, but my syntax is wrong. If Not IsNull "[Forms]![FEmpTotHours].[Payroll Check].Form![CheckNo]" Then MsgBox "Some Checks Have Already Been Printed" End If "Dave Elliott" wrote in message . com... That code freaked out the form with errors. "tina" wrote in message ... try If Not IsNull(Me!SubformCONTROLName!CheckNo) Then MsgBox "Check Has Already Been Printed" End If make sure you use the subform control name, not the subform name - they may be the same, or may be different. to get the control name, open the main form in design view. click once on the subform to highlight it *in the main form*. in the Properties box, click the Other tab and look at the Name property. that's the subform control name. hth "Dave Elliott" wrote in message m... The code is being triggered by the main form right now ON LOAD Event I need to see the Messabe Box Before the Main form Loads as a Reminder. Thanks, "tina" wrote in message ... to give a more specific answer, i need more detail. the CheckNo control is on a subform, i got that from your first post. but do you want the code to be triggered from the main form? or from within the subform? how are you triggering the code, by a control's AfterUpdate event? by a form's BeforeUpdate event? from a command button? you need to explain what you're doing in the form, and at what point in the process you need to see the message. "Dave Elliott" wrote in message . .. This code does not refer to the sub-form and so it wont work. What can I do? It shows the message box even when there are no checks with a value in (ChkNo). "tina" wrote in message ... try If Not IsNull(CheckNo) Then MsgBox "Check Has Already Been Printed" End If attach the code to whatever event that you want to trigger the message. hth "Dave" wrote in message . com... I have a form named FEmpTotHours with a sub-form on it named PayrollCheck When the sub-form control named CheckNo has a value in it, (a number) I would like for a message box to open and say Check Has Already Been Printed. How can I do this? Thanks, Dave |
#23
|
|||
|
|||
Message Box for Form
use the IsNull() function as demonstrated in my previous post. as for the
syntax of the field reference, usually when you're running code from within the main form, you don't have to reference the subform's Form property - unless you're manipulating a specific form property of the subform such as Filter or Requery. but if it takes the full reference to make it work in this instance, that's fine. "Dave Elliott" wrote in message news I believe it is something like this, but my syntax is wrong. If Not IsNull "[Forms]![FEmpTotHours].[Payroll Check].Form![CheckNo]" Then MsgBox "Some Checks Have Already Been Printed" End If "Dave Elliott" wrote in message . com... That code freaked out the form with errors. "tina" wrote in message ... try If Not IsNull(Me!SubformCONTROLName!CheckNo) Then MsgBox "Check Has Already Been Printed" End If make sure you use the subform control name, not the subform name - they may be the same, or may be different. to get the control name, open the main form in design view. click once on the subform to highlight it *in the main form*. in the Properties box, click the Other tab and look at the Name property. that's the subform control name. hth "Dave Elliott" wrote in message m... The code is being triggered by the main form right now ON LOAD Event I need to see the Messabe Box Before the Main form Loads as a Reminder. Thanks, "tina" wrote in message ... to give a more specific answer, i need more detail. the CheckNo control is on a subform, i got that from your first post. but do you want the code to be triggered from the main form? or from within the subform? how are you triggering the code, by a control's AfterUpdate event? by a form's BeforeUpdate event? from a command button? you need to explain what you're doing in the form, and at what point in the process you need to see the message. "Dave Elliott" wrote in message . .. This code does not refer to the sub-form and so it wont work. What can I do? It shows the message box even when there are no checks with a value in (ChkNo). "tina" wrote in message ... try If Not IsNull(CheckNo) Then MsgBox "Check Has Already Been Printed" End If attach the code to whatever event that you want to trigger the message. hth "Dave" wrote in message . com... I have a form named FEmpTotHours with a sub-form on it named PayrollCheck When the sub-form control named CheckNo has a value in it, (a number) I would like for a message box to open and say Check Has Already Been Printed. How can I do this? Thanks, Dave |
#24
|
|||
|
|||
Message Box for Form
use the IsNull() function as demonstrated in my previous post. as for the
syntax of the field reference, usually when you're running code from within the main form, you don't have to reference the subform's Form property - unless you're manipulating a specific form property of the subform such as Filter or Requery. but if it takes the full reference to make it work in this instance, that's fine. "Dave Elliott" wrote in message news I believe it is something like this, but my syntax is wrong. If Not IsNull "[Forms]![FEmpTotHours].[Payroll Check].Form![CheckNo]" Then MsgBox "Some Checks Have Already Been Printed" End If "Dave Elliott" wrote in message . com... That code freaked out the form with errors. "tina" wrote in message ... try If Not IsNull(Me!SubformCONTROLName!CheckNo) Then MsgBox "Check Has Already Been Printed" End If make sure you use the subform control name, not the subform name - they may be the same, or may be different. to get the control name, open the main form in design view. click once on the subform to highlight it *in the main form*. in the Properties box, click the Other tab and look at the Name property. that's the subform control name. hth "Dave Elliott" wrote in message m... The code is being triggered by the main form right now ON LOAD Event I need to see the Messabe Box Before the Main form Loads as a Reminder. Thanks, "tina" wrote in message ... to give a more specific answer, i need more detail. the CheckNo control is on a subform, i got that from your first post. but do you want the code to be triggered from the main form? or from within the subform? how are you triggering the code, by a control's AfterUpdate event? by a form's BeforeUpdate event? from a command button? you need to explain what you're doing in the form, and at what point in the process you need to see the message. "Dave Elliott" wrote in message . .. This code does not refer to the sub-form and so it wont work. What can I do? It shows the message box even when there are no checks with a value in (ChkNo). "tina" wrote in message ... try If Not IsNull(CheckNo) Then MsgBox "Check Has Already Been Printed" End If attach the code to whatever event that you want to trigger the message. hth "Dave" wrote in message . com... I have a form named FEmpTotHours with a sub-form on it named PayrollCheck When the sub-form control named CheckNo has a value in it, (a number) I would like for a message box to open and say Check Has Already Been Printed. How can I do this? Thanks, Dave |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
msimn.exe-Application error message | Blondenblue_uk | Outlook Express | 2 | July 23rd, 2004 01:03 PM |
Invalid Page Fault on Quitting Oulook Express | HandyAndy | Outlook Express | 2 | July 9th, 2004 12:46 PM |
OE - all mail and folders gone! HELP! | Raoul | Outlook Express | 2 | July 8th, 2004 12:17 PM |
help - lost all my dbx file | Jim Pickering | Outlook Express | 1 | July 7th, 2004 12:42 PM |
Can't delete message from Outbox | Barry Brown | General Discussion | 14 | June 9th, 2004 06:10 AM |