Search results

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

they (") are called speach marks when you refer to them in english and (') are just called quotation marks........probably could have refered to them as double quote marks, but not really a a programmer so i just know them as speach marks from english?!?!

fixed it...... me.keyword.properties("visible") = false forgot the good old speach marks

ok, ive tried all the things mentioned and no luck with any of them then :mad:.....but what I did try was to see if I could get the code to work on a form to make sure the code is vaid and i get the smae message. Therefore I ave come to the conclusion that there may be a problem with the code...

i have two bits of code.....the bit where im experiencing the problem is set to run onopen of the report. so you think if i set it to run on format it should work......cool....ill give that a try when i get back home and will post up again to keep you informed. Thanx for all your help, this...

i have the code working to move the text boxes depending on which button is pressed thats all working fine. The main problem is that there isnt a .visible=false feature avaliable in the vb code in a report, what i have noticed is that there is a properties function where you can alter the...