Recent content by hillz2k

its ok dk - ive sorted the problem now - thanx for all your help......its people like you and pbaldy that makes these forums worth while

YEAY!!!!!!!!!!!!!!!!!! I GOT IT TO WORK Option Compare Database Dim db As DAO.Database 'variable to point to a database Dim rsquery As DAO.Recordset Private Sub Search_Button_Click() Set db = CurrentDb Dim vabQuery As String Dim qdfpara1 As QueryDef vabQuery = "qryfaultfinder" Set...

so i have..... Option Compare Database Dim db As DAO.Database 'variable to point to a database Dim rsquery As DAO.Recordset Private Sub Search_Button_Click() Set db = CurrentDb Dim vabQuery As String Dim qdfpara1 As QueryDef vabQuery = "qryfaultfinder" Set qdfpara1 = db.QueryDefs(vabQuery)...

well if i edit the query so that it just contains 1 parameter rtaher than 5 i can get it to work.....so now its just figuring out how to define the other 4

it isnt db the code is db....(something )..... i just didnt want to post what the name is on here - lets say its dbAccess and not db.....sorry for the confusion

pbaldy - that website you posted has an example of a recordset: Set rstCountOrders = qdfMyQuery.OpenRecordset() and it defines the: qdfMyQuery as querydef have i defined it wrong - should i have just ONE querydef and somehow add all 5 parameters to it or is having 5 querydef correct?? and...

sorry - i should have said it was access 2003

all of the [forms!][frmsearch]........ that i have as the parameters is also in the criteria sections of the query as this works opening normally - its just when it comes to the recordset you have to redefine all these....am i right pbaldy?

i do have the object library yes....i was expereincing problems before and found that to be the issue so thats solved - ill post the code better this time, including all the defining: Option Compare Database Dim db As DAO.Database 'variable to point to a database Dim rsaction As DAO.Recordset...

what i have so far is: Set para1 = db.QueryDefs(vabQuery) para1![Forms!frmsearch!product_type] = Forms![frmsearch]![Product_Type] Set para2 = db.QueryDefs(vabQuery) para2![Forms!frmsearch!range] = Forms![frmsearch]![Range] Set para3 = db.QueryDefs(vabQuery) para3![Forms!frmsearch!type] =...

qryactionfinder even

nope - qryactionfiner

pbaldy, thanx for that - i think ive got it defining the querydefs, but if i use: Set rsaction = db.OpenRecordset(vabQuery, dbOpenDynaset) after i 'set' the querydefs i still get the same error message. If i enter debug mode and hover over the querydefs the yellow help box appears showing...

dk, thats what i have in the criteria of the query. If i open the query normally it shows the data i require and works perfectly.....but when i try to open it as a recordset it knows it requires parameters but it doesnt use the ones embedded into the query it wants them redefined (i think...

Howdy folks, I hope someone can help me out of this little problem. I have a query that uses parameters from a form as its criteria. What I have to do is send action emails. I have the email generate set up and works fine but what i am trying to do is create a DAO.recordset (i know i should...