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 =...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.