Using nw table field in VB

[oldtimer99]

VB program (access) use to schedule students for career day. Added check box for 6 grade (already has 1-5). VB does not allow use of it. Not in object list. How do I add it to list so it can be used in pgm. I am network engineer and lost

 

[JoseMarques]

Do you use some kind of code?
Do you use 6 check boxes or one group of check boxes?

 

[dhookom]

As was mentioned in another thread, your table structure isn't normalized if you are adding columns. It's your program so you will have to live with the maintenance consequences.

Are you really using VB? If so as JoseMarques suggests, you need to share the code and possibly the table structure and connection information.


Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

BTW, "VB program (access)" is NOT a VB, it is a VBA Visual Basic for Apllication. There are enough differences between VB and VBA, so you should state which language you use.

Have fun.

---- Andy

 

[oldtimer99]

OK,
Thank you for the help. There are three tables grade,presenter,presenter-shedule
each have three fields grade1access,grade2access grade3access,grade4access,grade5access.

I use 6 check boxes

I have add grade6access to each. I did not desgn this db and are just trying to help school (for free). They want to add the six grade to the program.The following code will not compile;

Me.Grade5Share.Enabled = True
get compile error 'Methed or data member not found'
Can fid propeties for other grades' access, but not for this.

 

[dhookom]

oldtimer99,
I appreciate your offer to help the school. Thanks.

However, you mention "three fields" but provide five field names. Also, you have never identified exactly if this is strictly MS Access or if it is Visual Basic.

Do you have a control named "Grade5Share"? This is a control, not a field. Did you get the error on "Grade5Share" or possibly "Grade6Share"?

Why "Share" and not "access"?

Duane
Hook'D on Access
MS Access MVP

 

[oldtimer99]

However, you mention "three fields" but provide five field names. Also, you have never identified exactly if this is strictly MS Access or if it is Visual Basic.

Do you have a control named "Grade5Share"? This is a control, not a field. Did you get the error on "Grade5Share" or possibly "Grade6Share"?

Why "Share" and not "access"?

It is 3 tables
5 fields each

I do think it my be a control, not sure how to find out.

Got Error on Grade6Share
Do not know why this is "Share" and not "Access" Did not create this pgm/DB and those who did are not around.

 

[dhookom]

Again, are you using any application other than MS Access? Are your forms MS Access? Can you share your full code that sets the Enabled properties?

Duane
Hook'D on Access
MS Access MVP

 

[oldtimer99]

I am using only MS access. Yes the forms are MS Access Do not know how to find code that sets the Enabled properties

 

[dhookom]

How did you find

The following code will not compile
Me.Grade5Share.Enabled = True

While in design view of a form, open the Properties dialog. Then click on the little square to the left and top of the rulers. This should display the form properties. You can then look at the event properties for [Event Procedure] with a [...] button to view the code.

Duane
Hook'D on Access
MS Access MVP

 

[oldtimer99]

I have done so. Added Me.Grade6Share = True
and all other references to Grade6Share just like it was for the other grades.

Did so in two places like other grades
Still get the same compile error

 

[Andrzejek]

Just a guess here, but it may be a bound control

Have fun.

---- Andy

 

[dhookom]

Added Me.Grade6Share = True

Shouldn't this be

Added Me.Grade6Share[b][COLOR=red].Enabled[/color][/b] = True

Do you see these controls on your form while in design mode?

Duane
Hook'D on Access
MS Access MVP

 

[oldtimer99]

Quote (oldtimer99)
Added Me.Grade6Share = True
Shouldn't this be

CODE --> vba
Added Me.Grade6Share.Enabled = True




Yes it is.

Do not see Me.Grade6Share=Enable in the form. I looked in properties and see only Grae6Shre under ConrolSource. Am I looking in wreong place/

 

[oldtimer99]

I looked in properties and see only Grae6Share under ConrolSource. Am I looking in wrong place?

Sorry for bad typing

 

[oldtimer99]

Do not see Me.Grade6Share=Enable in the form. No I looked in properties and see only Grae6Share under ConrolSource. Am I looking in wrong place?

Sorry for bad typing

 

[dhookom]

If you don't see a control named "Grade6Share" then you can't reference it in code without getting the error you are getting.

Duane
Hook'D on Access
MS Access MVP

 

[oldtimer99]

Can I add it. If so, how do I do so?

 

[dhookom]

Sorry but you have a fair amount of learning ahead. I don't think this is the best place for someone to step you through basics. Consider finding a basic book and/or checking out Crystal's Access Tutorials.

Duane
Hook'D on Access
MS Access MVP

 

[oldtimer99]

Thank You very much! Now I know what I need to do. I will be able to buy a book or check out the website.

Thanks Again

gary