Still on First Base

[bodpod]

I have a theoretical solution to making a basic form for an Access Database, but how can I create a form from the VB IDE?

The toolbox cannot be selected from the dropdown menu.

I have 3 small tables in the database and am trying to create a form which will enable me to update a total on one of them, but as I say I can't even make the basic form, let alone program it.

Please advise.

 

[RuralGuy]

Can you select Forms on the left side Objects area and then "New"?

 

[bodpod]

Made Form but not Programmable

Hi RuralGuy

Thanks for asking. Yes, I've made the form in the normal Access environment, but when I enter the Visual Basic environment of Access, the project doesn't contain the form I designed.

I just need to make a simple stock recorder that can add or subtract from current quantity of an item. So I need to add a small amount of code to make the form update the table.

The toolbox is also inaccessible. What fundamentally am I missing in my understanding of this Visual Basic environment?

 

[RuralGuy]

The class module of the form is *only* available for editing in design mode. Open the form in design mode and then open the properties sheet for the form and look at the Events tab. If you press the ellipsis button "..." you can bring up the class module for the form with a stub for that event already defined. See if that works.

 

[bodpod]

Form....what Form?

That's the trouble RG...

the form I made in the normal Access window is not accessible in the VBA.

Do I need to own Visual Basic 6 as well as Access?

I have Access 2000. I don't know if that makes a difference. But I don't know about the jargon right now. All I know is that when I programmed some visual basic a few years back in a standalone VB environment, the Toolbox could always be selected from the Toolbar.

But when I open up the VBA in Access the Toolbox is greyed out.

 

[boblarson]

The problem is that you aren't understanding RG.

What he said was,

1. Open the form (in the Access window) in Design mode
2. Click VIEW > PROPERTIES
3. On the EVENT TAB of the form, or a control that you have selected from the dropdown and click on the space next to the event and select EVENT PROCEDURE from the list and then click on the elipsis (...). See pics below:

 

[bodpod]

Progress

Thanks Bob

The visuals did the trick...I'm now at least able to try some visual basic on the form.

Best regards
Brian...aka bodpod

 

[RuralGuy]

Excellent Brian! My thanks to Bob as well.