How to connect my vb system pay slip in ms access 2007?

Asked By Janet Campbel 90 points N/A Posted on - 12/23/2012

Hi guys,

How to connect my vb system pay slip in ms access 2007? A step by step instruction will really help me a lot or any visualization or illustration is much better. I have to submit this next month and defend the software application together with the documentation. I am done with the Gui all I have to do is to connect it immediately.

Expecting some help, thank you.

• Status: Open
• Question Views: 1049
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Barbara Miller 0 points N/A #165007

How to connect my vb system pay slip in ms access 2007?

Hello Janet Campbel,

You can connect Visual Basic to Microsoft Access via coding. The ADODB object is needed to create a link to the database and gain access to the records using ADODB.connection and ADODB.recordset APIs. SQL is needed to search the database for records that equals the information provided as parameters to the subroutines. I have written the code in Notepad and attached it to this message, please try it out.

About Barbara Miller

Questions
0

Answers
101

Best Answers
46

• Vote Up 0 Vote Down

• Posted on - 01/24/2013
• Question Category: MS Access