I need to display a set of columns beginning with a certain date.
ex. Enter Start date: 052020
ex: Name 052020 062020 072020 082020 092020 ....
In a vb Program I build a SQL statement and create a query.
Works Great:
Set qdf = CurrentDb.CreateQueryDef("DisplayMARS", msqlMARS)
DoCmd.OpenQuery qdf.Name
Problem is, now I need conditional formatting so that entries < 0 are highlighted. Apparently, I can't do that in a query so I built a datasheet form with conditional formatting that displays the query.
... But I can't build the form in vb script, can I?
How can I get the form to start at the date where I need it?