Dim strValDates As Recordset Set strValDates = CurrentDb.OpenRecordset("SELECT TrainingDate FROM tbl_TEMP_TrainingDates WHERE TrainingDate = '" & _ Me.TrainingCal & "'") '**************************** ''ve tried the above code a dozen different ways '--Surrounding the Me.TrainingCal with single quotes, "#" signs, both single quotes And "#" signs '--Creating a Date variable and then assigned the TrainingCal value to this variable and then using that variable within the recordset. '--Created a String variable and set it to the TrainingCal value '--Tried using the CDate function to force the value to be a date
|Open CSV, modify and save as xls from Access||12||19|
|Syntax error [Missing Operator] in query expression||7||33|
|How to use vba code to toggle a text box in access between plain text and rich text or make the output view look like the plain text view where the data is not all lumped together?||3||14|
|Access 2016 - finding skipped numbers||11||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!