Thanks Duane and John!
I think I will manage now!
Regards
Dennis
19 okt 2011 kl. 17:34 skrev Duane Hookom:
>
> Have you tried setting the field to required in the table?
> You could also do this with validation rule on the form control.
>
> Duane Hookom
> MS Access MVP
>
>
>> To: MS_Access_Professionals@yahoogroups.com
>> From: dennisdavidsson@ymail.com
>> Date: Wed, 19 Oct 2011 17:25:48 +0200
>> Subject: Re: [MS_AccessPros] How to show a warning msg, when user leaves a form
>>
>> John,
>>
>> I wanted to be sure that the incompletely filled in record could in no way by mistake be saved into the database containing null in the critical field, a combo box. I tried around with a few examples, and think the Event property 'Before update' would be the right alternative.
>> Then however I jumped into next problem: Hoping to test on Null in the combo box, I wrote a piece of code like this:
>> 'If Me!Bransch.Column(1) is Null Then
>> MsgBox "warning∑.."
>> End If
>> However, executing this line Access shows an error box saying:
>> 'Object is required.'
>> I have run the code in single step mode and checked that the value of Me!Bransch.Column(1) actually is Null.
>> What am I doing wrong?
>> Dennis
>>
>>
>> 19 okt 2011 kl. 15:51 skrev John Viescas:
>>
>>> Dennis-
>>>
>>> Is the form bound? (i.e. has a Record Source)
>>>
>>> Please explain what you mean by "leave the form." Close it? Move to another
>>> record? Put the focus on another form?
>>>
>>> John Viescas, author
>>> Microsoft Office Access 2010 Inside Out
>>> Microsoft Office Access 2007 Inside Out
>>> Building Microsoft Access Applications
>>> Microsoft Office Access 2003 Inside Out
>>> SQL Queries for Mere Mortals
>>> http://www.viescas.com/
>>> (Paris, France)
>>>
>>> -----Original Message-----
>>> From: MS_Access_Professionals@yahoogroups.com
>>> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
>>> Sent: Wednesday, October 19, 2011 3:47 PM
>>> To: MS_Access_Professionals@yahoogroups.com
>>> Subject: [MS_AccessPros] How to show a warning msg, when user leaves a form
>>>
>>> Hello,
>>>
>>> I want to show a warning message to the user, if he leaves the active form
>>> without having filled in all boxes properly, because none of the boxes must be
>>> left with nulls.
>>> I assume this can be accomplished by issuing a MsgBox statement in some Event
>>> Property of the form.
>>> But which is the relevant Event Property to choose for this, so that it covers
>>> all possible ways of leaving the form?
>>>
>>> Regards
>>> Dennis Davidsson
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>> ------------------------------------
>>>
>>> Yahoo! Groups Links
>>>
>>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> ------------------------------------
>>
>> Yahoo! Groups Links
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar