Search results

The data I have in my spreadsheet does not have a first row with the names of the fields. When I run this, it gives me a run-time error 2391 "Field F1 does not exist in table "testing"". How do I make it accept the default names of the fields? When I manually added in the field names, and...

I'm hoping that better minds than mine will figure this out: In my Report's On Open Event, I have the following: 'Set the RowSources for the Graph #1 Select Case [Forms]![frminput]![optionGrouping] Case 1 strGraphFrom = "qry_Detail_Raw " Case 2...

I have a line chart which is working fine, but when I show the Data table underneath the chart, all of the values show up as regular numbers. I want them to show up as currency. One would think that you could format the data table cells itself as a currency and that would work...Since the...

I can not seem to find the answer to this.... How do I name a query in a vba module for later use? I wrote the SQL statement I wanted in a module, but I can not figure out how to use it as a part of another query's (a crosstab) source... my fist query is written like: strSQL = "SELECT...

I have a parent form that filters a subform. When I change a cbobox on the parent form, I want the subform to refresh and go to the first record.... I have been trying to use the gotorecord action behind the OnChange event of the cbobox on the parent form, but it is not working...Any thoughts