Search results

Hi, on a form i have 5 comboboxes with names in it from the same table for example in all the comboboxes the data is A B C D E now when i select from combobox 1 the letter A in the other 4 comboboxes may the letter A not anymore availible etc... can someone help me with this code or query...

thanks for the answers greetings

hi, i have a field with numbers how can ii convert the numbers to a total time example: number 65 I want to see: 1:05:00 how can i do this thanks

hi on my mainform i used this syntax in a textbox Me!Text93 = Me!frmSuboverzicht.Form.RecordsetClone.RecordCount this count my records and works fine what i want to do is count the records in the subform with a creteria and show on the mainform only the records with the status "OK" the...

guus heel vriendelijk bedankt en groetjes uit belgie referee

Guus thanks for your help this is perfect When i select can i have a message if the user already has a planning for that dates and prevent me for add it greetings referee

hi, can you helpe me in the attachement i have a problem with an error thanks again referee

thanks for your reply i think that i do something wrong can je helpe me please with that attachement thanks referee

Hi on a form i have a begindate and enddate and e field for selecting a name now: i want to have the following begindate = 15/02/2008 enddate = 17/02/2008 name= test when i press on a button i want in my table (tbltest) 3 records with Free name 15/02/2008 test...

Hi all on a mainform i have a text box what i want to do is the following: when i write a word in the textfield and afther update i want to filter the records in my subform it must search in a memofield "FENOMEEN" on the subform called "frmSubTEST1" The mainform called "test" the subform is...

hi all, on a form i have 2 fields one for import a file with the filedialog 2e for the size of that file how can i have te size from the file in that field can someone help me with that code thanks

hi, now in all the boxes are all the 25 names for 25 jobstations i put one name on a station i a sort of planner that's i wanne to do can someone help me thanks

hi all on a form i have 25 comboboxes with names the form is based on a table (tblpersons) with the key personID now how can i in all the comboboxes in the event before update doing the following: when i select a name in a combobox before update i want to search in all the combobowes of that...

THANKS this is what i wanted greetings

hi all, in a query a wont do the following: in a field i have a weeknumber 1 2 3 . 52 etc now fot the numbers between 1 and 9 i want to place an expression thats change this numbers to 01, 02... 09 can someone help me with that expression for my query thanks

thanks for reply; i have as result this 12/07/7389 for 2005011 and it want to be 1/1/2005 do i something wrong with this Op: Format([DTPLAN];"dd/mm/yyyy")

hi , i want i a query a convert to a date i have the following 2005011 year/weeknumber/daynumber now i want a expresion in my query to have this result 1/01/2005 can someone halp me please thanks

Hi thanks for the example in attachment i have 2 more fields (team and code) can i see this also next to the name off the day? I hope you can help me thanks

hi all in a crosstab query i have the following problem in the daynumbers 1 to 5 i see the total nummer of the name thats not i want to see what i want to see is just the names (naam) and not numbers can someone help me with this please thanks

thx for replying this is the sql for that combobox, but it shows never the availible persons in that combobox what i'am doing wrong? thx SELECT qryReserven.Achternaam, qryReserven.Voornaam, qryReserven.Ploeg FROM qryReserven WHERE (((qryReserven.Ploeg)=[forms]![frmtest]![ploeg]) AND ((Exists...