Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Expert One-on-One Access Application Development
This is the forum to discuss the Wrox book Expert One-on-One Microsoft Access Application Development by Helen Feddema; ISBN: 9780764559044
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert One-on-One Access Application Development section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 3rd, 2007, 11:21 AM
Registered User
 
Join Date: May 2007
Location: Rochester, NY, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error when trying to run Design Schemes

:(I'm starting simple. System is WinXP SP2, Office XP (2002), Access 2002 SP3. I've created a new (simple so far) DB and am trying to follow Helen's ideas. I've got a simple "Person" table, PersonID primary key, FirstName, LastName, and a few other text fields. I've installed the Design Scheme Addin with no trouble (why does MicroSoft insist on hiding the user's Application folder?), and when I open my new database and run the AddIn Manager, the Design Schemes Addin is right there.

However, when I go to the Forms page and try to create a basic form for my Person table, things go awry. I select Custom Form, put my table in, choose standard everything, and click Finish. I get an immediate Compile Error, Can't Find Project or Library. The Debugger is in Public Function ModuleTextHF(), highlighting the second line of code, the string "Chr$". If I click OK, it stops the debugger and puts me back at Finish. Another push, another error, this time Error 2125, The setting for the FontSize property must be from 1 through 127. An OK here pops me up a blank-looking Form2, nothing on it. There is also a Form1 which resembles the starting Form1 shown as Fig 2.8 in Helen's book.

I noticed in reading the forum that Helen mentioned an error situation that sounds like mine. She said "A misleading error message highlighing a perfectly innocent string manipulation function generally results from a missing (or wrong version) reference. Check your references in the Tools|References dialog, and see if any are marked MISSING. If so, uncheck them and check the version of that library on your computer." I tried to do that, but the References button is greyed out.

... AHA! I may have fixed it! I'm going to continue this post, in hopes it "helps the next guy". I went ahead and opened Form1. I then went to Tools/Macro/VBA Editor, and Tools/References is now available! It DOES have a "Missing" entry, Microsoft Common Dialog Control 6.0, which is not on the list of objects (maybe it has "fixed it"?). Now all I have to do is find this object ...

Well, that's not so easy! Before messing up my system, I'm going to stop, post this, and hope someone answers (soon!).




Bob Schor
Reply With Quote
  #2 (permalink)  
Old May 3rd, 2007, 11:34 AM
Registered User
 
Join Date: May 2007
Location: Rochester, NY, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've just scoured my hard drive and several CDs (I don't have Visual Studio CDs here). I can find comdlg32.dll in the Windows\System32 folder, but there is no comdlg32.ocx file present. And I'm still getting the error! Help would be most appreciated.

Bob Schor
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
design schemes : error message tanhkcn BOOK: Expert One-on-One Access Application Development 0 December 1st, 2007 03:30 AM
Design Schemes Michele_Haywood BOOK: Expert One-on-One Access Application Development 1 October 4th, 2006 04:01 PM
Helen's Design Schemes Nanette Access VBA 1 September 20th, 2006 07:42 AM
Automation Error in Design Schemes rpfister51 BOOK: Expert One-on-One Access Application Development 0 April 29th, 2005 05:27 PM
design schemes johngunn BOOK: Expert One-on-One Access Application Development 2 July 8th, 2004 08:30 PM



All times are GMT -4. The time now is 05:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.