Search results

Hi dears, the below code works as expected but unfortunately Outlook seems not to like too much... I explain better, the code is sending to a list (from a query) of email address an email. To each email it attaches a different file (a ratesheet) As long as the oMailitem has the command...

WOW Ranman, thank you so much! I am trying to understand how this works, but thanks truly a lot. It would have taken literally days for me to figure it out all by myself, and instead it works like a charm. Now I am trying to tell it that if the email field is empty it shall just skip it. I'll...

Hi to everyone! My little project with ratesheets (for those who helped already thanks alot again) is going on and now I am at the point where i need to send the files created as attachment. Basically, I have access create a series of pdf files that are ratesheets (reports) They get all saved...

all clear! Thanks a lot! :)

Thanks Minty! That worked (not clear to me why it worked, but stil....) Thanks a lot!

Hi Minty, yep, Comando2 is on the same form as Forms(Opnenewreportex).Controls(CasellaCombinata0) CasellaCombinata0 is a text Thanks! Ciao

Hi Minty, thanks a lot for your prompt reply! If i got it right i tried changing it as follows: Private Sub Comando2_Click() DoCmd.OpenReport "newreport", acViewPreview, , "[ragione sociale]= '" & Forms(Opnenewreportex).Controls(CasellaCombinata0) & "'" End Sub Still exatcly the very same...

Hi dears, I am about to throw the pc from the window, so hopefully someone will have pity of the this newbe of mine... The following in a standard VBA routine doesn't work I get a run-time 2465 Private Sub Comando2_Click() DoCmd.OpenReport "newreport", acViewPreview, , "[QQ_Retrieve nolo...

Dear Isskint, first of all thanks a lot. It works indeed, but I still have an issue: see, when Access creates and save the file : DoCmd.OpenReport repName, acViewPreview, , "[QQ_Retrieve nolo export]![ragione sociale] ='" & ingragsoc & "'" DoCmd.OutputTo acOutputReport, , acFormatPDF, fulpafi...

Hi to everyone! I ve already got help here on my project (thanks Paul!) and as a total newbe I need you help once again. Below here there is the code that generates about a 100 ratesheets for my customers. This works great. Basically I get all the pdf ratesheets Saved with the proper name...

Thanks Paul! A stupid "*" was hidden in the name of a Customer and made it all stop working! Thanks, this is solved!

Dear Paul, tnx a lot. I had eventually found sometime to look into it and indeed apparently are Always the same "Customer names" that produce the issue. I cannot figure out why though, any idea of what would be "dislikeable" to access? Meanwhile I ve check the code, i might have actually made...

@NauticalGent: I was born and I lived most of my life nearby Genova. I am in Bergamo now :) Ciao!

Hi everybody, hope you guys can help me. I am a total newbe with VBA so please be good to me :) My issue is: I have a db where I ve stored all the prices for my customers in one single table I create the rate sheet for every single customer pulling the data with a query into a report. The...

Hi to everyone, jsut wanted to say hallo. Hope I ll be of some help sometimes Ciao!