Search results

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

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...

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

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...

Hi, I have just finished a script that prints out a report for my company. However, my boss wants me to design the report in the "standard" reporting format for my company. I have never designed my own report, and I am using Access 2002, can't seem to find any good tutorial/guide to design it...

Hi, I am having some trouble with an iif statement as selecting the field.. I have two columns, one called [sdCounterpartyprice] and one called [bid] I want to select the [bid] if it's not equal to Null or 0, if it is equal to that then pick [sdCounterpartyprice] this doesn't work CptyPrice...

Hi there! I am working with some unions that I have a question. I have 5 queries that I would like to union, 2 of these are missing one column. That way they can not be unioned, my question is if there is a way to "cheat" through this? Making a short example here.. 3 queries have...

Hi! I am having some trouble with a program that contains a query that is suppose to sum a bunch of market values that have the same ID and is from the same portfolio. The problem I had at first was that some of these IDs and portfolios that should have been summed together had one called...

Hi there! I am currently working on my iif weekday function in a make table query. What I want it do is that if its monday take date()-3, else date()-1. I cant get it to work.. DateAdd("d", IIf(Weekday([upload_date]) = 2, -3, -1) I tried this, wont work..

Hi there! I have a query showing duplicates, I want to hide the duplicates that have a null value in one of the rows.. Trunc_Name M_UNDERLYIN MaturityDate Duration SumOfSumOfM_VEGA Volatility SPX P1400 DEC13 INX 21-dec-13 4,766666667 -108 812,00...

Hi there! I am having some trouble with a weekday function or something else that might help me pick a proper date as a parameter. I want to build a function that picks yesterdays date if it's tuesday-friday, but on mondays I want it to pick the date from friday. OR if this might be...

Hi there! :) I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks. When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output! :)...

Hi there! I dont really know where to post this, but im thinkin this could be fixed in a report, if not, I am sorry for posting in the wrong section :) but I got this column representing the maturity sens_test_nameEUR, maturity 0.002739726EUR, maturity 0.083333333EUR, maturity...

Hi! I am trying to select a few values for my report, can this be done in the report design view or do I have to make a query and take from that? I am using access 02! Pre-thanks! EDIT: I want to leave out all the values that are 0!

Hi! I'm having an issue with my query that I can't even figure out where to start with! Here is an example how my tables looks like. dbo.Murex [Instrument] [Duration] [Volatily] OMX2 4 0.18 OMX3 9 0.17 CMD1 2 0.16 NAS1 5 0.14 and a second table dbo.DurationLength...

Hi there! I am having some trouble with a query, I'm gonna try to put this out as good as possible :) I have linked two tables together in a query. Each row in the column [Trunc_Name] is so suppose to be unique, but my query put out dublicates for some Trunc_Name's. Almost all duplicates(that...

Is there a way to make a function/query anything that can copy over to excel? I mean update a sheet in excel or something like that? :) Thank you!

Hi! I would like to know how to make the abs function show if the abs value is negative or positive. Right now it automatically switches from negative to positive, I want to see if the abs value is negative.