Click here to Skip to main content
15,922,155 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Copy Append to Clipboard Pin
Mycroft Holmes27-May-09 22:14
professionalMycroft Holmes27-May-09 22:14 
AnswerRe: Copy Append to Clipboard Pin
oikoik14-Jan-10 19:46
oikoik14-Jan-10 19:46 
Questionstart monitor external application problem with shared folder Pin
nico200727-May-09 14:05
nico200727-May-09 14:05 
AnswerRe: start monitor external application problem with shared folder Pin
gsaxena190927-May-09 14:09
gsaxena190927-May-09 14:09 
QuestionNeed a code [modified] Pin
gsaxena190927-May-09 13:53
gsaxena190927-May-09 13:53 
AnswerRe: Need a code Pin
_Damian S_27-May-09 15:32
professional_Damian S_27-May-09 15:32 
GeneralRe: Need a code Pin
gsaxena190927-May-09 23:59
gsaxena190927-May-09 23:59 
Questionproblem with Master-Detail database in VB6 Pin
breikascool27-May-09 13:25
breikascool27-May-09 13:25 
hi there,

I am in a little trouble here. I have a database with employee names details etc.. and I also have a child sub table for their absence. what I want my program to do:

I have a list box that loads full employee names and selects the record
once I click on it I want it to display the info from a child sub table according to the name selected.

I already know how to write to the child sub table but do not know how to display it.
any help would be appreciated.

the code I have written so far fills up the list box with all absence disregarding individual record.



this is what I've written to insert the record into the child sub table. What I want is to display all the things that I add into the list box. some man suggested to have a look at "master-detail" on google but unfortunately the code is too complicated to be able to study it in short time. I need it ASAP as I cannot start doing another piece once this is sorted.

thanks to all people who help Smile | :)
Holidays = txtholiday(0).Text
Sickness = txtSickness(0).Text
Off = txtOff(0).Text
Holidays1 = txtholiday(1).Text
Sickness1 = txtSickness(1).Text
Off1 = txtOff(1).Text
AbsenceID = txtid(0).Text
intDay = cboDays.Text

conConnection.Open

  With cmdCommand
   .ActiveConnection = conConnection
   .CommandText = "SELECT * FROM tblmain WHERE fullname = '" & fullname & "';"
   .CommandType = adCmdText
  End With

  With rstRecordSet
   .CursorType = adOpenStatic
   .CursorLocation = adUseClient
   .LockType = adLockOptimistic
   .Open cmdCommand
  End With
  
  With cmdCommand
   .ActiveConnection = conConnection
   .CommandText = "INSERT into tblAbsence (AbsenceID, Holidays, Sickness, Off, Holidays1, Sickness1, Off1, DaysTaken) Values ('" & AbsenceID & "', '" & Holidays & "', '" & Sickness & "', '" & Off & "', '" & Holidays1 & "', '" & Sickness1 & "', '" & Off1 & "', '" & intDay & "')"

   .CommandType = adCmdText
   .Execute
  End With

Questionaccept a string and convert the case of the characters [modified] Pin
Member 451421827-May-09 10:59
Member 451421827-May-09 10:59 
AnswerRe: accept a string and convert the case of the characters [modified] Pin
EliottA27-May-09 11:11
EliottA27-May-09 11:11 
JokeRe: accept a string and convert the case of the characters Pin
Luc Pattyn27-May-09 12:08
sitebuilderLuc Pattyn27-May-09 12:08 
GeneralRe: accept a string and convert the case of the characters Pin
EliottA27-May-09 12:09
EliottA27-May-09 12:09 
GeneralRe: accept a string and convert the case of the characters Pin
Luc Pattyn27-May-09 12:21
sitebuilderLuc Pattyn27-May-09 12:21 
AnswerRe: accept a string and convert the case of the characters Pin
EliottA27-May-09 11:25
EliottA27-May-09 11:25 
AnswerRe: accept a string and convert the case of the characters Pin
Luc Pattyn27-May-09 11:39
sitebuilderLuc Pattyn27-May-09 11:39 
QuestionDate Design Suggestion... Pin
smjunior0927-May-09 7:36
smjunior0927-May-09 7:36 
AnswerRe: Date Design Suggestion... Pin
Dave Kreskowiak27-May-09 7:46
mveDave Kreskowiak27-May-09 7:46 
GeneralRe: Date Design Suggestion... Pin
smjunior0927-May-09 7:53
smjunior0927-May-09 7:53 
GeneralRe: Date Design Suggestion... Pin
Dave Kreskowiak27-May-09 10:22
mveDave Kreskowiak27-May-09 10:22 
QuestionSubclass a Control by UserControl Pin
Samir Ibrahim27-May-09 6:36
Samir Ibrahim27-May-09 6:36 
AnswerRe: Subclass a Control by UserControl Pin
EliottA27-May-09 7:03
EliottA27-May-09 7:03 
GeneralRe: Subclass a Control by UserControl Pin
Samir Ibrahim27-May-09 21:37
Samir Ibrahim27-May-09 21:37 
AnswerRe: Subclass a Control by UserControl Pin
Dave Kreskowiak27-May-09 7:10
mveDave Kreskowiak27-May-09 7:10 
GeneralRe: Subclass a Control by UserControl Pin
Samir Ibrahim27-May-09 21:36
Samir Ibrahim27-May-09 21:36 
GeneralRe: Subclass a Control by UserControl Pin
Dave Kreskowiak28-May-09 2:19
mveDave Kreskowiak28-May-09 2:19 

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.