Recent content by moddien

when i do this it jumps back to the first record...and that is what i dont want :-(

Hi guys, want to switch between several forms. To go to the specific record I use this code: Private Sub GoConfirmation_Click() Dim strwhere As String strwhere = "[MBS Ref] = """ & Me.[MBS Ref] & """" DoCmd.Close acForm, "Edit" DoCmd.OpenForm "Confirmation", acNormal, "", strwhere...

is already done in post 9 :)

is already done in post 9

I forgot to note that their must be the possibility to correct the calculated periods...thats why in table "data" are also periods listed...if they are is entered a date it has to use this period for the current_period.......gets to complex??????? sorry for that

what I need is based on the data table a new table or querry which gives me all period start dates for the duration (they are calculated based on the compounded periods the Start and endate in the "data" table) They (period starts and ends) have to be checked (as in "_Period Starts calc + Check...

hm..you mean years??? I have 2 month...must unfortunately be enough :-( ... But they are all saying...that vba isnt so difficult...I already recognized by myself that this is a true lie ;-)

Thank you very much for your help in advance...you will to me a great favour...i attached the mdb to write no novel ;-)... there you can see 4 querries mainly based on the "data" table...1st step is in querry "_Period Starts calc + Check Bankhols" .(there he checked also the bankhols and...

And exactly there is my problem...what I have to put in there! As i said I am not very familiar with vba..so I have currently the problem how to get the right syntax for it...Unfortunately it would take me days to get familiar with vba. But may I have to do this :-(

they are some more...currentPeriod...

Hey guys, i am currently working on a access database where I get on my calculations always this "too complex" message! The Problem why i get this is that the querries access on another querry, which is a little bit too complicated (I think)! I have a Start and a Enddate and between a lot of...