Search results for query: *

Got it

I wrote a crosstab query and run it as pivot chart and it works fine. But I need to add a line to the chart that represent a constant value, is it feasible? and another thing, how can i add a legend? TIA

Use Nz function

I figure it out

I need the PageHeader to show only if there are detail lines in the page. On the ReportFooter there is a sub report and if the sub report is on the last page without detail lines, the PageHeader is still shown. TIA

Thanks GKChesterton & MajP GKChesterton, that's right, The requery performed after changes in the detail form, when it is closed, but i don't know where to insert the code to return to the line. Only the On Current Triger fires when it is back to the subform.

Hi I have a sub form on a tab control. Double Click on this form calls a detail form. when exit the detail form - it requery the sub form to update it. I would like to get back to the record i stood on before . TIA

I have a form that browses picturs like an album and can resize them. Need to be able to rotate a pic. Is it possible? TIA

if nz(DLookup("Courriel", "Table_Participants", "ID_Participant = " & Forms!Formulaire_Inscriptions!Participant),0) = 0 then msgbox ...... exit sub endif

Stephen Lebans knows. Look at his site: http://www.lebans.com/

Thanks! I'll give it a try

This function from MS Public Function PromptFileName(Title As String, Filter As String, InitialDir As String) As String Dim filebox As OPENFILENAME structure Dim fname As String selected Dim result As Long dialog With filebox .lStructSize =...

Thanks Remou Can i show it with the file?

My user needs to see the details (size) of a file. I know how to show the file using GetOpenFileName, but not with details. Is it possible ? YIA

Thank you for the explanation. It works great!

Thanks Remou What it means %comspec%

Thanks! That what I thought

I need to add the content of a text file to another text file. like in Basic : copy c:\a.bkp+c:\b.txt c:\a.bkp Is there a way to do it in one command? TIA

No, you can't. if 2 users login and one of then logout, the .ldb file will still show both of them. you can have a table that record login user and delete it when logout.

If Me!combobox1.ItemsSelected.COUNT = 0 Then Me!combobox2.RowSource = "your query without parameters" else Me!combobox2.RowSource = "The query you have" End If