Search results

Adrianna, Actually, I inserted the graphic from the toolbar and did not use the graphic as a picture for the entire report. Although I did try that method, when I did, the subreport on top of the graphic did not start until the second page! I have been looking for a property, like Word has so...

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

No, though I did check out your idea by Setting focus to another control just before running into code above that causes the problem. It still gives the same error. StephenS.

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

Sorry for slow reply. Have been in "Work-around" mode for the last couple days. Believe your syntax is correct but has not worked. Not sure how to answer your remark on "bad periods". My wife would know... Addressing controls on subforms in Access 2000 seems fragile. It worked on an...

Could it be the 'Build' option has been dropped in Access 2000? So far I have Re-Installed Access 2000 with everything. When that didn't get it, I uninstalled it and re-installed it again. Next, I installed the SP5 upgrade that was on the MS download website for Access 2000. Finally...

No, I was not running the code at the time. I went from design view into the code and right-clicked on an empty spot. 'Build' was not one of the options. So here's what I'm doing or planning to do right now. - ReInstall Access 2000 in the next day or so if nothing changes (though my first...

Right clicking in my code doesn't give me "build" as an option. It gives the following: Cut, Copy, Paste, List Properties/methods, List Constants, Quick Info, Parameter Info, Complete Word, Toggle, Object Browser, Add Watch, Definition, Last Position, and Hide. StephenS

Have tried the expression builder. It does not appear to pick up on any of the controls on the subform. According to Alison Balter's book on Access 2000 Development p 344, changing the property of a control on a subform uses the syntax: Forms.frmCustomer.fsubOrders!txtOrderID.Enabled = false...

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

ElsVanMiert, Thanks for the info. It does seem to be a bug. I was able to minimize the problem by not changing the application into an MDE file. By keeping it as an MDB file, it did not need the margins corrected every time - it was only an occasional annoyance. Not sure why! But I went...

Where is this article? I tried using http://search.support.microsoft.com/ and searched for the title but have gotten no hits on Access 2000. StephenS

I'll be looking for Richie's article myself. The code above gives me an error of "This property is read-only and can't be set" in my application. StephenS

I may have just found something - at least for the margins. Margins can be set in code using: me.left=".5" me.toop="1" etc. Still don't have anything for custom paper sizes but it's a start! StephenS

I've had a similar problem. About two months ago I submitted this topic and never received a reply - perhaps it's a bug. My experience has been ... if you save a report in design view with the right page setup, it USUALLY remembers the margins - but not always. I have not tried to save a...

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 going to assume that you are using Access 2000. Before you go to the VBA/code level, you might want to see what your global multiuser settings are. Choose Tools|Options, and then click the Advanced tab. A dialog box appears that gives multiuser settings for record locking. They are...

After working through a chapter in a book on recordsets, I decided to use ADODB recordsets rather than DAO recordsets. The ADODB recordsets are new to Access 2000 and are supposed to be superior (Although either are supposed to work). For ADODB, the code looks like: Sub CreateRecordset()...

Thanks, I'll try it! StephenS