Recent content by collinm

hi in a form i have a button who open a report, this report use a query who need a parameter how to send a parameter to this query, form? thanks

hi some user use comma for decimal number and some other use dot i know ms-access use regional setting when i record value in the database and the decimal use comma is there a way to convert it to use dot?

hi i have a database x (x.mdb) and y (y.mdb) i would like to copy some report from x to y any idea? thank

ya because i use completion..... i tried with a list: lstResult.RowSource = "qryComparaison" that work fine...... but i search a way to do it with a subform/subreport component..... any idea?

i get the error Run-time error '3011': the ms Jet database engine could not find the object '~sq_cfrmT~sq_cResultQuery'. Make sure the object exist and that you speel its name and the path name correcttely

hi i created a query named: qryTest on a form, i put a subform/subreport (name: resultQuery) i have also a button when i click on the button, i would like to run my query: qryTest and i want to display the result to my component: resultQuery i tried resultQuerysourceobject =...

hi are there something similar to tokenizer (java) in vba i need to parse text file thanks

hi i display result query with: CurrentDb.QueryDefs("qryTest").SQL = strQuery DoCmd.OpenQuery "qryTest", acViewPreview are there a way to set column size for every field? thanks

is integer...... another question dim db as dao.database dim rs as dao.recordset set db = currentdb set rs = db.openrecorset("select sum(nombre_dga) as DGA...") msgbox rs.fields(nombre_dga) 'problem here why i get: item not found in this collection?

ok i changed + for & and get the same problem....... tried to use between..... get the same result...... surely a access bug....... if i use directely sql command, that work fine..... but i don't know how to set the sql query result to a label.....

hi i have a access database (250mb) when access run this line, i get: run time error : 6 Overflow totaldga = DSum("nombre_dga", "tbExcel", " jour >= " + "#" & Me.txtDateDebut & "#" + " and jour <= " + "#" & Me.txtDateFin & "#" + " and heure_debut >= " + "#" & Me.txtHeureDebut & "#" + " and...

hi hi i have sql query in a string strQuery="...." how to create temporary table with the result of this query? thanks

hi are there a way to print listbox content? i put result query to a listbox with this code listbox.rowsource = "sql query." listbox.requery what i need to change to put the query to a subreport? thanks

hi right now i display query result into a listbox, that work fine... i do: strQuery = "select * from test" lstResultat.RowSource = strQuery lstResultat.Requery i would like to use a subreport instead a lisbox... any idea? thanks

i i do a sum on a field..... if i put an index on this field does query will be faster? thank