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