Click here to Skip to main content
15,903,203 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionMultiple forms+Icons Pin
wildfire232326-Jul-06 5:57
wildfire232326-Jul-06 5:57 
QuestionAutomatically adding headers and footers in print documents Pin
wildfire232326-Jul-06 5:52
wildfire232326-Jul-06 5:52 
AnswerRe: Automatically adding headers and footers in print documents Pin
mr_lasseter26-Jul-06 6:08
mr_lasseter26-Jul-06 6:08 
GeneralRe: Automatically adding headers and footers in print documents Pin
wildfire232326-Jul-06 6:15
wildfire232326-Jul-06 6:15 
AnswerRe: Automatically adding headers and footers in print documents Pin
Duncan Edwards Jones26-Jul-06 6:20
professionalDuncan Edwards Jones26-Jul-06 6:20 
GeneralRe: Automatically adding headers and footers in print documents Pin
wildfire232326-Jul-06 9:56
wildfire232326-Jul-06 9:56 
GeneralRe: Automatically adding headers and footers in print documents Pin
Duncan Edwards Jones26-Jul-06 11:42
professionalDuncan Edwards Jones26-Jul-06 11:42 
QuestionDatatable.Select Problem Pin
eatwork26-Jul-06 5:51
eatwork26-Jul-06 5:51 
Hello everyone,
Thank you for viewing my post.
I have a question regarding the Datatable.Select method.
I have a program that stores the tables from the database onto the users computer and keeps them in memory, to reduce trips to the database, and not binding my program to the database, to allow the user to make changes without affecting the data directly on the database. I need to populate a listview from the tables within the user's computer.
<br />
The query in my db is as follows:<br />
Me.lstCommodityPool.RowSource = <br />
  "SELECT commodityId, tbl_Commodity.commodityName " & _<br />
  " IIf(nz(commoditySerialNum,'')='','','(S/N:' & commoditySerialNum & ')') " & _<br />
  " IIf(nz(commodityUnitNum,'')='','',' - ' & commodityUnitNum) " & _<br />
  " IIf(nz(commodityCurrentLSD,'')='','',' - ' & commodityCurrentLSD) AS commodityName " & _<br />
  " FROM tbl_Commodity " & _<br />
  " where  commodityId NOT IN (select quoteCommodityId from join_tbl_Quote_Commodity " & _<br />
  " where quoteId=" & Nz(Me.txtQuoteNum) & _<br />
  " and quoteRevisionId=" & Nz(Me.txtRevNum) & _<br />
  ") and companyId=" & Nz(Me.combCompany) & _<br />
  " order by commodityName"<br />


The question I have is how can I recreate the condition, especially the "NOT IN" clause, using the tables on the users computer? Thank you
NewsCaedo HTTPd Web Server Pin
steve_ino26-Jul-06 5:40
steve_ino26-Jul-06 5:40 
QuestionCrystal reports. Pin
ImranIBM26-Jul-06 5:11
ImranIBM26-Jul-06 5:11 
AnswerRe: Crystal reports. Pin
Muhammad Jawad26-Jul-06 5:50
Muhammad Jawad26-Jul-06 5:50 
GeneralRe: Crystal reports. [modified] Pin
ImranIBM26-Jul-06 6:03
ImranIBM26-Jul-06 6:03 
Questionac Pin
70's live!26-Jul-06 5:08
70's live!26-Jul-06 5:08 
QuestionIcon loading for listviews (.ico files) Pin
Oneiroid26-Jul-06 4:59
Oneiroid26-Jul-06 4:59 
QuestionSave data in a SQL Database Pin
Fitschen26-Jul-06 4:20
Fitschen26-Jul-06 4:20 
QuestionVB 6.0 SEARCHING CODE Pin
michael cheche26-Jul-06 3:02
michael cheche26-Jul-06 3:02 
AnswerRe: VB 6.0 SEARCHING CODE Pin
mr_lasseter26-Jul-06 6:05
mr_lasseter26-Jul-06 6:05 
QuestionLetter pack [modified] Pin
PixelPixie26-Jul-06 2:53
PixelPixie26-Jul-06 2:53 
Questionone to one milion conversion of numbers into words?? Pin
Brian Jay26-Jul-06 2:50
Brian Jay26-Jul-06 2:50 
AnswerRe: one to one milion conversion of numbers into words?? Pin
Dave Sexton26-Jul-06 4:53
Dave Sexton26-Jul-06 4:53 
AnswerRe: one to one milion conversion of numbers into words?? Pin
Nouvand3-Aug-06 23:55
Nouvand3-Aug-06 23:55 
QuestionForm to stay with a MDI Form [modified] Pin
directred26-Jul-06 1:25
directred26-Jul-06 1:25 
AnswerRe: Form to stay with a MDI Form Pin
Zahid Hayat26-Jul-06 2:11
Zahid Hayat26-Jul-06 2:11 
Questionvariable with databinding [modified] Pin
Smithers-Jones26-Jul-06 0:08
Smithers-Jones26-Jul-06 0:08 
AnswerRe: variable with databinding Pin
mr_lasseter26-Jul-06 6:01
mr_lasseter26-Jul-06 6:01 

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.