Search results

Awesome, I learn something new everyday lol. I tried putting this code you gave me on both on current and onOpen as you stated and came up with in the onOpen portion. Could it be because I'm trying to base access on an accessID rather than a userID? That it's definitely too long and may...

[SOLVED--SEE BELOW TRAFFIC] I have a form in which only Users signed in with certian user access ID's can click on certian Command buttons on the form. Since there are 7 buttons on this one page, my if statements are growing very large. Does anyone know if there an easier/better way to...

[SOLVED--SEE BELOW TRAFFIC] I've created a report to list every record (1900 something total). This one main report is used to open my many querys (more than 50). In order to save myself from creating numerous reports I filter the records through my command button before opening the report...

I had same question, thanks for posting :)

Anyone know if there's a way to save all queried records with each as it's own individual pdfs instead of all merged into one?

I suppose I should have done this when I first registered lol. Short and sweet is I love to learn technical things. I don't have much of a memory so I learn mostly by cut & paste, but have gotten far with that and a little bit of common knowledge. I have managed access DB in the past, but...

I recieved help on this in another thread. Here's the code for anyone else looking for the same solution. Private Sub MailReports_Click() On Error GoTo Err_Email_Click Dim strReport As String Dim MyFilename As String Dim MyPath As String Dim ShowPdf As Boolean...

Ahhh! You are my new HERO!! I was going crazy trying to figure this out! lol Thank you so much! :) For others looking for my full code used here it is: Private Sub MailReports_Click() On Error GoTo Err_Email_Click Dim strReport As String Dim MyFilename As String Dim MyPath...

SOLVED--SEE BELOW TRAFFIC I was given the suggestion to save the report to desktop, then email that saved doc (pdf), then delete the saved doc. My reports open up using the same query that my form was run on. I'm assuming I need to somehow combine the two codes that I have for save and then...

I haven't figured out how to change the email attachment filename yet, however, I was given the idea that the report would have to be saved to the computer, then emailed from that location, then delete the saved file. Does anyone have VBA code that has succesfully pulled that off? If so please...

Funkbuqet: did you ever figure out if there was a way to specify the name of the outputted pdf file?

I have Access 2007 so I don't know if code would be much different, but thought it might help you (note my Record ID includes text): Private Sub Email_Click() On Error GoTo Err_Email_Click Dim strReport As String Dim stEmail As String Dim stSubject As String strReport...

SEE SOLUTION IN BELOW REPLIES: For the longest time I couldn't figure out how to save/e-mail a report based on a Query. After playing around with different options in the Embedded Macro section I figured out [OpenReport] in hidden window mode with the Filter Query inputted allows the...