G
Guest
I know several of you are tired of hearing about my vehicle database but bear
with me, I'm almost finished.
I have decieded to add a couple of buttons to my data entry form that will
go to certain records when data is plugged in. For example, I have a button
that I have named "Find by Unit". This button was made using the command
button option in design view so it uses the standard pop-up screen to find
the record that I want (I enter the unit number and it is set to look in the
"Unit" column). This does exactly what I want it to do. When I try to make
another button just like it to search by VIN I have to tell this button to
look in the entire "vehicle" table. When I make the change to this button's
options in that pop-up window it will change the first button's options as
well. I know I probably need to change something/ write something in the
Visual Basic but I know NOTHING about that. Any ideas on where I can learn
enough to make this database do what I want? I'm learning as I go. Going by
what I see in the Visual Basic that comes up for each button, I can't see
where I would put ianything in to tell it to look in another column. Is
there a better way to do this?
The whole reason that I need both of these buttons is so that 1) I can
search by VIN using the number off of the renewal card when it comes in and
2) Search by Unit number when the registrations come back in (our County
Clerk is nice enough to put our unit numbers on the registration if we've
written it on the renewal card....which we do)
Again, this is my last piece to the puzzle that I call my database that I
can see that I need. Any help would be greatly appreciated, please keep in
mind that I am greener than green when it comes to Visual Basic.
THANKS!! (Sorry if this is long, just wanted to be as clear as possible)
with me, I'm almost finished.
I have decieded to add a couple of buttons to my data entry form that will
go to certain records when data is plugged in. For example, I have a button
that I have named "Find by Unit". This button was made using the command
button option in design view so it uses the standard pop-up screen to find
the record that I want (I enter the unit number and it is set to look in the
"Unit" column). This does exactly what I want it to do. When I try to make
another button just like it to search by VIN I have to tell this button to
look in the entire "vehicle" table. When I make the change to this button's
options in that pop-up window it will change the first button's options as
well. I know I probably need to change something/ write something in the
Visual Basic but I know NOTHING about that. Any ideas on where I can learn
enough to make this database do what I want? I'm learning as I go. Going by
what I see in the Visual Basic that comes up for each button, I can't see
where I would put ianything in to tell it to look in another column. Is
there a better way to do this?
The whole reason that I need both of these buttons is so that 1) I can
search by VIN using the number off of the renewal card when it comes in and
2) Search by Unit number when the registrations come back in (our County
Clerk is nice enough to put our unit numbers on the registration if we've
written it on the renewal card....which we do)
Again, this is my last piece to the puzzle that I call my database that I
can see that I need. Any help would be greatly appreciated, please keep in
mind that I am greener than green when it comes to Visual Basic.
THANKS!! (Sorry if this is long, just wanted to be as clear as possible)