Recent content by lupins46

To develop a 'filter-by-form' equivalent would be a major undertaking. If you can cut down your filtering to two or three fields you could build a SQL Select statement in code and use that as your recordsource (or build a filter stament on code and apply that). Or you could use a parameter...

Filter by Form is not available in Access runtime.

When you added you subform to your main form the wizard would have asked you for these fields.

Are both subforms linked to the mainform through Master/Child links? (Just fumbling in the dark!)

Don't even try. Provide the user with separate texboxes for firstname and lastname and then, if you must, join the entries together to give you the format you want. But I can't imagine that you really want to store the name in this way. It would make searching unnecessarily complicated.

What do you mean by ' lets call it 'recon#' In what sense does a record have a name? It would always be 'the row that is selected' as there is always a row selected (assuming a row exists) And you want to copy it where? to the clipboard?

Run this sub to enter ther records. Make sure you use your own table and field names. Sub EnterDates() Dim dt As Date Dim db As Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tablename", dbOpenDynaset) For dt = #1/1/2004# To #12/31/2010# rs.AddNew...

Splitting the table does not help you avoid any size limits. So put the items back into the same table and make life easy.

So how do you identify 'most recent'?

DMax("idfieldname","tablename")

No. Code has to run to requery the rowsource of the second drop down. Therefore you can't do it in a query.

gee whizz - is this the ESP forum(:-)

ACcess does not have an 'Activedocument'. Use Application instead.

Asking the user to enter month/year in a parameter prompt is inviting problems. If you need to do this then you should use a form to capture the month - maybe use a drop down list to let the user pick from it.

Can't reproduce the problem here. Which version of Access?