SQL Help - Access03 (asp/vbscript)

Aug 16, 2007

I'm getting the "Too few parameters. Expected 1." error with this. I've checked numerous websites (as I seem to get this often) including Microsoft's support site. Doesn't help in the least.

Can someone explain this to me, please? I have this query generated in Access, so the table and the fields I'm getting exist (which seems to be what MS wants to tell me is the problem, that they don't exist...).

Here is the SQL string:

Code:SELECT emp_username, tests FROM empInfo WHERE emp_username = " & yUsername

It does not like WHERE and after. yUsername outputs a value (i've checked it) and I've even hard coded the value into the query string and it doesn't like it. Am I doing something wrong?

View Replies


ADVERTISEMENT

Locked Forms - Access03

Nov 28, 2005

My company just upgraded from A97 to A03 (Multi User). In A97 there were only rare instances when I could not change forms in design view while other users were in the same database, now it seems in A03 I am not able to change anything, anytime on a form (and other objects I am sure) except when all users are out of the database.
Has A03 changed this drastically? It seem that if it has it has only made life harder for us (b**ch Moan, b**ch Moan)
Just checking to see if I'm missing something here.

Thanks

View 5 Replies View Related

Help With VBScript

Oct 9, 2005

In Script Editors of DAPs, I try to call a form for use :

<SCRIPT language=vbscript event=onafterupdate for=Style_Name>
<!--
Dim objAccess
Dim objForm
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "andre.mdb"
objAccess.DoCmd.OpenForm "Showlists"

-->
</SCRIPT>

When I run it, it shows the warning "ActiveX can't craete object "Access.Application"
What's wrong with the code, and how should I get it done ?

thanks

View 2 Replies View Related

Another Vbscript - Afterupdate

Sep 28, 2004

I have a form with shipper information (5 fields) and a separate form/table of shippers. I want the ability to either enter shippers on the fly (one time shippers) or the option of picking a shipper from the shipper form/table and having it populate the 5 fields.

This is what I have and it works.



Private Sub FrgnShipCombo_AfterUpdate()

Me.FrgnShipName = Me.FrgnShipCombo.Column(1)

End Sub



Im looking for the how to use this method on multiple fields



Private Sub FrgnShipCombo_AfterUpdate()

Me.FrgnShipName = Me.FrgnShipCombo.Column(1)

Me.FrgnShipAddr1 = Me.FrgnShipCombo.Column(2)

Me.FrgnShipAddr2 = Me.FrgnShipCombo.Column(3)

Me.FrgnShipAddr3 = Me.FrgnShipCombo.Column(4)

Me.FrgnShipTeleNbr = Me.FrgnShipCombo.Column(5)

End Sub

View 1 Replies View Related

Calling A VBScript In A Directory

Oct 21, 2006

Hello, I have a VBScript that when clicked on opens the command prompt and fires code to upload a query to my website.

What I would like to do is place a command button on my form that will call the script to run instead of having to go and click on it.

I have searched, maybe using wrong terms, but havent been able to get the right code to do this

any help to call this script from a command button would be appreciated.

View 2 Replies View Related

Microsoft VBScript Compilation (0x800A03EA) - Syntax Error

Aug 20, 2004


Hi i am trying to select records from a database using the following syntax, before i put in the order by part it works no problem, can anyone see my problem? thanks

SQL = "Select * FROM MainTable WHERE Company LIKE '" & ("%") & request("Company") & ("%") &"' AND Device LIKE '" & ("%") & request("Part") & ("%") &"' AND Division LIKE '" & ("%") & request("Strategy") & ("%") &"' ORDER BY '" & ("%") & request("orderby") & ("%") &'" ASC"
set RS = dbconn.execute(SQL)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved