Turn combo box w/ two columns to 2 combos

[shariq1989]

Well maybe here is something you could help me with...

I wrote up a query to pull just the latest record for each VesselInspection and it works. The problem is that when I add the dateadd function to that query, its like the max function is nonexistant all of the sudden. I ended up using "Last" instead of "Group by" and that seemed to work but does that look like a good solution that wont mess other things up for me?

[pbaldy]

Hard to say without seeing the SQL. Last generally doesn't do what people think it will, and I never use it. I can't imagine it being used in place of the GROUP BY on vessel. I would expect that query to be used just to get the latest record, and any further calculations being done in other queries or on forms/reports.

[shariq1989]

SELECT Max(TblInspectionHistory.DateCompleted) AS MaxOfDateCompleted, TblInspectionHistory.VesselInspectionID, TblVesselInspections.InspectionID, Last(DateAdd("m",[InspectionInterval],[DateCompleted])) AS DueDate, TblVesselInspections.vesselid, TblInspections.InspectionName, TblVessels.VesselName
FROM TblVessels INNER JOIN (TblInspections INNER JOIN (TblVesselInspections INNER JOIN TblInspectionHistory ON TblVesselInspections.VesselInspectionID = TblInspectionHistory.VesselInspectionID) ON TblInspections.InspectionID = TblVesselInspections.InspectionID) ON TblVessels.VesselID = TblVesselInspections.VesselID
GROUP BY TblInspectionHistory.VesselInspectionID, TblVesselInspections.InspectionID, TblVesselInspections.vesselid, TblInspections.InspectionName, TblVessels.VesselName;

[pbaldy]

If you go back to my link, you'll see the first query does nothing but get the last inspection date for each vessel. You then join that query to another to get the other data. You're trying to do it all in one.

[shariq1989]

Got it! Thanks!

[shariq1989]

Do you spend more time on this forum?

[pbaldy]

I generally visit both, but I'm a moderator here.

[shariq1989]

Oh, ok. I was just trying to decide which forum it would be better to pursue the problem on. I posted the db on in the other forum though.

[ssanfu]

Instead of a switchboard, I incorporate the button menu with the main data form. here are two examples:
(Two main forms)
Attachment 8367

Attachment 8368


I also use different colored backgrounds forms. Headers are usually white. The detail section might be a light orange and a subform very pale orange. Data entry forms might be shades of blue. A payment screen might be green. Forms where you can do a lot of damage (deletes) would be red.
This seems to make you aware faster if you are on the wrong page. The colors usually are specified by the client.

Button placement changes - only a few buttons or wide text labels can be along the bottom. Lots of buttons (short text) I put vertically.

I also sometimes make my own buttons because I want different colored buttons. Just a label with some code. Works great!

(Had to show the bottom pic in design view - didn't have the BE )