Recent content by cheaster

I would like to do this because i want to select each value and then use this value in a query and after select the next value and use an another query. and i want to use a macro which select automatical the values and call the query for this value.

hi i have two question first: i want to use a macro in Visual basic 6, which macro select each item of my combobox step to step, my problem I cant set the selected item in combo box? two: how can i get the rows from my table from first to last and put to variable? thanks cheaster

oh thank you and sorry for my slow uptake:)

Dear Namlian! I belive you, but a can't do what you told. I don't often use Access. I don't really understand that the schema.ini can use for exporting? i really need your help, so please tell me for step to step how can i do my schema.ini and use for exporting data thank

i don't insist for this name but a see this on the access help a i thought that i must use this name. for other name the code is successfull?

i write now an example but this isn't work my table name: adat adat adat cikkszam datum 1 5/5/2009 5 5/5/2008 my Schema.ini: [sz.txt] Format=CSVDelimited ColNameHeader=True MaxScanRows=0 CharacterSet=OEM Col1="cikkszam" Char Width 10 Col2="datum" Date Width 9 i have got a...

but i have a table full with datas, and i want export datas to csv file and i want to set the separators which the access write into the csv file haven't got any example where select datas from table and export to csv file using the schema.ini?

ok but select which file? and where can I specify the separators?

how can i use the norma spec? if i use the normal spec then the delimiter depends the regiuonal settings, doesn'T? when i leave the spec name then the delimiters was the same as the regional setting, and this case doesn't good for my, because then the users must always set the Regional...

i have got a table. this table contain article number, storehouse number, store level, date i have got a query which choose from the table datas, which article number is the same as the user select in the form. i would like to write the result of this query into the csv file, and I would like...

my code is: DoCmd.TransferText acExportDelim, "Schema.ini", "t_le", "C:\p\sz.csv", True, "" where t_le is a table and i would like to use schema.ini as spec name but it doesn't work. the error message is the same. So the code doesn't export the table and i can't find any working example

sory but i really need the answer. i would like to use schema.ini because a would like to set the delimiters, the date format and the decimal point, because in other computers the regional setting is other, nd I need the same delimiters

hi i wrote a macro which write a table datas to csv file and i would like to use a schema.ini but this row doesn't work: DoCmd.TransferText acExportDelim, "C:\p\Schema.ini", "t_le", "C:\p\sz.csv", True the error message said: this string specification isn't. a tried DoCmd.TransferText...