Search results

hi, on my form (frmtest) i have a combobox(cbolastname) where they select a name from it to store in the record now when i put a new record and i select a name from the combobox the names that i see on the form in the other records may not availible in that combobox have someone have a code to...

HI thanks for reply i do the following and i have an error (type????) Dim cdn As String cdn = "[Achternaam] = '" & Nz(cmbOPERATOR.Column(0), "") & "'" And "[OPERATOR_VOORNAAM] = '" & Nz(cmbOPERATOR.Column(1), "") & "'" cdn = cdn & " And VERLOFWEEK = " & Me!VERLOFWEEK And VERLOFDAG = " &...

thx for this help it works fine now thank you greetings

thanks for your reply this is the sql from the combobox SELECT qryOperators.Achternaam, qryOperators.Voornaam, qryOperators.Persnr, qryOperators.Team, qryOperators.Ploeg, qryOperators.Werkpostnr, qryOperators.Afdeling FROM qryOperators GROUP BY qryOperators.Achternaam, qryOperators.Voornaam...

hi all, can someone help me with this please thx

hi, in a table (tblplanner) i have this fields: holidaydate = date weeknumber= number daynumber= number forname =text backname=text now on my form they can select a name from a combobox the other fiekds wil filling automaticly thats no problem when the above combination already exist in table...

thanks for reply the users must be make a selection on the listboxes can you help me

hi on my form i have a field registrationdate and person the table has only 12 records how can i have (continouis form) a field next to registrationdate that show the range number on the form example: 1/10/2004 15:00:00 = 1 1/10/2004 15:03:00 = 2 etc...... SO TO 12 RECORDS when a record is...

hi, on my form i have 3 cboboxes Wher thy do a selection example: cboyear gives = 2004 cboweek = 40 cboday= 5 now is it possible to convert this selection to the date 1/10/2004 and so on can someone give me a code for that please thanks

thanks for your answer this is what i being searching for thx

Hello, On a form I have a listbox with in this names of persons if I seleKted a name in that listbox the name put in a textbox that's no problem but now I want that the name which I selekted no longer prevent in my listbox if a then selected another name the previous name must again in the...

Hi all, on my form i have a listbox with 7 columns now when i click on it i want the data from the listbox to Fields on the form when that data is on the form and i have click another row in the listbox and de data is different from the data in the form i have want to a message that's tells...

Hello, gladly I it following want realise, in a table called (tblIngave) I a field has in which numbers can be motivated (vb:0KA0010) now new record become each time there done and one gives a number in this number optelwaarde must get, therefore maw as for example a no. 0KA0010 there a...

Hello, On a form I have several choice lists with in this names of persons in all comboboxen stand tesame names if I now a name seleKted I want that the name which I selekted no longer prevent in the other lists and this way further can someone help me please thanks

pivot tables Hi Graham, on the pivotform also i can not see the places where Drop Row Fields and Drop Column Fields must to the are also not avaible i have done the update but the problem is the same see the attachment please thank you referee

pivot table Hi Graham yes the problem is i can not see the drop areas the form to do that is blank do you now what is wrong thanks referee

pivot Hi thanks for reply but the real problem are that the fields in the pivot form not visible is so that i not can drag and drop it on the pivot form because on that form in nothing to see for drop in it thanks

hi all, i have some problems with pivot tables in access xp when i used the wizard to make a pivot form i can not place the fields to the form the places to do that are not availible can someone tells me what here is wrong ? thanks