Recent content by donkey9972

This code works perfectly.

Thank you for the clarification.

Ok, so if I was to just click a button, to print preview the report on the 1st of the month, which way would be best to accomplish this?

I have my reports setup so I can view all the data for a single month in a report all the way up until the last day of the month. However , I still need to be able to view that data on the 1st of every month, but only the data from the previous month. I have no idea how to make that happen...

June7 I have 2 questions regarding the code you put on here. I have been playing around with the VBA with lots of help to see it work, but I was wondering, can this code be modified to allow a user to see the previous months entries on the 1st of every month? My 2nd question is why did you...

I had to look it over a few times, but eventually I understood this code. Thank you.

I found my mistake on it. You are right, this does exactly as was needed. Thank you.

Doesn't this still require the old file name to be put into the code? At least what I was reading in the link you provided that is what it seems to me.

I saw the filecopy but it requires a source file to be defined in the code. I am trying to find an option that takes the source file from whatever the user selects in the FileDialog method that appears in the textbox on the form.

Ok, I have half of my problem solved, I just have no idea how to incorporate the 2nd half. So using a simpletext box, and button I can use the filedialog to select a file which I have done, How do I take that file location that is now appearing in the text box and move that file to a specific...

Ok, so my location was wrong, that solved that problem. Thank you.

Yes, I am still working on that.

I even made sure the report had the table as the record source and I still received an error from where I am trying to get the total.

What I have on the report here.

I tried that, it is just saying #Error