Simple Syntax Question

[Patrick]

Hi... I am trying to design my first Data Access Page in
MS Access XP and I have a really simple syntax question. I
need to know the proper syntax for Microsoft Script for
the following:

Ser = chr(34) & "LogicalCubeName=" & LogicalCubeName.value
& chr(34)

This script works perfectly well to link a simulated
SubForm to the Main Form but ONLY IF LogicalCubeName is a
Numeric Data Type. What, however, is the proper syntax if
LogicalCubeName is a String? In VBA it would be very
simple, add the additional 1/2 quote marks:

Ser = chr(34) & '"LogicalCubeName="' &
LogicalCubeName.value & chr(34)

Notice the extra half quote, but when I try this syntax
in Microsoft Script, LogicalCubeName becomes Green
similar to if I am trying to 'nest' a comment.

Can someone assist me with this real simple question?

Thanks

Pat

 

[Douglas J. Steele]

You've got the order of the quotes reversed. Exagerated to make it clearer,
you need:

Ser = chr(34) & '"LogicalCubeName= ' " & LogicalCubeName.value & " ' " &
chr(34)

 

[Pat]

Thanks for your assistance Doug. It worked.

Pat

-----Original Message-----
You've got the order of the quotes reversed. Exagerated to make it clearer,
you need:

Ser = chr(34) & '"LogicalCubeName= ' " &

LogicalCubeName.value & " ' " &