Search:

Ok I created the module. I'm really new at this so this may sound dump now how to I i corperate that fuction ito my SQL statment.

I have a database that gets allot of date and times but all of the are in UTC time. How do I convert the date/times into regular date and time format (central time)? The database is a MS access...

Nevermind it is just If (thedate) = "09:30" Or "10:00". That was easy.

I have this if statment which works good but how do I add to the criteria. For example If (thedate) = "09:30" or 10:00 or 11:00 or 12:00 Then. This probably easy but I am a newbe:)


Private Sub...

Thanks for the reply. I am trying to do this is MS access and it doesnt seem to reconize these commands. How would I do it? in Visual Basics? Thanks for replying to my origional email.

not sure how to do this but I want to create a quiry that is run only if a value is = to.

for example

select field1, field2
case
if field 1 = 90
then do this query
else
case

I wrote the following SQL in MS access
Code:
SELECT talleyhalfhour.STATE_CODE_3, Count(talleyhalfhour.STATE_CODE_3) AS [COUNT], TIM.L4_DESC

FROM talleyhalfhour, TIM

WHERE...

I wrote the following SQL in access
SELECT talleyhalfhour.STATE_CODE_3, Count(talleyhalfhour.STATE_CODE_3) AS [COUNT], TIM.L4_DESC

FROM talleyhalfhour, TIM

WHERE...

any ideas

I am having a problem with sharepoint. I am trying to display some data from a database. When I do a simple query it works perfect and the information displays. When I add a (Where) clause to the...

Anyone have any info on this?

any ideas on this??

I think I did it wrong this is what I have now. [CODE] <script type="text/javascript">
function negRed( Mytable ) /* Apply red bg to cells containing negative numbers */
{
...

Yes it is a time in the cell so anything more than 2:00 minuites

I guess I should explain my code better. This makes the bg change if the number in the table is less than zero. All i am trying to do is change the bg color if the value is more than 02:00. Any ideas?

I have the following code.
<script type="text/javascript">
function negRed( Mytable ) /* Apply red bg to cells containing negative numbers */
{
var...

I contacted the administrator and he said that it will be using Windows intergrated Security instead on Anonymous access. Now Im not sure how the change my database connection to conform to these...

I have a web site and it allows Anonymous access to our databases. I spoke with the administrator and he said that they will not be allowing Anonymous access to the databases any longer. He said this...

Thanks for the reply I got it to work with the following code
<script type="text/javascript">
function disableRadioGroups() {
var form = document.getElementById("Form2");
var Jan1 =...

Ahat I am trying to do is I have a text box that is populated on load. What I want to do is if that text box is = to A then I want the box next to it to be disabled if it is not then it is not...

No its is not and acceptance but thanks for the reply

Im sorry what I am trying to do is I have a box that is populated on load. What I want to do is if that box is = to A then I want the box next to it to be disabled if it is not then it is not...

How do I disable a radio if a text box named Jul = "A". Thanks in advance for any help you can give.

Your right my second post doesnt make sense. I was able to get it to work with the query. Thanks for all your help.

Im sorry here is my from with my radio buttons.
<form id="form2" name="form2"> <input type="radio" name="715" value="Yes" />
Yes</label>
<br />
<label>
...