Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / June 2004

Tip: Looking for answers? Try searching our database.

Lookup columns using existing tables - Access 2002

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mary Wild - 20 Jun 2004 18:30 GMT
I am using the lookup wizard to create a lookup column
using an existing table within my database however I get
an "automation error".  I can get as far as choosing the
table and the fields then get "Automation error. The
specified procedure could not be found."  I can create a
manual lookup table however this defeats the purpose.  
I've tried detect & repair and reinstalling Access 2002.  
This is a brand new database created in Access 2002.  Any
suggestions?  Thanks.

Mary
John Vinson - 21 Jun 2004 02:58 GMT
>Any suggestions?

Yes; avoid the use of the misleading, misdesigned, and all but useless
Lookup feature altogether:

http://www.mvps.org/access/lookupfields.htm

Instead, create Forms to display your data, and use the toolbox Combo
Box Wizard to create combo boxes ("lookups") on the Form.

                 John W. Vinson[MVP]    
   Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.