Search results

No, OP stated that unchecked would not be enabled

Try this tastey morsal straight from the Spent Geezers Association...

Put a textbox and checkbox on the form that is bound to the name of indicator and checkbox of the table (make them visible = false if you want). Then "On Current" do something like: if checkbox.value = -1 then if textbox.value = tabname1 then tabname1.enabled = false elseif textbox.value...

Greeting. I had a bit of a plpay around with it. This should get you started. Save the excel file to c:\ SPENT

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...