Search results

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

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

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

hi i do a little check before run code Public Function validationValue() As Boolean If lstTransit.ItemsSelected.Count > 0 And txtDate.Text <> "" And txtHeureDebut.Text <> "" And txtHeureFin.Text <> "" Then validationValue = True Else validationValue = False End If...

hi i have a excel file with many sheets are there a way to import all this sheet in access in one shot? thanks

hi in vba i done a query strQuery strQuery = "select sum(x) as X, sum(y) as Y from test3" how to run this query and get sum(x) value, sum(y) value and set it to label txtX.caption = ... txtYCaption = ... any idea? thanks