Recent content by vdzr

wow, this is not a easy one Time range can indead elaps eachother. Item can have only a begin date Clientdate needs begin + end date but is not restricted to be inbetween indexdatebeginorend Was the comboboxview posible? result = combobox.text and pulldown = items (inbetween and elapsing...

The items (daterange) spans over differend contracts with differend taxes (daterange) for a client(calculation daterange). How do you calculate an item with different taxranges? client date range 1/1/2004 - 31/12/2008 taxes in contracts 15/1/2004 - 15/1/2005 (index1) and 16/1/2005 - 15/7/2006...

Who knows the best way to (or a link)... table clients (form) client calc date range : beginclientdate - endclientdate table contracts (subform clients) clientcontracts with table index (subform contracts) yearly index date range : beginindexdate - endindexdate table items (subform clients)...

In what way there will be complications?

Every client has about 15 records with a yes/no field. Only one record from the 15 may have a yes selected.

How does it go? I made already a tabform where you can see the date with the different indexes and factors. clients have different indexes and each year has different indexes. Each client has about 15 subrecords within each record 4 calculated fields based on the index before a (input)date.

I was thinking to make a table with dates and indexes filtered for each client(record) The calculated field must look for the last index (start)date before the pc 'now()' date (so you change pc date to see the previous year calculations) query out the right indexes & date was ok but can I do...

What is the way to go for: 1)look in all (sub)records from one client(record) if there is a checked box? (validation???) 2)Event before/after update : If a checkbox is set to true --> every other (sub)recordscheckbox must be false thanks already

OK now it's working I still didn't know where to put the code but after some trial it works if then else in the do while loop and then everything was ok thanks big star

Where do I have to put 'if me.newrecord'?

Yes the counter is now good but in the new record there is always a . Y (a peace of the counter) to see. When I placed the recordcount at the place of the arrow (green text) it was giving the result : 1.4 0 0 0 .4 When placed in : Bye_GetLijnNr: ' Resultaat terug geven...

Is it possible to put a total 'Y' in the recordlinenumbering I have a working functioncode but don't know how to put the total(lines) in it. Function GetLijnNr(F As Form, SleutelNaam As String, LnStWaarde) Dim RS As Recordset Dim CountLines 'Dim maxcount As...

thats the way to go .... thanks

I can't put limittolist=No when the first primID row is hidden with width = 0";1" Message = microsoft office can't set the limit to list to No right now! The first visible column, whitch is determined by the Columnwidths property, isn't equal to the bound column, adjust the columnwidth property...

That I have already Fill the text box and make the width of the combo just that little so you only see the pull down (matchcode). Tab order -> textbox(=zoekgedeelte),combobox(=cmdzoekclient) Code for the text box : Private Sub Zoekgedeelte_LostFocus() If IsNull([Zoekgedeelte]) Or...