Search results for query: *

Chavito21 Have you considered using Slide Transition? Then in your class module add: Dim WithEvents appPPT As PowerPoint.Presentation Dim SlideShowEnd As SlideShowSettings Private Sub App_SlideShowEnd(ByVal Pres As Presentation) With Pres.Slides.Range(Array(1, ?)) _ 'replace ? with number...

Everyone: I have found the answers to my delima: Three additional items had to be added to the code in the DataReport_Initialize area get these reports to work (and show) with grouping and param passing. 1st, I had to add the actual code for the param ? in the Shape statement 2nd, I had to...

Mango, The command name is cmdNA with grouping named cmdNA_Grouping. I'm putting cmdNA_Grouping as the DataMember on the grouping section txt properties, and the cmdNA in the details section txt properties. I still receive the same error. I have attempted removing all the controls in the...

Mangro: SHAPE {SELECT PART.PART_NO, PART.REV, PART.TITLE, PART.PREP_BY, PART.PREP_DATE, PART.ASSOC_CNTR, PART.PROJECT, PART.SYSTEM, PART.SUBSYSTEM, NA.NA, NA.NA_SEQ, NA.DASH FROM NA, PART WHERE NA.PART_NO = PART.PART_NO AND (PART.ARCHIVE_DATA = '0') AND (PART.MARSHALL_DATA = '0') AND...

Try putting the If statement in the DataReport_Initialize instead of the DE_Initialize. Hope it works! bB

Johnny: Try this in the Private Sub DataReport_Initialize() section. With DataEnvironment1 If .rsYourCommandObjectNameHere.State = adStateOpen Then .rsYourCommandObjectNameHere.Close End If End With I had just figured this out and was advising from home. bB

The following works wonderfully passing param's when NOT using the grouping feature. With DataEnvironment1 If .rscmdNA_Grouping.State = adStateOpen Then .rscmdNA_Grouping.Close End If strSQL = "SELECT PART.PART_NO, PART.REV, PART.TITLE, PART.PREP_BY, PART.PREP_DATE...

I have a simular problem with html however mine is related to the header section. The lblBoxes seem to randomly change size and shape without reason. I have no problem in the detail section, all is well. ?? Thanx much! bB

Reference another post regarding a simular instance: thread222-417529 have tried everything to pass param's with the grouping feature on reports...to no avail. All works wonderfully without grouping. Has anyone figured this problem out yet? Thanks bB

Sorry Johnnyv.......forgot If DataEnvironment1.yourCommandNameHere.State adStatusOpen Then left out the State. bB

Johnnyv I believe your answer is to write a simple If DataEnvironment1.yourCommandNameHere adStatusOpen Then DataEnvironment1.yourCommandNameHere.close End If Command name(s) associated with your report(s) of course. Your next call to this environment should rebind the report and requery...

I see from the list of post that I am not alone in my insanity with the Data Environment! I can pass as many parameters from text boxes on a form through the commands in the DE and they work wonderfully however....only when I remove the grouping. URGGGGG Has anyone assisted Gates with this...