Call Logger in VB6

[RedTen]

Hi,

Id like to create a program that allows me to log calls at work quickly and easily. Mainly as i have a terrible memory and it allows me to learn some script.

I would like to be able to type in quickly the users extension number (the person calling me) which would then look up their name and location.

Eg. Ex 8555 Name: Helpdesk Location: Floor 4.

I have this data already in an excel spreadsheet.

Would it be possible to take this data and put it into a database to use with VB6. I would like to view and ammend previous call logs. Id like to include details such as time, server no., application used and a note section with brief explanation.

If anyone could point me in the right direction guide wise or resources to help it would be appreciated. Bare in mind i have no experience in VB6 or creating programs but im able to pick things up well.

Thanks!

 

[SimonCHere]

Yep it can be done.
Any particular reason for VB6 though? If you're starting new, try C# or vb.Net using the free (express) development tools from microsoft.

Simon

 

[RedTen]

No idea why i said v6.

Ignore that, ive downloaded the express edition. Any reccomendations where to start?

What do i create the database with?

Thanks

 

[SimonCHere]

Microsoft SQL2008(?) express edition!

Start with the database. A couple of table and work out the code needed to add, update, delete and view record.

You can load your data from the spreadsheet into a table to do the lookups from.

Simon