Code:
strSQL = "SELECT [COMPUTER] FROM tblSOFTWARE WHERE [KEY] = '" & cdkey & "'"
Thank you so much for the help.
dtsmith1984
Last Activity: Mar 14 '08, 10:02 PM
Joined: Nov 9 '07
Location:
-
Yes i was just about to post up here that i figured it out.. This is what i used.
Thank you so much for the help. -
Ok, I now have this. Still getting "Too Few Parameters: Expected 1"
...Code:Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Dim newassignment As String Dim oldassignment As String Dim cdkey As String Dim strTestQuery As String Dim strSQL As String strTestQuery = "qryTEST" newassignment = Me.cbonewassignment.Value oldassignment
Leave a comment:
-
Still receive the same error. Its the OpenRecordset line that gives me the error.
For some reason it's not getting the parameter from the form. If the form is open and filled out and i manually open the query it shows the results properly, if the form is not open the query will pop up and ask me for the value of the cdkey from the form. I just cannot figure out why it's not able to see the value from the form when i run this with a button...Leave a comment:
-
Problems using OpenRecordSet with a prebuilt query
I have a form that i want to be able to reassign a specific piece of software to a different machine.
Form specs:
Software Title: cbotitle
CDKEY: cbocdkey
Old Assignment: cbooldassignmen t
New Assignment: cbonewassignmen t
I've built a query that pulls a list of all the computers the software is currently assigned to dynamically by gettings its criteria from the current form.
...
No activity results to display
Leave a comment: