If and End IF - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

If and End IF

Maarten Brusselers

4 years ago

When I run the delete query from the SQL seminar I get an error message. If I delete the "end if" it runs without problem I don't understand this. I thought you always need an "end if" when you use "if". Richard's video also included an end if.

	Maarten Brusselers OP @Reply 4 years ago

	Maarten Brusselers OP @Reply 4 years ago

	Maarten Brusselers OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
You don't need an End If if the statement is all on one line. Consider the 2 If statements below: `If X = 5 Then Y = 7` `If X = 5 Then Y = 7 End If`

	Maarten Brusselers OP @Reply 4 years ago
Thanks Kevin. That was not mentioned in the seminar.

	Kevin Yip @Reply 4 years ago
Hi Maarten, the SQL seminar does recommend the Developer 1 class that covers VBA basics like If Then Else.

Richard Rost @Reply

4 years ago

Thanks, Kevins LOL.

Yes, Maarten, you really should have a solid understanding of VBA basics before this seminar. This is from the SQL Server Part 1 page:

"This is a Developer-Level Seminar. There will be some VBA coding. It is strongly recommended that you have completed my entire Access Beginner and Expert series. My Developer 1 class is highly recommended so you understand the basics of programming in VBA. If not, at least watch my free Intro to VBA video."

I see you're still in the Expert courses. So I'd recommend you at least watch these before continuing:

Intro to VBA
If Then

	Maarten Brusselers OP @Reply 4 years ago
I'll get to the Advanced/Developer series soon.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View