Search results

Whenever I put a graphic onto my report as a watermark, a "white space" appears that is equal to the vertical size of the graphic on the report. Both the .tif image and a subform are in the details section. At the end of the report, I have a report footer which allows a signature at the end...

I've been working for sometime on a subform problem where I receive the error: "Method 'Form' of object '_subform' failed Runtime error '-2146500594 (800f0003)':" This error message comes up when I try to enable or disable a control on a subform using...

I get this error when referring to the property of a control on a subform. I am using the OnCurrent event with the expression Me!subfrmControlName.Form.[ControlOnSubformName].Enabled = False I have also tried ... Forms!FormName!subfrmControlName.Form.[ControlOnsubfrmName].Enabled = False...

I hope the title says it well enough. The application I wrote was running. Users were entering data - it worked fine. Then I had to do some changes to the structure. After changing the structure I worked my way back up doing changes to the main data entry form and code. Just as I seemed to...

I am having a problem getting reports to remember their margin settings. My settings are a bit unusual (.4" top and bottom and .5" left and right). Typically, every time I start the application fresh, I have to reset the margins in Page Setup from their defaults. This often happens even if I...

I am receiving a "Type Mismatch (Error 13) whenever I dimension a variable as a recordset. For example: Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb The error occurs When I try to do a statement like: Set rst = dbs.OpenRecordset("qryname or SQL", dbOpenSnapshot) Up until...

I am a bit new to using transactions. I suspect this stuff is basic to some of you. I am designing an Access application that has an application side (*.mdb file with forms, code etc.) and a data side (*.mdb file with linked tables). The data side has a main table and three other data tables...

For the last couple of days I have been trying in vain to get the list for a combo box to refresh. The idea shown in "Tips and Tricks" on this web site was one of the first techniques I tried. It suggests using the following code on the main form: Me![Sub-form Name].Form![Control...

I am getting an error in Access 2000 that says, "Run-Time error '2501'. The Applyfilter action was cancelled." The "Help" button is dimmed when I get it, so there is no elaboration. Description: The form that causes the error looks similar to the "Sales Totals" form in the 'Solutions'...

Recently upgrated to 2000 and started a new project. When trying to dimension a variable as a database object, the message, "User-defined type not defined", appeared. It occurred on this simple code: Dim dbs As Database It is referring to the word "Database". As I typed the Dim statement, I...