Search results

Try using this: lvr = getanotherTS.column(<insert correct column number here>) put msgbox lvr in your code to make sure that lvr is in fact what it should be. (Or use stop line in code and locals window).

Should this be posted on a Microsoft Excel forum? Try the attached...your description didn't make much sense to me.. COuld be my Noobism..

When you press the submit buttin, it is doing a docmd.close event and closing the form? Change it so it closes after the person is selected. See here for some ideas: PS, I could be way off the mark, not really that sure what you were trying to do.

<comboboxname>.column(1)..See attachment for quick demo:

mmmmmm CANDY!!!.....

This should get you started::D

Try replacing this: Set myExcel = New Excel.Application myExcel.Visible = True Set wbk = myExcel.Workbooks.Open(CurrentProject.Path & "\GamesNamesRatings.xlsx") Set wks = wbk.Worksheets(1) ' wks.Visible = True with something like this: Set myExcel = CreateObject("Excel.Application")...

Does anyone have an Access OMD? WOuld be very much appreciated..

Getting through it now. So far I have this: Set frm = Forms.frm_MM_Quantities.qry_Quantities.Form theTITLE = frm.ChartSpace.ChartSpaceTitle.Caption xAXIS = frm.ChartSpace.Charts(0).Axes(0).Title.Caption yAXIS = frm.ChartSpace.Charts(0).Axes(1).Title.Caption Now for the tricky stuff...

No Spent, that would be silly. You could have the user pivot the chart in the subform then click the print or save button which assigns all the chart properties to variables and passes them to the Pivot Chart report for printout.

How do I pass the main form criteria? Basically I think I am going to have to create a seperate form with all the options that are available on the pivotchart (e.g Textbox to put axis title, checkboxes for which fields etc..) Then the user can click a button to update the subform PivotChart from...

Basically I want to select it with VBA code then use this to print it (the subform PivotChart) DoCmd.PrintOut acSelection, 1, 1, acHigh, 1 The PivotChart is embeded as a subform in the form. User clicks print button then something like this: acselection = me.frm_subFormPivot DoCmd.PrintOut...

Does anyone know the VBA to make a subform the "acSelection"

This works well, however I have a pivot chart in the form as a subform. Any changes made to a pivot chart in the form are not relayed to the pivot chart in the report. This makes the pivot chart useless... Any other ideas? I don't want to have to write a heap of VBA to update the Pivot chart...

This will get you started (from the Spent Geezers Association)..

Private Sub convertKWh2MWh() Dim pID As double 'or long or whatever is needed.... dim rst as recordset set rst = currentdb.openrecordset("tbl_Name") rst.movefirst do until rst.EOF pID = rst!1 pID = pID/1000 rst!1 = pID pID = rst!2 pID = pID/1000 rst!2 = pID pID = rst!3 pID = pID/1000 rst!3...

Greetings, Has anyone ever used Docmd.printout to print a form? If so how do you get it to fit to 1 page? Are there properties to do this? Spent

Greetings, I have a Pivot chart form that I have embedded in another form. I want the user to be able to use the pivot chart, but not be able to right click it and add fields etc.. Any tips on how to achieve this? Spent.

Have you tried: Open strFile For Binary Access Write As hFile Len = 3 Put hFile, , "RID"

Yes, using the dll. Read above post (it works with different mouse).