Using an InpoutBox in an SQL statement

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Using an InpoutBox in an SQL statement

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 30th, 2006, 04:01 PM

stepdev

stepdev is offline

Authorized User

Join Date: Mar 2006

Posts: 21

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Using an InpoutBox in an SQL statement

I am trying to use the InputBox statement in my SQL statement.

SELECT * FROM DbX WHERE NicIP = InputBox(Prompt:="Enter NICIP?")

I get the error improper use of Prompt.

Any Ideas anyone?

Thanks ahead of time.

Old

May 31st, 2006, 08:22 AM

stepdev

stepdev is offline

Authorized User

Join Date: Mar 2006

Posts: 21

Thanks: 0

Thanked 0 Times in 0 Posts

Default

This seems to work for me.

Dim XUID As Integer

XUID = InputBox(Prompt:="UserID requested?")

"SELECT * FROM XDBASE WHERE UserID = '" & XUID & "'"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with SQL Statement	forumsUID	SQL Server 2000	1	August 23rd, 2007 08:08 AM
convert a SQL Statement from MS Access to a SQL	Corey	Access	6	March 28th, 2007 12:33 PM
SQL Statement???	carswelljr	SQL Server 2000	2	August 25th, 2006 12:40 PM
SQL Statement help	johnman	Access	1	October 22nd, 2004 10:20 AM
sql statement	[email protected]	Beginning VB 6	2	June 23rd, 2003 04:28 PM