Search results

  1. A

    Help with ComboBox

    How do we do in VB so that a user can select an item from a ComBoBox and that the event fired by the item selected execute a certain code ?
  2. A

    Access to Excel 2007 curious behavior

    I have written an application that worked fine with Excel 2003. I have upgraded to Excel 2007 and some problems occur when translating Access tables into Excel charts. Here is the sample of code of that worked fine with Excel 2003 : Dim Excel As Excel.Application Set Excel = New...
  3. A

    Query problem

    The following query does not work since it does not accept "AS date". Why ? It accepts AS RunID : SELECT 257 AS RunID, RawData.fullName, RawData.name, RawData.category, RawData.type, RawData.subType, RawData.numberOfLines, RawData.dataType, RawData.virtual, #1/3/2007# AS date...
  4. A

    syntax error in Insert Into statement

    What is the syntax error in this Insert Into statement ? INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace) SELECT 257 ,fullName,name,category,type,subType,numberOfLines,virtual,#1/3/2007#,namespace FROM RawData WHERE namespace ='customer.demo'...
  5. A

    query string mystery

    sqlSt = "" sqlSt = sqlSt & "INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace)" sqlSt = sqlSt & " SELECT " & RunID & " ,fullName,name,category,type,subType,numberOfLines,virtual," & "#" & d & "#" & ",namespace FROM RawData " sqlSt...
  6. A

    Query Help :copying rows

    Hi , I need to copy rows from a table to a specific location in the same table. I suppose that it is possible to copy rows from a table to the same table as followed : INSERT INTO Table SELECT * FROM Table WHERE Condition How can I insert into a specific location based on another...
Top Bottom