Question Locked

How to compare text in a text box with a field in an access table in vb6

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hey
I have a problem. I have an access table having fields GroupName, Jan,Feb......Dec. I have a vb form having a text box in which i enter the group name and i need to connect it to a field GroupName in the access table. I need to compare it to the various group names in the field and then connect to the requird Group Name. Then there is another text box that contains Month. I then need to compare the months corresponding to the Group Name. I am Struck at this stage...I am new to vb and don't know much...I need an urgent help!!!!

2 replies

by tony hopkinson

First things first.

Google

VB6 ADO Access

Any help I gave you after this would at the moment be a total guess as I can't for the life of me, make sense out of what you are saying you want to do...

One definite reason you might be struggling is the table structure you are using.

If you want to pick out months for a group, it should be

Groups
GroupID, GroupName

Months
GroupID, Month, Value

That way you can 'compare' months for a group, or a month for several groups with very simple queries.

This discussion is closed to new replies.