Repost: To Dev Ashish (Concat query)

[Roy]

I used your Concat query in one of my application,with a lil change.I
am trying to concatenate a text field using a number field as the key
field.
Application:
fConcatFld("BaseSelection_tbl"*,"EventID","Applica tionName","*long",[EventID]).

The code bombs at the line, Case "Long", "Integer", "Double":
'AutoNumber is Type Long
loSQL = loSQL & "[" & stForFld & "] = " & vForFldVal
The error is # 3061,missing parameter.Expected 1.I tried several ways
,but in vain.
I need help.
Thanks,
Roy

[Douglas J. Steele]

The most likely cause is that you've mistyped one (or more) of
"BaseSelection_tbl"*, "EventID", or "ApplicationName": you've left out
spaces, underscores, or something like that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Roy" <pr********@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I used your Concat query in one of my application,with a lil change.I
am trying to concatenate a text field using a number field as the key
field.
Application:
fConcatFld("BaseSelection_tbl"*,"EventID","Applica tionName","*long",[EventID]).

The code bombs at the line, Case "Long", "Integer", "Double":
'AutoNumber is Type Long
loSQL = loSQL & "[" & stForFld & "] = " & vForFldVal
The error is # 3061,missing parameter.Expected 1.I tried several ways
,but in vain.
I need help.
Thanks,
Roy

[Roy]

Doug,
Thanks for the reply.Infact i went through the typos,spaces and
other things before i posted here.Infact i changed the table name to
just "BaseSelection" too.

Thanks,

Roy

Douglas J. Steele wrote:

The most likely cause is that you've mistyped one (or more) of
"BaseSelection_tbl"*, "EventID", or "ApplicationName": you've left out
spaces, underscores, or something like that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Roy" <pr********@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I used your Concat query in one of my application,with a lil change.I
am trying to concatenate a text field using a number field as the key
field.
Application:
fConcatFld("BaseSelection_tbl"*,"EventID","Applica tionName","*long",[EventID]).

The code bombs at the line, Case "Long", "Integer", "Double":
'AutoNumber is Type Long
loSQL = loSQL & "[" & stForFld & "] = " & vForFldVal
The error is # 3061,missing parameter.Expected 1.I tried several ways
,but in vain.
I need help.


Thanks,
Roy

[Chuck Grimsby]

What "lil change" did you make to the code?

Also, set a breakpoint at the OpenRecordset line, and do a Print on the
SQL string being used. This will give you something to work with, and
no doubt show where the "missing parameter" is. (Probably a mistyped
field name.)

Roy wrote:

I used your Concat query in one of my application,with a lil change.I
am trying to concatenate a text field using a number field as the key
field.
Application:
fConcatFld("BaseSelection_tbl"*,"EventID","Applica tionName","*long",[EventID]).
The code bombs at the line, Case "Long", "Integer", "Double":
'AutoNumber is Type Long
loSQL = loSQL & "[" & stForFld & "] = " & vForFldVal
The error is # 3061,missing parameter.Expected 1.I tried several ways
,but in vain.
I need help.