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
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
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
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
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
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