Lookup Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I keep getting this message 'microsoft office access can't start the wizard
builder, or add in. The libary database containg the wizard, builder or add
in may not be installed'. when trying to use the lookup wizard in a table on
Access 2003. I've repaired and up dated it. What am I doing wrong.

Thanks,

kfh.
 
The wizards are installed as a separate item. When you do a repair install,
your previously selected items are reinstalled, so if you hadn't previously
chosen to install the wizards they still won't be installed by doing a
repair. Go to Add/Remove Programs in Control Panel. Select the Office
install selection and click the Change button. Tell the install that you
want to Modify the install then click Next. Leave the selected list of
programs as it is and check the box under then to customize what gets
installed and click Next. In the next window you will see a list of
customizable options for each of the Office programs. Click the + next to
Access to open its listing and make sure that the wizards have been chosen
to "Run from this computer" then click Next until you get to the option to
finish the install. You may need your Office install disk to do this.
 
Hi All,

I keep getting this message 'microsoft office access can't start the wizard
builder, or add in. The libary database containg the wizard, builder or add
in may not be installed'. when trying to use the lookup wizard in a table on
Access 2003. I've repaired and up dated it. What am I doing wrong.
Click to expand...

For starters... trying to use a misdesigned, misleading, and all but
useless misfeature which Microsoft should never have created. <sour
grin>

See http://www.mvps.org/access/lookupfields.htm for a critique.

If you insist on using it, or if other Access wizards aren't
available, get out your Office Pro disk and run Setup on Access; see
if this knowledge base article applies:

http://support.microsoft.com/default.aspx?scid=kb;en-us;838911


John W. Vinson[MVP]
 
Hi,

Sorry, the post a new thread button is not working, so I can only reply to
the message in order to post my question.
I have two tables: tbl_A, tbl_B and a query qry_C basically just combine
some of the fields plus do some simple calculation for both tables. Now I
want to insert a lookup column in tbl_A to view some data from qry_C. From
lookup wizard, it shows “No valid fields can be found in “qry_Câ€. you may
have selected a query that uses the table you’re adding the lookup column to.
Please select a new sourceâ€. Does anyone can tell me that if this error is
normal for my particular situation? Or how can I avoid it?

Thanks very much!
Lan
 
Hi,

Sorry, the post a new thread button is not working, so I can only reply to
the message in order to post my question.
I have two tables: tbl_A, tbl_B and a query qry_C basically just combine
some of the fields plus do some simple calculation for both tables. Now I
want to insert a lookup column in tbl_A to view some data from qry_C. From
lookup wizard, it shows “No valid fields can be found in “qry_C”. you may
have selected a query that uses the table you’re adding the lookup column to.
Please select a new source”. Does anyone can tell me that if this error is
normal for my particular situation? Or how can I avoid it?
Click to expand...

You can avoid it by... not using the very limited, misleading, and
generally disliked Lookup Wizard. See

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

for a critique.

The specific cause of the error message is exactly what it says:
you're defining a lookup field in tbl_A which contains a circular
reference to tbl_A. The wizard isn't smart enough to figure this out!

Instead, create a Combo Box on the FORM that you should consider using
to interface with tbl_A. You can base this Combo Box ("lookup" if you
will) on qry_C. Or, since you're presumably looking up a calculated
value, consider doing the calculation right in the Control Source of
the Form (perhaps using DLookUp() to look up a value from tbl_B).
Perhaps you could post the SQL view of qry_C and indicate what you're
trying to look up!

John W. Vinson[MVP]
 
Hi John,

Thanks for your reply. Using Combo Box will be a good solution to my
problem. However, since I’m pretty new to Access, I’m not sure if the OLE
object is allowed in form? Since I defined one field in my table_A as OLE
object, so I can store a word document in it. I can input new records from
this table, but I’m not sure and don’t know how to input new data records
into the form with interface of tbl_A.

Thanks for your help and waiting your reply!
Lan
 
Hi John,

Thanks for your reply. Using Combo Box will be a good solution to my
problem. However, since I’m pretty new to Access, I’m not sure if the OLE
object is allowed in form?
Click to expand...

Yes, you can put a control on a Form to display your OLE object.
Easier than using a table datasheet in fact!

John W. Vinson[MVP]
 
Back
Top