Recent content by JonathanB64

I am using MS Access 2016 and need to create a dynamic form that displays data from my Sql Server data. My stored procedure is a dynamic pivot query so the columns will change. I am thinking of setting the form's recordset to a local MS Access table. The dynamic part is a form with two date...

Thanks that does work. I'll see if my client will accept that.

I need to disable data entry in a text field and only let the user pick a date using the date picker. This will ensure better quality control of the user selecting the correct date instead of trying to type it out.