Colon between two queries

Question

Hi,

What does colon means between RunSQL and OpenQuery commands below please?

DoCmd.RunSQL "DELETE * FROM tmpqryDailySE_Progress": DoCmd.OpenQuery "appqryDailySE_ProgressWithOutFilter", acViewNormal, acReadOnly

Regards,
K

Answer 1

You use it to place more than one statement into one line. As opposite to the line-continuation character _ which allows to split a single statement over multiple lines.

See statement:

A syntactically complete unit that expresses one kind of action, declaration, or definition. A statement generally occupies a single line, although you can use a colon (:) to include more than one statement on a line. You can also use a line-continuation character (_) to continue a single logical line onto a second physical line.

Answer 2

Hi KhurramKZ,

please visit the link below for more information regarding this.

Special Characters in Code (Visual Basic)

How to: Break and Combine Statements in Code (Visual Basic)

The official link for the VBA is not available. most of the things are common between VBA and VB.

so here just for understand the concept of ":" the link will help you.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 3

Access uses VBA, not Visual Basic.