Beginners Problem
Nov 2, 2004
Iīm a totally beginner in ASP, and have a problem.
My browser indicate a error in line 4...and I canīt find it.
So if there is anyone who have the answer, would it be great to have it.
<% @LANGUAGE = VBScript %>
<%
Option Explicit
Response.Expires =0 ī in minutes
Dim dtmTime, dtmLater, dtmDiff
dtmTime = Time
dtmLater = DateAdd("h",1,dtmTime)
dtmDiff = DateDiff("h",Now,#1/1/2005#)
%>
<HTML>
<BODY>
Hello Alrun.<BR>
The serverīs time is: <%= dtmTime %>.<BR>
In one hour the serverīs time will be: <%= dtmLater %>.<BR>
<%
If dtmDiff > 0 Then
Response.Write "Still " & dtmDiff & " hours "
Response.Write "to go till year 2005.<BR>" & VbCrLf
Elself dtmDiff < 0 Then
Response.Write "Already " & Abs(dtmDiff) & " hours passed since "
Response.Write "the beginning of the year 2005.<BR>" & VbCrLf
Else
Response.Write "The year 2005 has just begun.<BR>" & VbCrLf
Response.Write "<B>Happy New Year !</B><BR>" & VbCrLf
End if
%>
</BODY>
</HTML>
View Replies
May 20, 2007
I would like to make a report from this query which shows each month and how many bookings were made in each month
(where each date in the picture indicates a booking)
What would be the best way to go about this?
Screenshot of a small part of the query:
http://img104.imageshack.us/img104/6865/queryrtw8.jpg
Thanks:)
View 2 Replies
View Related
Apr 10, 2006
I'm not a programmer by any stretch of the imagination. I'm having an issue I could use a little pro help with.
I have a listbox called "ListDIV" on a form called "fRptCriteria". I am trying to have a query called "qOpenOrds" look to the listbox for some parameters. The field on the query is called "DVNO2Y". The form also contains serveral Calendar Controls "SDate" and "EDate" that the query is looking at too.
In the past, I've had no difficulty referencing a Combo box, but the is listbox issue is driving me nuts!
Thanks in advance.....
View 5 Replies
View Related
Jun 23, 2006
Apologies in advance for the basic nature of this, but in the past two years I have forgotten everything i ever knew!
I have two tables - Holders (holderID, name, current address) and Addresses (addressID, address1, city, etc)
current address is linked to addressID
I am trying to create a form (frmHolders) that shows the details from holders and pulls in the address using a subform (sfrmHolders)
On the main form I have used a combo box for current address so that it can be changed. What I want is for the address on the subform to refresh when the current address is changed in the combo.
I am using this:
Private Sub cboAddress_Change()
Me!sfrmHolders.Requery
End Sub
and it doesnt work
where did i go wrong?
thanks
chancer
View 1 Replies
View Related
Nov 26, 2007
I don't have any database experience whatsoever so please go easy.
I'm guessing this kind of this is extremely simple for all of you.
I'm constructing a database of network resources and devices and I'd like to automatically update the values in one field based on the values of a field in another table.
The first table is called "IP" and the fields are called "Address", "IP Type" and "Device".
The second table is called "Devices" and contains the fields "Name", "Description", "Asset Number" and "IP".
Here's an example of the tables: (ignore the "code" tag. i've only used it to align my columns properly)
DEVICES:
NameDescriptionAssetIP
XserveFile Server107203.30.144.75
ProliantXDHCP119203.30.144.15
IP:
AddressIP TypeDevice
203.30.144.75Static
203.30.144.15Static
What I want is for the Device field in the IP table to automatically update it's values based on the values found in the Devices table. In this case, the values that should appear in the Device field in the IP table are "Xserve" and "ProliantX".
I've searched through but haven't found a complete solution, just little pieces which I'm too inexperienced to put together myself.
thank you
-Tim
View 2 Replies
View Related
