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

...(index1) and 16/1/2005 - 15/7/2006 (index2) Item range 29/1/2004 - 1/1/2006 calculation: (((30DaysMaxProMonth-29Days=1day)+(12/2004-2/2004=months)*30dayspromonth)+15days * index1) + (30-15+((6/2006-2/2005=months)*30)+15 * index2 I don't know where to start Do I need a query with all the...

...a (clientcontract)subform with contracts and a one to many index relation to contracts. a (clientitem) subform with bouth items and date range Unbound fields 'with the calcuted sum of items (restricted by the clientrangedate) * changing index (changing pro yearlyindexdaterange) 1 month = 30 days

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.

...see the previous year calculations) query out the right indexes & date was ok but can I do this with code behind the formcalcultion field? Amount * top index from the query (but in code) query :SELECT TOP 1 TblWoningverzFaktoren.secIDClient, TblWoningverzFaktoren.Aanvangsdatum...

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

...Code for the text box : Private Sub Zoekgedeelte_LostFocus() If IsNull([Zoekgedeelte]) Or [Zoekgedeelte] = "" Then Zoekgedeelte = "*" End If Me![CmbZoekClient].Requery SendKeys "{F4}" End Sub If you enter or tab on the text box The combo box [cmbzoekclient] will open automaticly with the...

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

...& ", " & [Anaam] & ", " & [Rnaam] & ", " & [Vnaam] & ", " & [TblAutos].[Nummerplaat] & ", " & [TsTblWoning].[Polisnr] & ", " & [TblWoningen].[AdresWoning]) Like "*" & Forms!FQClienten!ComboTEST.text & "*")); Private Sub ComboTEST_Change() Me.ComboTEST.Refresh Me.ComboTEST.Requery End Sub

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