Search results

I have had problems in the past with spaces in a field name...That may be part of the problem.

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 did something similar... In the table for the records, I added a new field called "blnVisible" and set it to True/False as appropriate. In the report, I added the field blnVisible (made it invisible) and then put the code behind in the appropriate GroupFooter Format event...

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

You could use a dlookup, but that is slow. It is probably better to include the UserName in the recordsource of the form and then set the textbox's control souorce to UserName. When you enter a UserID, the UserName should automatically fill in. Good Luck!

I would try to create an option group ("OR" and "AND". In some event (after-update maybe), you can use a select case to change the Filter.... 'You will need to do this several times for each option group button you have selected. Hope this helps. ie. dim strFilter as string Select Case...

sorry....gblnCancel is just the nomenclature...A Global Boolean variable Public gblnCancel as boolean 'Dimension this as a public variable 'Set the variable where you determine whether or not to use the after update event gblnCancel=True ...After_Update if gblnCancel=True then 'Run the...

You can also assign a global variable "gblnCancel". Assign it to True or False in the macro and then in your After Update Event do the following: If gblnCancel =False then ..... Else ..... End If Good Luck

Thanks Rich! This worked PERFRECTLY! dim ctl as Control set ctl =......subform name DoCmd.GoToControl ctl.Name DoCmd.GoToRecord , , acFirst

Yes, I want to set focus on the first record.

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