Conversion Problem

  • Thread starter Thread starter Del Nash
  • Start date Start date
D

Del Nash

I've been given an Access Database to maintain. It was
written using Access 97. And we are now using Access 2002
and XP

The program has a form that uses a query to supply the
data. There is a Pull Down window on the form.

In the 97 version I can use the Pull Down window and
change the field.
In the 2002 version the Pull Down Window is enabled but
locked. I've added the code to unlock it but it doen't
work.
From what I've read I should be able to use the pull down
window to make changes to the table.

Any advise??

Thanks.

DLN2
 
Open the query supplying the data. Can you edit the field
value there? If not, the design of the query is the
problem. Try posting the SQL if you need help resolving
that issue.

Otherwise, verify that the 'AllowEdits' property of the
form is set to True and the 'Locked' property of the
control is set to False.

If you can place your cursor in the control, there's
nothing else that I can think of that could prevent you
from updating the value. good luck.
 
Let me say that I didn't write the code but here is the
line:


strSQL = "Select * from class where classid ='" &
me.txtClassid & "'"
set rst - db.OpenRecordset(strSQL)


I've set the AllowAutoCorrect to True
the Enabled to True
and Locked to False

in the code and it's had no effect.

Thanks.
 
I build several more queries on the table and had the same
problem with updateing the information.

I opened the old database and the converted database side
by side and checked everything out.

When I got to the relationship area I found that the
converted database wasa missing about half of the
relationships.

I reconnected the relationships, which required me to dump
alot of data that the converted database said should not
be there, how it got there I don't know.

But now it's working the way it should.

DLN2
 
Back
Top