Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries & Forms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Queries & Forms
Resolved · Low Priority · Version 2003
Reply Wed 29 Oct 2008, 16:05Delegate Kristin said...
Kristin has attended:
Access Advanced course
Access VBA course
Queries & Forms
How to create a subquery, e.g, if you have 2 tables linking 1-to-m and you only want to show the latest date for each record, how would you go about in a systematic and simple way of creating these sub or embedded queries. (Example: SELECT Alias1.PSAID, Alias1.[Condition Assessment Date], Alias1.[Condition Assessment Description]
FROM [Condition Assessment] AS Alias1
WHERE (((Alias1.[Condition Assessment Date])=(SELECT MAX([Condition Assessment Date])
FROM [Condition Assessment] Alias2
WHERE Alias2.PSAID= Alias1.PSAID))); )
Forms:
I've had a problem where an "unassociate" label on a form causes the form to flicker. Is this a bug in Access and can it be solved?
For upcoming training course dates see: Pricing & availability
RE: Queries & Forms
Dear Kristin
Thank you for attending Access Advanced course!! I hope you enjoyed the course and benefited from it.
I would appreciate it if you could clarify your example a bit more in detail. Are you saying that a field that has date/time and has a lot of dates and you wanted to get results of the last transaction for particular items?
A possible solution to this could be Parameter Queries!! But I need further clarification on the example before I can give you any suggestion.
With regards to the flickering of the form using unattached label is common in MS Access 2003. There are two possible solutions to this!!
First simply convert your label to a text box and that should solve the problem.
The other solution is applicable if you are the only one using the form. This is to do with the Windows XP display settings! Simply right-click your Windows XP desktop, choosing Properties, and setting the Theme to "Windows Classic"
One of the above solutions should be able to get rid of the flickering.
If it doesn't then we need to resolve it more technically by VBA codes!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Reply Mon 2 Feb 2009, 12:40Delegate Kristin said...
RE: Queries & Forms
Thanks Rajeev.
Think that answers my question about the label and flickering problem. The first question had to do with embedded queries, but I think I understand that now better, thanks.
|