Recent content by firestorm998

I've got as far as the below basic code to send an email from my DB but am struggling to figure out how to define/add/use the filepath of a PDF doc that I store in a field called 'DOCS1' so that it can add it as the attachement to the email: Private Sub Command18_Click() Dim strEmail As String...

I've created a series of reports containing charts and table sub report. If you picture a landscape page divided into quarters, top left I have a pie chart, top right I have a 3 column table sub report, bottom left I have a pie chart and bottom right quarter is blank. While the table sub report...

i'm using the following expression in an Append query and have recently had to had another IIF for a new product type in the 'Product Type' field. Base Gross Notional-Short: IIf([long/short]<>"Long",IIf([contract sizeb]="Equity (Incl Options)",([gross equity exposure]),IIf([product...

I've been running an append query for some time now with a field using the below expression successfully. Gross Base Equity Notional-Short: IIf([Long/Short]="Short",IIf([Product Type]="OTCEquityOption",Abs([Delta Position Value USD]),IIf([Product Type]="ETOEquity",Abs([Delta Position Value...

Thanks for the responses folks. I'm not too familiar with Functions but iIve created one and when I enter the control source of a label (i set up just to test) on a form I can use the expression builder to locate the function & select it. My control source then reads...

I'm currently using the (Date()-1) function in various fields on a report which is generated each day usining prior day data. By process of elimination I've come up with the below control source formula to try and account for Weekdays as when the report is run on a Monday it needs to be dated...

Thanks guys that works great, just need to get the file to open automatically once the export has finished...??

Thanks for the quick comeback! my example was a bit simplistic, I actually have many reports in the listbox which can grow each day. Looking at this code, if i understand it corrrectly I'd have to write a new 'Case IS' for each and every option which would be a bit of a drag. I was hoping...

OK so I can figure out the basic export to Excel macro in access and have found some examples of transferspreadsheet macro's but none where the table/query souce is not pre-determined. I have ListboxA showing a list of reports, 'Report A', 'Report B' etc. I have a button which I am trying to...

Indeed it has.

Re: Query OUtput Gibberish! Thanks for the response. Wasn't too sure where the post lay so hedged my bets in both forums. When i format in excel I don't actually get the option of a type of number(integer,single,double etc) as in Access, just decimals,seprator etc. Within the DB i need to use...

This sounds like an age old issue on here that can be fixed in part but haven't yet found a full solution: I have a DB based on a linked excel table which updates daily. Having got half way through the development of a DB I now find that the format of numbers in the Excel spreadheet is giving...

I had the following IIF statement as the control source for a Form text box: =IIf([CASH RATE]="TBC","TBC",IIf([EVENT TYPE]="Rights Issue",[Stk Ent 1b]*[Cash Rate],[POsition1]*[Cash Rate]*(1-[Tax rate]/100))) this worked fine. I am trying to nest the following(which works fine...

okay, so got the hang of the subform filtered by a combox concept. I've placed a datasheet view of a table as a subform on a main form and can filter the datasheet by the field CCY included in both the mainform/subform. Change to "USD" shows me all records in the data sheet for "USD" as...

Tried that Dennisk but getting same 'Update of Cancelupdate without Addnew or Edit' error.