CurrentDb.Execute returning 'Too few parameters' error.

WeeZaliban

New Member
Joined
Jul 26, 2013
Messages
16
I have been building a Sub in a standalone database and have run into an issue with running a query native to the same database.

I have in the same sub as part of an If function, another CurrentDb.Execute and it works fine; however, when it gets to the next part of the Sub, the secondary CurrentDb.Execute, I get the 'too few parameters error'.

Both Update Queries are built in SQL in Access 2007 and function properly when executed.

Here's a sample of the code I have:

Code:
If insertstuffhere Then
CurrentDb.Execute ("First Update Query That Works"), dbFailOnError
Else
Me.StatusLabel.Caption = "Witty text"
End If

If insertstuffhere_part2 Then
CurrentDb.Execute ("Second Update Query That Doesn't Work"), dbFailOnError
Else
Me.StatusLabel.Caption = "More witty text"
End If
Any help is greatly appreciated!

Thanks,

WeeZ
 

Forum statistics

Threads
1,084,884
Messages
5,380,436
Members
401,678
Latest member
saffar

Some videos you may like

This Week's Hot Topics

Top