Search results

Thank you! Sorry for late reply, I've been on vacay :) I am quite new to this and how it works.. So for this to run a macro called macro1 and VBA function "sendemail". How do I make that work? :P

Hi there, I have a report that I run manually from my computer every day. This report is created by a macro in microsoft access, then it runs a VBA macro to send it out.. Is there a way that I can add this as a schedueled task since I usually forget to send it out? :p Regards, C

Ohhh I am stupid! This works perfect, truly thankful!

Woho, this seems to be a script that I can definetly use! Thank you for this so much :) One thing tho, how do I setup the attachPath? :P Regards, Chris

A collegue of mine told me that it is what we should use for sending out the report.. My concern now is editing the title of the file instead.. Right now it's named after the query, I want to create my own name of the file as it's converted to pdf :D? Do you know if it is possible to this code...

Thank you for that, I'll see what I can do with it :) What about the saving part? :D / Regards C

Hi there, I am in need of a solution for sending out my report with a date variable.. I have two reports that are being generated through a macro. What I want to do is send out these reports as PDF-files with names like: Counterparty report as of =date() Counterparty 0 report as of =date()...

Hey.. I am not a great VBA writer, but I believe this easiest could be solved with VBA.. If it's not to hard for you mby someone can help me? :) I want a macro that sends out two reports with subject "Counterparty Price Report As Of =Date()" And I want the attatched report be sent out as a...

Thank you, but.. How will that affect the subject of the email? :P

Hi, I am using a EmailDatabaseObject to send out a report for my job. I want to add a date variable in the subject.. Is this possible? Like Report as of =date() 2nd. Question.. Can I attach two reports in the same mail? Best Regards, C

In your query, where the criteria box just enter "A" Or "B". If you use the 'like' operand you need to have a wildcard, such as like "%A" or "%B". and to make it easy for you, here's two example with like and just common where in sql-view. select * from mytable where yourcolumn = '%A%' or...

Here's what you can do instead. If your workbook is static(you will use the same workbook always to export your queries). Then you can link your queries to each sheet through excel to your access query, and update inside excel instead of importing from access. You can even create a macro in VBA...

"In need to feed a cell table with the value of the number of streets that are in "Type1" cyties" What does this mean? You want to make a query that selects all cities with type1? I don't understand the end-product you want.

Glad I could help, good luck! Regards, C

Hey sorry for late answer but I have been out of office. select fieldA from form1 union all select fieldA from form2 you have to write in the sql editor.

Hi, can you please explain a bit better? I don't completely understand what you want to do? But if you want to select certain values from two forms with the same columns and unite them, you can use union all and have a where statement for each form?

Great! I'll start trying out some vba coding :) Thanks for the help! ::D

At the moment I am just sending it out as an XLS report through mail.. But my company wanted storage of the report. I am using access 02! :) rgrds / C

Hi there, think I might be at the right section here even tho it touches the macro-part as well(I think). What I want to do is save a daily report to a map source, each day the map name changes so for today the map name is "Report2013-10-03", and tomorrow the map name will be...

Hi there, I want to sent out my report as a pdf file with my macro.. I've been trying to use the VBA Option Compare Database Sub Fix1() DoCmd.SendObject acSendReport, "MarketRiskControl_HighestDiffs_AsOfCurrentDate", "PDFFormat(*.pdf)", "my mail@mail", "cc", , "SD Counterparty Report as of...