Click here to Skip to main content
16,006,477 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: search items in Datagridview Pin
Eddy Vluggen26-Jun-10 5:02
professionalEddy Vluggen26-Jun-10 5:02 
GeneralRe: search items in Datagridview Pin
zafax_26-Jun-10 5:09
zafax_26-Jun-10 5:09 
GeneralRe: search items in Datagridview Pin
DaveAuld25-Jun-10 3:05
professionalDaveAuld25-Jun-10 3:05 
AnswerRe: search items in Datagridview Pin
Luc Pattyn25-Jun-10 2:06
sitebuilderLuc Pattyn25-Jun-10 2:06 
GeneralRe: search items in Datagridview Pin
zafax_25-Jun-10 2:39
zafax_25-Jun-10 2:39 
AnswerRe: search items in Datagridview Pin
riced25-Jun-10 2:12
riced25-Jun-10 2:12 
AnswerRe: search items in Datagridview Pin
Аslam Iqbal12-Jul-10 12:20
professionalАslam Iqbal12-Jul-10 12:20 
QuestionDo I need to redesign project tables? Pin
lemarshall24-Jun-10 16:26
lemarshall24-Jun-10 16:26 
Using Visual Studio 2008 and Access 2007

I have tried several different ways to track Material Activity. Table MatActivity has a field for MoveFromGUID and MoveFromType as well as Move2GUID and Move2Type. The possible combinations are: From Well to Well; from Well to StorageYard; from StrorageYard to Well and from StorageYard to StorageYard. I tried it with two tables the Well table and a separate Location table but no luck. There are 4 types of wells so I have tried to add the storageyards into the well table and just use a different code for the welltype to indicate it as a storageyard.
The following code gets me the sample data:
SELECT m.MatActivityID, m.TasksID, m.MoveFromGUID, w.Well, m.MoveFromType, m.Move2GUID, m.Move2Type, m.MaterialsID, m.Units, w.WellID, w.WellType FROM Well  as w INNER JOIN MatActivity as m ON w.WellID =m.MoveFromGUID;

The following code trying to set another relationship from the well table fails to pull any data:
SELECT m.MatActivityID, m.TasksID, m.MoveFromGUID, w.Well, m.MoveFromType, m.Move2GUID, m.Move2Type, m.MaterialsID, m.Units, wWellID, w.WellType FROM Well as w INNER JOIN MatActivity as m ON (w.WellID = MatActivity.Move2GUID) AND (w.WellID = m.MoveFromGUID);

Do I need to change the table MatActivity? It basically is to document from and to locations and the units of each material being moved. There can be anywhere from several hundred units of one type of material to 30-40 types of material with only a couple of units each. It is related to the Tasks table which provides info on the crew to move the material and the dates and time assigned and actually moved. The Material table provides the description of the material to be moved.
If I need to rethink the process and change the entire table structure to be able to show the actual to and from locations and remainder of data now is the time before I get much further into the project. Any suggestions and assistance greatly appreciated
Answerwrong forum Pin
Luc Pattyn25-Jun-10 2:08
sitebuilderLuc Pattyn25-Jun-10 2:08 
AnswerRe: Do I need to redesign project tables? Pin
David Mujica25-Jun-10 5:31
David Mujica25-Jun-10 5:31 
GeneralRe: Do I need to redesign project tables? [modified] Pin
lemarshall25-Jun-10 15:41
lemarshall25-Jun-10 15:41 
QuestionDetermine what device is connect to a com port Pin
Dominick Marciano24-Jun-10 12:33
professionalDominick Marciano24-Jun-10 12:33 
AnswerRe: Determine what device is connect to a com port Pin
Luc Pattyn24-Jun-10 13:00
sitebuilderLuc Pattyn24-Jun-10 13:00 
GeneralRe: Determine what device is connect to a com port Pin
Dominick Marciano24-Jun-10 13:22
professionalDominick Marciano24-Jun-10 13:22 
GeneralRe: Determine what device is connect to a com port Pin
Luc Pattyn24-Jun-10 14:09
sitebuilderLuc Pattyn24-Jun-10 14:09 
QuestionHow to pass values from one window form to another using vb.net Pin
.NetDeveloper0924-Jun-10 11:03
.NetDeveloper0924-Jun-10 11:03 
AnswerRe: How to pass values from one window form to another using vb.net Pin
Wayne Gaylard24-Jun-10 22:03
professionalWayne Gaylard24-Jun-10 22:03 
QuestionRe: How to create a setup file Pin
.NetDeveloper091-Jul-10 21:39
.NetDeveloper091-Jul-10 21:39 
AnswerRe: How to create a setup file Pin
Wayne Gaylard2-Jul-10 0:25
professionalWayne Gaylard2-Jul-10 0:25 
GeneralRe: How to create a setup file Pin
.NetDeveloper092-Jul-10 9:03
.NetDeveloper092-Jul-10 9:03 
Questionshow/hide least significant bits in a bitmap Pin
craig777724-Jun-10 5:41
craig777724-Jun-10 5:41 
AnswerRe: show/hide least significant bits in a bitmap Pin
Luc Pattyn24-Jun-10 6:23
sitebuilderLuc Pattyn24-Jun-10 6:23 
GeneralRe: show/hide least significant bits in a bitmap Pin
craig777724-Jun-10 12:14
craig777724-Jun-10 12:14 
GeneralRe: show/hide least significant bits in a bitmap [modified] Pin
Luc Pattyn24-Jun-10 12:35
sitebuilderLuc Pattyn24-Jun-10 12:35 
GeneralRe: show/hide least significant bits in a bitmap [modified] Pin
craig777725-Jun-10 6:59
craig777725-Jun-10 6:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.