Search results

the lost focus event.

I have tried that, but it does not seem to work. Thank you dfuas

Hi eveybody, I have 10 fields in a form where I put in years. is it possible that if the first year is filled in as 2006 (for example) that the next nine years fill up automatically as 2007, 2008, ......etc. How would I do it? Thanks dfuas

I have change it to single. It displays fine but without the % simbol and if I select the Percent format still being multiplied by 100. thanks dfuas

Hi, How can format proper display for percentage values. What happens is I chose a field as percent, but if I put in 9 meaning 9 % I get 900% as the value is multiplied by 100, but if I put in 0.09 I get 0%. I just want to put in day 9 and be saved as 9%. thanks dfuas

thank you. I will work on that.

Thanks. Never done that, how will that work and how will I go about doing it? dfuas

Hi everyone, I have a relationship between Market data table and Trade table which is One to Many. Market on the One and Trade on the Many. However I just found out that I am unable to enter information into the Trade Form without entering information into the Market Form first. I would like to...

Hi, I am quite new with designing reports. Is there a way of grouping a report based o n 3 separate dates? For example I have somebody who owes me money and will be paid in 3 different installments (i.e 1st on 17.Jan 06, 2nd on 15th May and last on 5 July) So I want the report to show under...

Sorted, thanks a lot.

I tried that, but the problem is that I cannot add more than one record with the MarketDate as the PK. Sorry but I could have zero or many set of trade data for a specific day. These are referenced by the RefNo autonumber. dfuas

So you mean that I could come back say a week later and input the Trade date into that table? dfuas

From my perspective you want Market/Trade comparison data on a daily basis. There will be one set of market data for a specific day. There will be zero or one set of trade data for a specific day Ok, these statements are true. How would I achieve this in one table? I see what you mean but...

In the Trade Table I could have any entry depending of the day of that trade, so the date is entered manually. I could enter yesterday info. and enter yesterday date. The Market table Market Date is for the market information of the day. So from a trade date you can see what the market xchange...

Ok, I can see existing entries and I can update them, but if I try to enter new values (records say by mistake, although I should not in reality), I get errors because of the relationship and it messes up and then I cannot see again the existing entries, until I go to form design and change the...

That exacly what I have at the mom. There is only 1 entry on a specific day on the Market Date, but when I try to update or change the values in there, first they don't show on the form I use to enter the data and so I can't update them. If I try to enter a new data I get a error but that should...

the MarketDate (on table2) as date ( ) is entered only once per day. The TradeDate (on the table1) with RefNo as PK is entered manually on any day. So you may have MarketDate (as this is daily) without TradeDate as there was no Trading on that MarketDate. Thanks dfuas

Hi, I have a db with two table. Table1 Trade has the following among other fields: RefNo (autoNo) PK, TradeDate, HostName, Methodology, etc. Table2 Market has the following among other fields: MarketDate as Date ( ), USD/EUR_Rate, USD/CHF_Rate, USD/BRL_Rate, etc. I need to link both tables so...

thanks a lot. dfuas

Hi, Strange but true. I am trying to numeric data types on my access 2000 where I could input values in table like 0.3567 or 2.3454 Anyway any values of this kind with 4 decimal places. however somehow the values always get rounded to number + 4 zeros as of example: if I put 0.756769 I want it...