VB linked to Database

Daniellawson

Board Regular
Joined
Oct 9, 2002
Messages
61
I have made a re-mark database with Headings such as, Candidate Name, Candidate number, Reference code , Grade, re-mark grade etc..

I have used LOOKUP functions so that when a re-mark 'mark' is typed in it shows a new grade in the 'Re-mark Grade column'.

Oh yes and an IF function to tell me whether there has been a grade change or not.

Simple enough but the problem comes when i want to make this into a Visual Basic program,

How can i make it so that i can have input fields to input the re-mark mark and it will show the grade in a box somewhere on the VB program..

So really under all this waffle, im trying to link my database to a VB program so it is much easyer to work :)

any help is appreciated thanks!!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I assume you have a UserForm to edit your database.

You can use worksheet functions in VBA. In the Change event code for your re-mark text box lookup its value in your database and assign the result to your grade text box.

Post back if you need more help.
 

Daniellawson

Board Regular
Joined
Oct 9, 2002
Messages
61
Im not too good with VB do you have any tutorials on this or can guide a newbie ??

thank you
 
L

Legacy 98055

Guest
<pre>
Hi Daniel.

Just wanted to clear up a few things. There's a marked difference, to say the least,
betwixt VB and VBA. Which one are you speaking of?

Also, seeing that you are a new member of this board and have just tapped into a wealth
of help and knowledge, to help you along, provide more details pertaining to your project.
Somebody here, doubtless, has conquered a similiar project.

Note the link at the bottom of your screen.
"Colo's utility to display your worksheet on this board." An excellent tool for
communicating your objective. It is a free, no hassle download.

Also, are you set on using VB or VBA for your project? Excel has built in "Database and
List Management functions". Search Excel help for the same in quotes.

Sounds like a fairly simple project. The more details you provide, the more interest your
post will draw.

Tom
</pre>
 

Forum statistics

Threads
1,143,615
Messages
5,719,721
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top