Question DLOOKUP wizard is not function in 2010

n3wguys

Registered User.
Local time
Today, 15:59
Joined
May 14, 2012
Messages
39
I don't know what I do,I searched in google but not found.
my problem:
when i make a LOOKUP wizard and all finished, warning message is show
"you can't modify the structure of table, because it is already in use by another person or process"

after i clicked ok, show message again

"Microsoft access couldn't launch the lookup wizard, or this wizard has been disabled...blabla...blaa"

on my laptop, i can make this lookup wizard and no problem, but on my PC,

still cant do it.:banghead:

three times install and uninstall but not solved..

help me
 
Hmmm.. Are you trying to change the structure of an Linked table? If not make sure you are the only person working on that database file..

Other part.. Why are you trying to have LookUps in table level?? It is NOT RECOMMENDED to do so..
 
I cant understand anything to change it. I only know make it what i learn..
please help me, i have read this site but not clear no solved before i ask here.:banghead:
 
There are a few issues that could be contributing to your situation. You should check on all of them even if you find that one of them appears to be involved.


You might not be able to create the lookup in the Child Table if:
  • the Parent Table is open.
  • the Lookup will create a Relationship that is already defined in your database.
  • there is any window open that is using either of the tables, including the Relationships window.
 
thank you very much what are your answer...

for that sure and Im sure, nothing open parent table or form when i make this field.
for case this, I usually make same a step for making DLOOKUP wizard on my laptop and nothing problem I found. when i transferred my file to my pc, and make again this wizard, that all come from the problem. and im sure, table and relation isnt open. conclusion all, what i do in my laptop for making DLOOKUP Wizard, i couldnt make it on my PC. so I have consider it might problem ms access. so i cant start to solve from where. because im not technicion ms access.
View attachment 45370

View attachment 45374
oh my god..help me:(
 
Last edited:
I know this doesn't solve your problem but creating lookups on tables creates substantial problems when you try to use the table in queries and reference the lookup field with VBA. There are numerous references to the problems caused by table-level lookups.

Instead of creating the lookup on the table, use lookups on forms. If you want to see the lookup value in a query, include a join to the lookup table and select the "text" value from it.
 

Users who are viewing this thread

Back
Top Bottom