Search results

The code when you click Last 30 days is: Private Sub btnMonth_Click() 'Sets the Date From and Date To text boxes 'to show the last 30 days Me!StartDate = Date Me!EndDate = DateAdd("M", -1, Me!StartDate) End Sub

Hi everyone In my database when I want to view a report, I go to the search form where I can input the date criteria. When I choose to view the last 30 days of the records, I get the following error: Reserved error (I); there is no message for this error Any idea what it might be and a way to...

You're the man Arnel. Thank you for the sample. Was searching for this but couldn't find any. Will give it a try

One more question Say I want to email the report as pdf. I add a button and under on click, I set the procedure as Macro Builder. Using the EmailDatabaseObject command, can I include the date of that record in the subject line? e.g. the subject is "Ninja Report for Date: " and then add the...

lol yeah. Small mistake.

nevermind... I found the problem. The "ID = " & DMax("id", "theTableName") was in the filter clause and not the where condition of my VBA. Thank you, Arnel. Your code works

Don't know what I'm doing wrong but it still shows all the records instead of one. I've set the cycle option in my reports properties to 'Current Record' instead of 'All Records'

I have auto number in the table yes but the form is unbound. If I follow your method, it shows all the records instead of the specific one I saved

Hi everyone Need help with something... I have an unbound form that saves records. What I want to know is if it's possible to be able to directly view the record in a report once I've clicked save? The reason for this is because I do daily reports and my database helps keep records should my...