Search results for query: *

I can not figure why i keep getting a type miss match on line 3 Set rstClone = frm.RecordsetClone isn't frm.RecordsetClone a match with ADODB.Recordset?? Thanks for any help.... this is how im calling the modual ..from the on current event with "=DisableEnable([Form])" Public Function...

Each Clients Min And MAx yes

yes that is what i wanted to know, but is there a way to also put the sort into the same query so that it would sort by the clientID?? thanks for your help...

I have a query that pulles information about activities that occured at different times on one day. So i made it sort Assending by the time/date field and it is sorted correctly. Now i need to retrieve the First record and the last record from the query from the date/time filed. I tried using...

Thanks guys I solved the problem....I just needed to dig a little more in this big open space between my ears...:)

Thanks for your quick responce. What you suggest would not work as i needed. because i need the user to be able to enter the date on the form and change the date to update the subform. you can see an example of the form at http://www.dbxtreme.com/example.gif the field circled needs to be...

I need to add an expression to a query that would allow the user to input a date on the form. right now all i have is "InputDate:Date()" that just gives me a non editable date field with todays date. I have tried other ways but the expression becomes either a binary or text filed and cant be...

Thanks for the quick response. Let me see if i understand things correctly jrbarnett if i use a sub form am i correct that an instructor will have to use the record navigation buttons to go through the students in their class? I have tried that but i need an interface that is simple. like a...

I work at a school and we are trying to develop a way for an instructor to enter attendance directly into a access form. We have 2 tables that relate to this problem tblClients ------------------------ SocialSecurityNumber ---PK FirstName LastName InstructorID ---FK to tblInstructors...