Search results

I am exporting the PDF files and emailing them to report recipients.

I have a report in which I use vertical lines to separate values. However, there are data fields which need to grow, while others do not (some data fields require two lines while other only need one). Since that caused the lines to break where two rows were required, I added the code below to...

Ahh, thanks - that was my next question. Thanks again, this does now work as expected. Much appreciated!:)

See attached screen shot

The code is in a module.

So I need to return the last day of a field called [Period]. If the value of the field is #05/14/2018#, I want to return #05/31/2018#. I created the following public function; Public Function LastDayOfMonth(D As Date) As Date Dim LDOM As Date Dim NM As Date NM = DateAdd("m"...

Thanks - this was very helpful :)

I need to limit my query/report output to only include a 90-day date range of a field I call “Post-Date”. The ending date for that range is the last day of the month of a field I call “Period”. The first day of the date range is 90 days earlier then that date. The function below successfully...

Hello All ... just introducing myself. I am working in Philadelphia at an academic Health Center. I have been using MS Access for awhile now, but am just recently delving into VBA. Unfortunately, I do not have any colleagues in my immediate work environment who can help by mentoring me in...