Recent content by MD12

Hi Gary...thanks a lot for the advice. I manage to use nested If to identify which needs conversion but I m stuck for days on how I can make it propose the required amount to convert in sequence ie buy jpy sell chf and then buy remaining jpy sell gbp. Aim is to do mass run for multiple customers...

Sorry the tables didnt come out correct in my previous post Cash table: CustID ! AUD ! CHF ! EUR ! USD ! Cust A ! 1000 ! 0 ! 0 ! 1000 ! Cust B ! 0 ! 1000 ! 1000 ! 0 ! Payment Table: CustID ! USD ! Cust A ! -1500 ! Cust B ! -1600 ! FX Rate Table: AUD ! 0.73413 ! CHF ! 1.05435 ! EUR ...

Hi Gary Thanks for the suggestions. it doesnt always have to be transfering USD. I may need to transfer EUR at times I can figure out the logic for if there is sufficient USD, no FX conversion required but i cannot figure out how to tell the query to first wipe out my CHF and if CHF is not...

Hi.. I trying to use Access to create FX conversion but do not really know where to start and what method to embark on. I will be grateful if anyone has any suggestion for me. I have a table with customer ID, different currency holdings ie AUD, CHF, EUR and USD but not all customer ID has the...

Thanks JHB. I manage to show the subform properties with the Beforeupdate field by using the wizard to create the subform instead of creating directly a sub form within the form.

Hi. can anyone advise how I can convert a subform that has on enter and on exit properties to one that is show Beforeupdate properties. Am very new to access and I am trying to add an audit trail to a subform. Thanks

Hi all. I am very new to access and I need quite abit of help here. I have 2 tables (Table 1 = Quicksearch and Table 2 = Positions) Table 1 (Quicksearch) Customer(Text)__ ID1(Text)____% P(Number) S11111_________01111-000___ 1 S22222_________02222-000___ 0.5 Table 2 (Positions) Customer(Text)__...

Thanks everyone. it's working fine for me now after following your codes!

of the 3 records. say I wish to click on the row with WorkID 2 and show up in a second form that I have with WorkID 2 details. it keeps showing the details of WorkID 1 whenever I double click on either WorkID 2 or 3

Hi..i am new to this forum and access and I recently encountered a double click issue My form loads perfectly on double click event but it shows the first record instead of selected record. My search is based on a PersonID but each PersonID has different WorkID that I wish to display on double...