Recent content by wjyoung

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

Sorry, no. I ended up creating a form with a table object to display the data and a text box object to display the total, which I calculated with DSum().

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

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

Thanks, jdraw. In summary: Don't select an item in a list box using .Selected = True like this: me.ListBox.Selected(index) = True myValue = me.ListBox.Value Do select an item in a list box by setting the value of the list box itself equal to the value of a particular list box item like this...

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

I found this: support.microsoft.com/default.aspx?scid=kb;en-us;194374 It's saying a reference library might be missing. However, I don't see how I can update my reference libraries when I don't have a full version of Access. Runtime doesn't let you edit VBA where references are set.

I had a similar error with a query that had an expression for one of the fields. It seems Runtime just doesn't allow expressions in SQL statements.

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

Update: I worked around the sqr() problem by raising to the 1/2 power. However, I just encountered a similar error on a LEFT() function. I'm beginning to worry I have a virus.

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

Replying to my own thread... I forgot to mention that at first I did not have the quotes surrounding mySQLstring, in the .commandtext statement: I tried dimensioning mySQLstring as a string and as a variant and got the same error: Type Mismatch. I'm using Array() because this is what was...

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