There is one technique I used which gets around this issue quite well if all else fails, but is a bit of a pain to set up and maintain -- What you do is turn the select query you have into an append query, and save the record IDs only into a temp table.You can do this as part of a form open event (from memory - might need to use the me.requery) or better yet as part of code from the menu/button that got you to the form.
I immediately transferred to DBMI where I obtained the skills necessary to integrate my technology expertise with Medical Decision Making and Diagnostic Errors in Medicine. Crowley was instrumental in planting the seed of the importance of the cognitive aspects of medical decision making.
Personal Statement Turning to DBMI, one of the top tier programs in the country, to obtain my Masters in Biomedical Informatics was a natural transition for me since I was already in Pittsburgh having just obtained my MD at Pitt’s School of Medicine.
These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
I have read that MS Access 2010 supports the SQL date field, so I upgraded but I am still seeing the same issue.