Search results

Still stuck on this - anyone able to make a suggestion?

The indexes already exist on the middleman table (tblFinanceYear) which is the link table but if I simply go to the YearNameID and make it unique then it only allows one Year in the whole database... If i try and add another year with the same name to either the same project or a different one...

Thanks Pat - but with my structure... tblProject - Primary Key ProjectID tblFinanceYear - Primary Key FinanceYearID & Foreign Keys ProjectID & YearNameID tblYear - Primary Key YearNameID Where do I put these indexes? :confused:

Hi, I have a database that has a table for Project data (tblProject) which is linked via a foreign key ProjectID to a table for financial years (tblFinanceYear) which is in turn linked to a table for Year (tblYear) through a foreign key YearNameID. There must be a way of doing this but cannot...

Great thank you :-)

because i couldn't get my forms working correctly when they were linked... so this workaround has so far until this point worked for everything else i needed... So when i close down this data entry form the other form is open behind I have tried setting the focus to the parent form...

Cannot believe it was that simple :-D Because I wanted to enter data I assumed I'd need that as Yes??? Bizarre!! Can I also quickly ask how I refresh/requery the subform which is based on query when I've added new years or amended data in existing years?

Thanks for your help - if I can be cheeky while i know you are online you commented on a related post of mine http://www.access-programmers.co.uk/forums/showthread.php?t=228968&page=2 I'm still really stuck and can't get this working... :-(

Why do I need to? This code is only when a form loads and there is no field on this new form that would trigger an update of these fields... Or have I missed something :confused:

By the way, what happens when you open the form on it's own, without any criteria? It just opens in add mode with all fields blank Do you have the Data Entry property set to Yes? Yes Do you have any other criteria in the record source of the form that you're opening? No - just the code below...

Ok think I've pieced it together This may not be the best code but it works! Private Sub Form_Current() Dim intProjectID As Integer Dim intCurrencyID As Integer Dim strExchangeRate As String strExchangeRate = Forms![frmprojectmaster]!sfrData!txtExchangeRateUsed...

Still stuck on this - no progress over the weekend - any ideas anyone? Thanks so much for your help

Hi - sorry I'm confused :confused: I've got this code but it errors saying it cannot find the field named frmprojectmaster... it's nto a field its a form... Private Sub Form_Current() Me.txtExchangeRateUsed = Form!frmprojectmaster!frmprojectfinance!txtExchangeRateUsed End Sub

Ok - see attached a new mini database (and in 2003 version) which replicates the same problems I'm having! Hopefully this helps? Thanks everyone for your help and patience!

Hi - no just that they are not currently pulling through... All my forms are open... the following hierarchy 1) Master Form (fromProjectMaster) which has an embedded subform that displays different subforms based on button clicks 2) the above embedded subform of interest (frmProjectFinance)...

Sorry John - there is just no way I can remove everything to clear it of identifying info... not without re-writing it... Is there anything else I can provide that can help you help me?

Hi Bob, Thanks for taking the time to reply... you may guess that I've neever used openargs before and also have kind of adapted code I've found on the web to get to where I am... Now realising multiple items in open args is a no no - I looked and found this but don't know if this is what you...

Great thanks for your help! :-)

This tells me that I have the wrong number of arguments... ??? And any idea what code I would need to use to test for 0 and then exit? Sorry for being a pain... :(

Hi - thanks for trying to help me! I'm definitely a VBA newbie... If I understand correctly you are suggesting me take the IIf statement back out and just call the function? Would that work? And then somehow trap the overflow in the function... I have to admit to not understanding how to do...