Hi Bill,
macros are generally for people who are not developers ... and those who are creating web databases.
macros do not have as much power as VBA and they are more time-consuming to find and document
Warm Regards,
Crystal
Learn Access on YouTube
http://www.YouTube.com/LearnAccessByCrystal
*
(: have an awesome day :)
*
________________________________
From: agent1of6
Crystal,
One more question if you do not mind. I have three combo boxes to check and then open a form. I have successfully finished the code and it runs great. (thank you) In Access 2010 it appears as if I could also have done this by creating a MACRO BLOCK. Which method do you think is better, or does it not matter?
Thanks,
Bill
--- Crystal wrote:
>
> you're welcome, Bill ;) happy to help
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Bill Singer
>
> Crystal,
>
> Thank you. Null is not a number. I will remember that.
>
>
>
> Bill Singer
>
>
>
> From: Crystal
>
>
> Hi Bill,
>
> first: NAME the command button something logical before you assign code,
> like cmd_OpenQueryName
>
> Null is not a value, it is the absence of a value, so you cannot compare to
> it using =
>
> '~~~~~~~~~~~~~~~~~~~~~~~~
>
> if isNull(me.controlname) then
> me.controlname.setfocus
> MsgBox "Season field must be filled",,"Missing Data"
>
> 'if control is a combo, then drop the list
> me.controlname.dropdown
> EXIT SUB
> end if
> ' more statements
>
> '~~~~~~~~~~~~~~~~~~~~~~~~
>
> Warm Regards,
> Crystal
>
> Microsoft MVP, Access
> remote training and programming
>
> www.AccessMVP.com/strive4peace
>
> www.YouTube.com/LearnAccessByCrystal
> www.YouTube.com/LearnByCrystal
>
> * (: have an awesome day :) *
>
> ________________________________
> From: agent1of6 <Bill.Singer@...
> <mailto:Bill.Singer%40at-group.net> >
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, May 30, 2012 8:31 PM
> Subject: [MS_AccessPros] Value of Combo Box
>
> I tried writing my first bit of code without help and went down if flames.
>
> I have a form that the user will select a value from a Combo box and then
> press a button to view the next form, sorted by the combo box.
>
> As the first part of the code I tried to use...
>
> Private Sub Command12_Click()
> If [cboSeason] = Null Then
> MsgBox "Season field must be filled"
> End If
>
> End Sub
>
> The "Null" does not work. If I put a value in there(If [cboSeason] = 1)
> and then set the combo box to that value it works fine.
>
> What is the value of an unfilled combo box? I figured it would be Null. An
> empty combo box = Null comes up False.
>
> I am trying to eliminate the Access error boxes when a query is run without
> the combo boxes being full.
>
> Thanks for your help.
> Bill
> MN
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar