Search results for query: *

Hi, kinda stuck here, I have a monthly total in a report that I want to also use to calculate a cumulative sum, or PTD total. The catch is I only want to pull 4 months of data, even though the PTD is over a 12 month period. I've tried to provide an example below: April...

Ran into a problem with Excel and dates, I have the month name (as Jan-Dec), and I need to convert it to the month number using a formula, is there any way to do this?

Is there an easy way to determine the previous value in a combobox? I need to determine the difference between the previous and current value, is there a way to do this easily?

Just want to make a simple combobox with a few pulldowns, which will never change, is there anyway to just manually type in the values somewhere in the combobox properties? I'm trying to avoid VBA, and setting up a list somehwere else in Excel.... Thnks.

I'm trying to create a section in a spreadsheet that will allow a user to click on a cell and change its color. I could probably code something, but wondering if there's toolbox control I could use that would work better? Or is coding the best route, as I would have to read the cell color for...

I want to be able to change the mouse cursor to an arrow based on its location over an Excel range?

I'm trying to create a section in a spreadsheet that will allow a user to click on a cell and change its color. I could probably code something, but wondering if there's toolbox control I could use that would work better? Or is coding the best route, as I would have to read the cell color for...

Is there a way to create lines(borders) in an excel worksheet from Access VB? I've tried this: With myExcel.Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic But just generates an error '1004 - Application defined or...

Is there any way to link a checkbox to a table record in an UNBOUND form?

I have had great success with the following criteria expression attached to a combobox: Like IIf([Forms]![Frm Reporting Main]![cboOM]="ALL","*",[Forms]![Frm Reporting Main]![cboOM]) to pull up all the values if someone picks 'ALL' in the combobox, however, when I try to link the query to TOW...

Have been able to create a query and link the criteria to a form combobox, but having problems trying to find a way to run the query if the user selects "ALL" in the combobox, so that the query will run all the combobox choices, have been trying this in the criteria: IIf([Forms]![Frm Reporting...