Search results for query: *

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?

'To be qualified on 747 Employee must have completed ENG, AVI, and FAM.' Something like this... SELECT EmpID, Sum(Abs([Type]='Eng')) AS Qeng, Sum(Abs([type]='avi')) AS qavi, Sum(Abs([type]='fam')) AS qfam FROM [mytablenamehere] where fleet = 747 GROUP BY EmpId HAVING...

Create separate queries for each qualification. Each query should contain the same fields in the result, plus an extra column to indicate the qualification such as ... Qual:747 Once you have created the individual queries go into the SQL view of a new query and enter: Select * from qry727...

You can display a progress bar, but it won't show anything. You have to write code to set the position of the bar.

Go into the properties of the subform and set the DefaultView property.

SElect * from tbalA left join (Select tblB.* from tblB inner join (select BId, Max(BDate) as mdate group by BId) as q1 On tblB.BId = Q1.BId and tblB.Badate = q1.mdate) as q2 On tblA.Aid = Q2.Aref YOu have to find the max date for each Id, then get the record containing that value and then join...