Search results for query: *

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...

The combo is unbound, and 'after update' he looks for the choosen primIDclient (width = 0") Can somebody post a tested code, please! I used the refresh code because a 'save' commond gives an other error message that references to use the me.refresh code. This partial look up in a combo box...

I changed the 'after change event' to Private Sub ComboTEST_Change() Me.Refresh Me.ComboTEST.Requery End Sub and the old error is gone ! but now its getting interesting, The datasheet view from the combo source sql gives the right record but ... an error message occurs in the form like : error...

2118 error message You must save the field before requery?? and when I add me.combotest.refresh I get a new error : method or datamember not found name combo box = ComboTEST colum count = 2 with = 0;15 source = SELECT TblClienten.Codeprim, [Codeprim] & ", " & [Anaam] & ", " & [Rnaam] & ", " &...

If you put a value in a combo box, it will show a dropdown list of the 'Input' & "*" Input = brown dropdownlist shows : brown brown patrick browny etc ... but not the existing query items like James brown Jacson brown velvet Now I use a text field with a after update event (requery...

like "*" & [forms]![searchcmbbox] & "*" I used now one text box and one combo box with reference to the text box