Search results

And I'm working in Access 2010 so it's a .accb file so will you need me to convert it back?

Errmmm.... I'll need to sanitise it as it's got lots of sensitive stuff in it... I'll do this and post it up in the next few hours... thanks for your help

Thanks I've changed to that and still get a blank form... :banghead: Don't understand... :confused::confused:

Not multiple years, no... But yes people type into a year field the year i.e. 2012.. Is that a faux pas?

Hi - Year is typed in as 2011,2012 etc and is currently a text field in the table (not sure if thats right or wrong...) There is a PrimaryKey in the table FinanceYearID which is an autonumber (long integer) I tried using that instead; DoCmd.OpenForm "frmProjectFinanceYearDetail", , ...

Thanks both - I've treied both ways and it gets rid of my syntax error and now opens the form but not for the record I want - just a blank form... I think I've followed the guidance pbaldy has in his link but can't get to the right record... Any ideas?

Ok this feels quite weird... I've played around with a calculated field on a subform and now I 'sometimes' get this error message... I changed my calculated field so that it is now =IIf([currencyid] Is Null,0,FormatNumber(ExchangeRate([Start Date],[CurrencyID]),10)) As previously if there...

Hi, I've seen a few posts around this subject but none seem to hit the spot I need.. I've seen pbaldy's link; http://www.baldyweb.com/wherecondition.htm And I'm trying to use it BUT... I need to pass two parameters in... Using the above link my code is DoCmd.OpenForm...

Hi, I'm trying to build something that started life as quite simple but now has grown and grown and grown... I have a form for projects and a subform form that holds finance details i.e. top level budget etc On this subform I have a button to open a detail sub-sub-form which shows the annual...

When I went back to look I looked and noticed that when i changed from currency to double I missed one currency reference... when I changed this it now appears to work so thought I share my working code... Thanks for your help everyone :-) My exchange rate function;

Thanks it was originally Currency but is now changed to Double and still displays as before...

Hi, I have an exchange rate field which is calculated to ten decimal places. This is looked up from a date field and a currency field via a select query which when I test that shows to 10 correct full decimal places. When I try and show this calculated exchange rate in my form it gives me 10...

Hi Simon - apologies for not coming back to you sooner - I never received a notification that someone had replied! I am trying to have three fields Date Currency Exchange Rate to Euro I will select a date for the date field i.e. 17/11/2011 I will select a currency from a combo box for...

Hi everyone - still not made any progress on this feature... if anyone could point me in the right direction - would be most grateful. Happy Christmas!!

Hi everyone - still cannot get this exchange rate thing to correctly look up - if anyone has any suggestions what I am doing wrong or should try any help would be much appreciated - many thanks :-)

Ok - I've tried to place my tables and current test form on your database to keep them together... My main challenges are; 1) having a date field and trying to look up a monthly exchange rate from a date i.e. looking up November 2011 euro exchnage rate from 14/11/2011 2) returning this...

Hi John - thanks for your response - I've been out of the country doing the'other part' of my job so just got back and have some time to look at this now... Just looking at what you have sent me and trying to work out how it works and how it could maybe help me...

Hi... I still could really do with some help I think I've sorted my data and got that imported I have fields for each currency name and then records for each month - I've changed this date to 01/01/10 etc but still am struggliong to get a query written to say pick up this record if my text box...

Hi, Not sure if this should be in here or in the query section as I don't really know where to start... I have A LOT of exchange rate data in excel each in a massive matrix per month but alot I could trim out as I'm only really interest in one row per month I have about 10 currencies then I...

Ok I've been a member of this forum for a while but as I'm not a programmer by trade the different jobs I've held have required different levels of use of Access - so I've not be very active for a while... I'm in the process of trying to get my company to ditch the very expensive Microsoft CRM...