I have a database in access that I am trying to pull in and add 1 hour to a specific column [datetime field]. here is what i have so far...
Data1.RecordSou rce = "Select * from [table] where[column]+ #01:00:00 AM#"
Data1.Refresh
error says "date + date not allowed"
any ideas...?
thanks
kbbauman
Last Activity: May 12 '10, 03:43 PM
Joined: Nov 20 '09
Location:
-
add one hour to column in sql via vb6
-
problem solved sorry... i needed to add the y value as a variant -
controlling cells via variable
I do not believe this is a difficult question but I am having trouble figuring out the solution..
I have a dbgrid with a variable amount of rows and 4 columns
I want to take the cell value and copy the value into a spreadsheet using the excel control in vb. I am having difficulties calling the cell via variable
Ex.
Dim X As Integer
Dim XX As Integer
xx = data1.recordset .absolutepositi on... -
Thanks for the help issue resolved
Code:Data1.RecordSource = "Select * from [table] WHERE variable = " & variable & " and [column] Between # " & date1 & " # And # " & date 2& "#" Data1.Refresh
Leave a comment:
-
The data is "truly" write protected..... a large database that I do not have access to change. So, I designed a query off of that table that will let me change the data, but not store the changes obviously.. Thanks for the example I will try this out and let you know if it works.Leave a comment:
-
recordsource >= string in MS Access
Hi,
I was wondering if anyone could possibly help me wih this issue. I have an access database. In this database I have a massive table that I have created a query off of in order to be able to edit the data because the actual data is write protected.
I am trying to search for certain dates in the table that have been input ex. from m/d/yyyy to m/d/yyyy. I would like to run a query that would filter the results for me....
No activity results to display
Leave a comment: