Search results
-
W
Pivot Table View - Show all records
Hello forum, I am using the "Pivot Table View" for a table in Access. I have one column field and one row field, and am displaying a third field in the detail zone. I want to list the third field values at each of the intersections of the other two fields, as in a cross tab. My problem is... -
W
Set Focus to Subform on a Navigation form from a different form!
Hello forum, In Access 2010 I have a Navigation type form ("navformname") with a few subforms (e.g. "subform1name"). I have a third separate form ("thirdformname") with a list box that contains possible values contained in "subform1name". I have a double-click event in a list box on... -
W
Pivot Table subtotals not displaying
I want to display my query results in a pivot table, showing subtotals for various category fields. In the pivot table view, I've selected the field header of interest, which enables the "subtotal" button. I click the button and it adds the "Total" lines where expected, but the actual... -
W
Selected in ListBox not actually selecting?
I have cascading listboxes, where the content of one depends upon the value selected in the previous. I want to preselect the first item in the list box by default, so I use this: me.ListBox.Selected(1) = True The problem is when I check the value of the selected item, I get myValue = null as... -
W
List box number format
Hello, I have a multi-column listbox that is bound to some fields in a table. One of the fields is a number with 4 decimal places yet it displays with only 2 decimal places in the listbox. I tried adjusting the rowsource for the list box as follows: Format(myNumberField,"0.0000") This would... -
W
SQR() function stopped working
Hello, I have a report with a text box with the following formula: You might recognize what I am doing here. If you know the standard deviation for a parameter of a single item, you can find the SD for multiples of that item by multiplying by the square root of that quantity. Anyway, this... -
W
SQL Syntax Error: Incomplete Query Clause
I imported data to Excel using (Data > Import External Data). I then created a VBA macro that prompts the user for the query limit that will be used to refresh the query. I assembly the SQL command in a string variable and use that variable as the argument for .commandtext. I create the new...