updating my database
updating my database
updating my database
updating my database
updating my database
updating my database updating my database updating my database updating my database updating my database updating my database updating my database updating my database
updating my database updating my database
updating my database
Go Back  Xtreme Visual Basic Talk > > > updating my database


Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2004, 07:32 AM
grantmchingula grantmchingula is offline
Newcomer
 
Join Date: Mar 2003
Posts: 19
Default updating my database


i have a database which in sql server 2000 and is connected to a vba appliacation software. in this database i have a table which keeps track of the the bonuses for every individual. these bonuses are calculated by the code in the system. of late , i realised that there was a mistake in the calculation of the bonus so much so that it was adding an extra amount to the final bonus.

I have corrected the calculation but my database still holds wrong bonuses.

Is there any way of updating my database with correct bonuses apart from updating individual records

grant
Reply With Quote
  #2  
Old 01-12-2004, 09:07 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Quote:
Originally Posted by grantmchingula
i have a database which in sql server 2000 and is connected to a vba appliacation software...

How "connected" exactly? Are you Automating an Office program such as Excel or Word via VB 6.0 or VB.Net? Or are you writing VBA code within Excel or Word itself?

Also, how are you connecting to your data? Using ADO?

We need to clarify the above in order to know to which sub-forum we should move this post and therefore handle it.

Thanks! ,
Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
updating Access database structure... BPM-SU Database and Reporting 0 04-16-2003 03:59 AM
Updating Online Database eimroda Database and Reporting 6 08-07-2002 01:46 AM
User-defined type not defined (im new) skript_kiddie General 8 06-16-2002 02:06 PM
Updating Database Spoonroom Database and Reporting 1 03-19-2001 09:34 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
updating my database
updating my database
updating my database updating my database
updating my database
updating my database
updating my database updating my database updating my database updating my database updating my database updating my database updating my database
updating my database
updating my database
 
updating my database
updating my database
 
-->