By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Repost: To Dev Ashish (Concat query)

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

P: n/a

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.


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.