Search results

I did it with AfterUpdate and it does not catch the event. Can you please help ?

In the Form_Load() Sub I wrote the AddItem() functions for the combobox. I have called the ComboBox Graph. What do I need to put in the Graph_Change() Sub ? Where is the AfterUpdate() event ?

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 ?

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...

I need date , not Date. Access does not support case sensitivity ?

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...

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'...

Not that fast... I rerun the thing again. And instead of 256 for id , I got 25. The id value is still what it should be : 256 Then I add or remove spaces and get the right query. I run again the application and the query string gives me 25 again. This is not deterministic. And so on. I...

I removed 2 blank spaces from the string : 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 & "#"...

Dim sqlSt As String

Sorry for that. Why does the "=" disappear as well ?

Yes, before. On debug I have id = 256 which is expected.

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 = sqlSt & "...

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...

How could I forget it ?

Thanks. I figured it out. What is the problem with the following query : "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 WHERE namespace =...

How do we select a specific Date format field ? i.e Date field is 1/10/2007 Select field1,field2,1/10/2007 Where Condition ?

OK. What about the ID field ?The ID field is field1(autonumbered) and there is no way I can know in advance their values for the inserted rows. Should I do : INSERT INTO TableName( Field2, Field3) SELECT Field2, "SpecificData" FROM TableName WHERE Whatever ?

OK. How do I copy rows ( part of the fields) of a table into the same table and filling the other fields with specific data with a single query?

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...