Recent content by tcapp

Thanks I figured it out from a previous post... What I was looking for was sSQL = "select [Assigned To],ClientID,Comments,DueDate,ProjectTitle,RecordID,Resources,Submittal from HotList where duedate between #" & Date & "# and #" & edate & "#" I wasnt using the #

I am trying to select only records for the next seven days. I have added a date in the record using the DTpicker. When using the dateadd function in my SQL statement it gives me a syntax error. Any help is appreciated. Code: edate = DateAdd("d", 7, Date) ' set strings sSQL =...

Added the code and still get the same problem. I can click on a name and it doesnt update. If I double click it works, If I click on another name it shows the previous selection. Its always on record behind

Thanks again Rob.... I was trying to populate text boxes from the grid from a click event my code looks like this: Private Sub DataGrid1_Click() For x = 0 To 15 txtFields(x).Text = DataGrid1.Columns(x).Text txtFields(x).Refresh Next x DataGrid1.Refresh End Sub Unfortunatly for some reason I...

How can you determine the current row and col of a datagrid. Does the datagrid have something like the flexgrids TextMatrix property referencing both col and row?

I have been trying to connect to a datagrid using the following code: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim results As String 'Open Connection Set cn = New ADODB.Connection cn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\vendor1.mdb" cn.Open...

Yes it did help...it gives me a new line of thinking. Im still rewriting the array...My line1, line2, and line3 are Section, Name, and Address. What I'd like to do is have all three in the same column ie. Section Section Name Name...

Hi all, I am creating a small application to to track addresses. I am trying to print two separate columns of data. I cannot seem to find a good reference on printing. My current code prints straight down the center of the page. Any help would be appreciated. Current Code: hwidth =...

I am trying to lock a form with a checkbox to toggle editing on/off to prevent record corruption. I have been using the Recordlocks property but have not been successful in making it work. I would appreciate any idea's or recommendations on another way to make this work.