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

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

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

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

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

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

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

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

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