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?

Previous selected value. For example, if "April" was selected in the combobox previously (or listbox,etc), and someone selected "September", I would want to be able to calc the difference between the two....

People tend to overwrite the values, I would rather just type in the values within the combobox properties, that way they don't get changed inadvertenly....

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

Still no luck, using access 87, not sure if that makes a difference or not....

Creating Excel Worksheet: Set myExcel = CreateObject("excel.application") myExcel.Application.workbooks.Add myExcel.Application.Visible = True myExcel.Activewindow.zoom = 75

This is the all the code, in Access 97: myExcel.worksheets(1).Range("A1:O1").Select With myExcel.Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With myExcel.Selection.Borders(xlEdgeBottom)...

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?

If there both "ALL" it returns all records, but when I do "ALL" and one of the combobox choices in the other, it returns no records.

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

Thanks all, the "Like" was the answer: Like IIf([Forms]![Frm Reporting Main]![cboOM]="ALL","*",[Forms]![Frm Reporting Main]![cboOM]) works great! Anyone know of a way to REMOVE or ADD to a Criteria expression in a query? For example, if I wanted to add this or remove this from the query...

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