Search results

IGNORE ME, i'm an idiot, i had a bit of debug code further up that i hadn't removed, sorry, it was there for me to use to remember the format of the adding to a dictionary and forgot to delete it :( ffs

Hi All As an example I have 2 master records with 6 and 2 child records respectively selected from a recordset and want to get the counts of master and child into a dictionary to use in calculations later: Set rs = Form.Recordset.Clone With rs .MoveFirst Do While Not...

@arnelgp brilliant, thank you, i have it working now using your examples, thank you so much.

@arnelgp ok so if i understand things the example doesn't use the sum function but loops through the record set and totals the values and writes that to the footer.... is that right, if so that makes sense and i can certainly take this approach with my form, never really thought about doing it...

@arnelgp downloading now and taking a look

@arnelgp i do have a table for the conversions, the lookups work and i get the right results based on dates and selected currency. the issue really isn't the creation of converted amounts its the totalling of said amounts

@theDBguy will try in the morning

will try, things a bit of a behemoth and split fe/be so not sure how to post it without ALOT of stressing on my part.............. but i'll take a look tomorrow

@bastanu no matter what i do i can't get the value of the selected currency from the form................ i'm wondering if i'm fundamentally missing something with this and its really starting to annoy me, i hate not knowing/understanding and just blindly trying different things over and...

i wanted to avoid creating fields in the query converting between source currency and all the possible currencies we have in case we add more but would a solution be: Calculate estimated and total amounts into currency 1,2,3 and 4 in 8 separate fields in the form query In the unbound have an...

yeah i just get #Error in all the footer fields if i do that i think its because there are lookups in the formula that calculates the converted currency amounts: =IIf(Nz([EstTotal],0)=0,0,IIf([currency_id]=[cboCurrencyToConvertTo],1,DLookUp("ex_rate_" &...

ok so i tried that previously but i'll try again, i think i got the same issue in that it just showed #Error, but gimme a mo and i'll try again

Hi All I have the following form: So far i have the form query supplying the columns of data up to the "Selected Currency" section. The 3 fields on the end (Currency indicator, estimated and actual amounts) are calculated based on the Currency selected on the drop down (it defaults to Euros...

found it HAZAAAAA!!!! ok so i see what to do now, not sure it helps because my table is a linked table but still at least i know where it was setup, goodness that was bugging me that i couldn't find where it was configured apologies for documenting my pain in real time

delving a bit deeper as i go, the fundamental bit i'm not getting is where "src_index" is set because i can see it is an index of the table, but i can't see where it is defined. i get what the line is doing now it is telling the recordset which index to use and when i look at the indexes it...

googling further, it does indeed seem you can't open a linked table as a dbOpenTable so seek won't work in this instance :( boooooooo i would still, if its ok, like to understand that .Index issue though for my own sanity

So i'm getting the following error: For this line: Set rs = CurrentDb.OpenRecordset("PricingSelling", dbOpenTable) which appears to be a crash of some description. The only difference between my setup and the example is the table i'm trying to open is a linked table and the table exists as...

oh hang on its the name for the index...... should have googled it first, sorry

@arnelgp i have a question about the database example you have given. in the code for the button there is the following line: .Index = "srch_index" i don't understand what this is doing here, can you explain what/where "srch_index" comes from please

@CJ_London indeed, i assumed there would be a better way but it worked so i'm up and running for now @arnelgp i will investigate your demo db and see what i need to do to get it working more efficiently using the database correctly and not via the vba i've used