Recent content by michellerobinso

i am racking my brain with this one. can anyone tell what is wrong with this. i have used many example seaches but when i incorporate them into my database there is somthing that doesnt like this code. please please please please please please help! Me.RecordsetClone.FindFirst "[RETURNID]...

thank you for your help on this. ive never used a query like this before so i apolpgise for my lack of knowlege. do i link this query to the frmquery now where the data will be viewed?

Me.RecordsetClone.FindFirst "[Number] = " & Me![QuickSearch] this code wont work and says there is a syntax error but i dont understand where it is going wrong if it works for yours?

i am using this code im rs As Object DoCmd.OpenForm "frmquery" Set rs = Forms!frmquery.Recordset.Clone ******rs.FindFirst "RETURNID = " & Me.QuickSearch Forms!frmquery.Bookmark = rs.Bookmark the line that i have put ********** wont open the form and i keep getting the error...

ok, one last thing, where does this code go????

i knew something wasnt right and didnt know what to do. i apriciate you help

yes i think your right. i must not be doing it right. could you please explain how to exctract the year and month using the () that you posted. when i have tried to do it the way i think it should be it wont have any of it!!. in my form i have used =DatePart("yyyy",[DATE]) to display the...

it has to be like this because the month and the year make up part of the ID. if i format it in the form, if you run a query, the field is blank. so i dont understand

in tblquery i have a field date. it its formated to =Date() i also have two more fields 1- month 2- year. what i want is to extract the month and year from the date field. but the thing is, i was it to be visiable when you are in the table "view". but i dont know how to format this.

can you post a sample of what you are working on?

thank you for butting in, this is what i want! many thanks for your help!

sounds like you need something like this

yes but for every new entry is assigns a new auto number. i want it to be able to list multiple entries for one return number

when i use that code i get the error message attached.

Here is a sample