Some VBA Code Disabled in Access 2003.

  • Thread starter Thread starter JadeTiger
  • Start date Start date
J

JadeTiger

Hi,

I've got a problem where when I open MS Access, it does not display some of
the SQL results in my search form. The Control, (a list box), on the form
uses the SQL statement as its row source.

All was running well until I got the Sandbox security notification. I have
tried to change the Macro Secutity settings, however this does not seem to
help.

Does anyone have any ideas?
 
Thanks for the reply Chris.

I've looked still further into this and it appears that any control whose
list source, (list box, combo box), is based on an SQL statement is affected.
The strange thing is that it is only with reference to one field in the
underlying table that it behaves like this.

Further confusing the matter is that the code still works, (in the case of
the list box), but in the results to the SQL statement for that field are not
displayed, just blank. But for the combo box, the field is again blank, but
the combo will not allow any selections to be made.

I run this application of 5 other workstations and it resides on our
network, and it is only on my machine that I have this symptom. It is really
annoying because the field that won't display is the client name field which
is what you need to search by in 9 out of 10 cases!! Arrgghh!!!

I've also tried uninstalling Access and reinstalling it but it does appear
that some components are left in the registry even after the uninstall and
upon reinstall it just goes back to the same behaviour.

Sorry to be longwinded but this seems to be a very specific problem. I know
that it must be a setting somewhere within Access because no-one else has
this problem. I have witnessed it in Access 2000 & 2003.

Please someone help!!!
 
And here's the punch line, I don't have a SandboxMode folder in that part of
the Registry! I should have mentioned that before becuase i'd read a lot of
the threads here and it was mentioned. Don't ask me why it isn't there, but
it just isn't.

Any ideas?

By the way, thanks for taking the time to reply, I really appreciate your
help.
 
Scratch that last. I was looking for another folder!

I found it, but the value was already 2. The hexadecimal option button was
selected. Should I change it to decimal? That's thye only other option I have.
 
Back
Top