Search results

I have a form where the control source of several text box fields includes a function that looks up values in a table that is not the form's record source. The default value in the property for these fields is set to 0. Unfortunately, when I migrate to a new record, these fields display the...

I've searched the forums and cannot find a problem similar enough to my issue to resolve my problem. I have a main form with 3 subforms. Each subform is identical except for the value of the filter property. The filter is for the same field, but with a different value for each subform. So, for...

I'm stumped and need some help. I am trying to transfer values from my Access 2007 database to an Excel file, but I am getting error 3265 - item not found in collection. Below is a snippet of my code. strFileName is the fully qualified name of an Excel file. The error occurs at the red...

I've searched several forums but cannot find a resolution to my issue. I'm using Access 2007 and have a query in which I have a Where clause that includes a TempVars variable. Here is the SQL: SELECT tbl_CostCenter.*, tbl_OpEx.*, qry_OpExByCC.* FROM (tbl_CostCenter INNER JOIN tbl_OpEx ON...

I have developed a pivot table view of a form in Access 2007 and have two questions regarding formatting. I'm trying to differentiate two columns of data by color to make it easier to read. However, when I change the background color for one of the columns, it changes the color in both...

I'm using Access 2007. Is there any way to easily display the raw data details for a "cell" on a pivot table form similar to double-clicking a pivot table cell in Excel? My raw data has daily transactions that I'm rolling up into a pivot form that reports totals by cost center and period...

I've searched the internet for what could be my problem, but couldn't find anything, so I'm posting this hoping someone can help. I have an Access 2007 database with linked tables to SQL Server 2008. In the On Open event for my main menu, if the user's ODBC data source has not been set up on...

My application includes a main menu with an On Open event that ensures that the user's ODBC data source is set up properly to access the SQL Server database where the data is stored. If the ODBC data source needs to be set up, I open a form that emulates a msgbox that includes a "hyperlink". The...

I have a situation where I allow users to filter data on a single form. If they choose to add a new record, if the data entered in the new record does not match the filter criteria, I want to remove the filter and then go to the newly created record. I added code to the AfterInsert event...

I'm running Access 2007 and have a table with several Excel file attachments (one attachment per record). Each record has a Type field to identify the various files. In VBA, I'm running a routine to save the Excel file to my hard drive. Here is an excerpt from my code: Set rs =...

My Access 2007 database is used for creating a 5-year financial plan each year for planned projects. An administrator runs a routine each year to carry forward any projects from the previous 5-year plan that had dollars planned for the upcoming 5-year period. It is possible that in last year's...

I am so frustrated right now and just can't determine what my problem is! PLEASE HELP! I am using Access 2007 to access SQL Server database tables. I have a form that just lists values in a table that only has two fields, both of which are displayed on the form. I have code in the Delete event...

I'm stumped and need some help! I understand what this error message means, but I don't know why I am getting it. Below is my code. The strFilter value I'm sending to this sub is "11/27/2011". The Period Start field is a date field, so I'm wrapping the passed date in hash marks (#). When I...