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