How to access design view and VBA code

[abrogard]

After 10 years of not using Access I want to get started again.



I pulled up an old prog I'd written in Access in 2000 and my current Access 2007 converted it.

Then I found myself looking at it and unable to 'get into' it.

I mean I couldn't put it into design view or find a way to look at the procedure list, the code.

This was an .mdb file. It was converted to an .accdb file

Is there some way I can get it to where I can work on it?

I want to do that because I think it is the quickest way to get up to speed again... read my old code, see what I did and how I did it....

But perhaps you'd say it's best to start from scratch... things have changed that much?

[pbaldy]

The interface changed a lot, with the Navigation Pane and Ribbon, but a lot is the same. F11 should open the Navigation Pane, and Alt-F11 should open the VBA editor.

I'm also going to change the thread title to something more meaningful.

[abrogard]

Okay, thanks for that. I will try it.

Sure, change the title. You've got a point there, I should have thought of it. Sorry. Thinking of myself more than the forum.

'wino' moderator as in 'wine' or as in 'windows' ?

[pbaldy]

No problem, and welcome to the site! Post back if you get stuck.

Wino as in Cabernet, which I just shared a bottle of at dinner.

[abrogard]

Somehow I thought it might... Shiraz Cabernet, coincidentally, happens to be my favourite tipple...



Hmmm.... it doesn't work...

The prog I'm trying to use was a fairly trivial thing which is why I wanted to start with it. It is less than 1M in size. It is a quiz/questionnaire type thing.

If you think I'm doing something wrong I could send it to you to see for yourself.

It opens up. One can use it - how successfully I'm not sure, I don't remember if it ever worked properly or not.. I know it was never really finished. But you can't get at the workings of it. Or I can't.

[alansidman]

Try opening the db first by holding down the shift key and the enter key simultaneously when launching it. Once it opens, then try Paul's suggestions. You may have locked it down

[pbaldy]

Ah, you edited your post after I read it. Sure, you can post it here if you can't get into it.

[abrogard]

Yes, that seems to work. It opens with a side 'navigation' bar listing all objects. Open the code module and it opens in a 'design' window. Has the sidebar but nothing at all showing in the main window. The icon to change views greyed out.
Don't need the F11. If I use it the sidebar disappears, use it again it comes back. It seems to toggle that sidebar.

Prog opens with a warning about something disabled and it turns out to be a VBA macro. If I enable it we jump immediately to the opening form view and the sidebar disappears and I'm back where I was: locked out.

So maybe that macro is what is locking me out? Need to find it and delete it?

After jumping around a bit, opening this and that and the other I find the 'view' icon working again... don't know what I do/did that made that happen.

Long story short: I can now get at it. That's the main thing. Thanks a lot.

[pbaldy]

If there's a macro running when the db starts, it would be likely be named "autoexec".