Solved

unboubd field in a bound DBGRID

Posted on 1998-08-21
4
252 Views
Last Modified: 2010-04-30
I am using oracle as a backend.  I have a table (item_trn) with 3 columns (item_no, no_of_item, value). i have bound this table to a DBgrid. But I want to also display the item_name from table item_master.(item_trn and item_master are related by their item_no). Also I want to update and add data to these two tables using DBgrid. I have one Unbound column in the DBGRID (i.e the item_name coming from item_master) Whenever the new row is invoked the item_name vanishes from the Grid. What could be the problem ?
0
Comment
Question by:bumble420
  • 2
  • 2
4 Comments
 

Author Comment

by:bumble420
ID: 1430210
Urgent
0
 
LVL 6

Accepted Solution

by:
clifABB earned 50 total points
ID: 1430211
You have to manually refresh the unbound cells of a grid.
You do this in the UnboundReadData Event (see help file).
0
 

Author Comment

by:bumble420
ID: 1430212
I am new to VB 5 and am not able to find the code. Could you please guide me ?
Thanks a lot for your guidance.



0
 
LVL 6

Expert Comment

by:clifABB
ID: 1430213
Place the code that fills the unbound cells in the grid's UnboundReadData event.  Check the help file for information and an example.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now