hi to everyone!!!

i'm new in VB programming. my problem is how can i add column field in a table based on range of two DatetimePicker?

for example:

DTPBegin = "02/06/2006"
DTPEnd = "02/08/2006"

result should be:

---------------------------------------------------
  02/06/2006  |  02/07/2006  |  02/08/2006
---------------------------------------------------

thank you in advance...

Hi Russell,
Can you be a bit more specific.
What version of VB are you using VB6, VB.NET 2003(v1.1), VB.NET 2005(v2)
What table do you mean, Access Database table, SQL-Server table, a table on your form
If you mean a database table how are you connecting to it - ADO, DAO, DataEnvironment, ADODC. DataAdapter.



____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Why would you want to do that? One of the rules of database programming is never to store values in a table that can easily be calculated...

____________________________
If you find the answer helpful, please mark this topic as solved.

I think it'd be easier (and have a lot fewer columns), to just have a "date" column, and put in the date in the column, not have a column for the date itself.

to create a column itself (add it to the table), it's similar to:
ALTER [tablename] ADD COL [colname](type size)
ALTER `tablename` ADD COL `colname` type size

but it all depends on the database enging itself...



____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

i'm using VB6 and MS Access database, and the connection is ADODC and ADODB. ADODB on one form only (frmCutOff) and the rest ADODC.

i already solved this problem. but i want to remove the saturday and sunday based on the date range. but the result i get is not correct. can anyone modify my code. thanks in advance.

here is my code:

Private Sub cmdProcess_Click()

Dim cn As ADODB.Connection
Dim strsql As String
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Project\cutoff.mdb;Persist Security Info=False"
cn.Open

Dim d As Integer, i As Integer
Dim begindate  As Date
Dim enddate As Date
begindate = DTPicker1
enddate = DTPicker2
d = DateDiff("d", begindate, enddate)
For i = 0 To d
    If Not (Weekday(i) = vbSaturday) Or Not (Weekday(i) = vbSunday) Then
    strsql = "ALTER TABLE tblrange ADD [" & DateAdd("d", i, begindate) & "] datetime"
     cn.Execute strsql
   End If
Next

End Sub

Change OR to AND.......

____________________________
If you find the answer helpful, please mark this topic as solved.