Avatar of mustish1
mustish1

asked on 

Expected: List separator or )

Hi: Can any one please tell me where the syntax error is in that line?
". & vbCrLF & "

intReply = MsgBox("Your document is in My Documents with the name " & strFileName". & vbCrLF & " Do you want to open it now?", vbOkCancel)

Thanks.
Microsoft AccessVisual Basic Classic

Avatar of undefined
Last Comment
stevbe
Avatar of R_Rajesh
R_Rajesh

Use this:

intReply = MsgBox("Your document is in My Documents with the name " & strFileName & vbCrLf & " Do you want to open it now?", vbOKCancel)
Avatar of mbizup
mbizup
Flag of Kazakhstan image

intReply = MsgBox("Your document is in My Documents with the name " & strFileName & vbCrLf & ".  Do you want to open it now?", vbOKCancel)
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of stevbe
stevbe

". & vbCrLF & "


it is the period after the " and before the &

I am assuming it was a typo :-)

Access has no idea of what you are talking about ... it is not a variable, built-in function or constant.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo