Recent content by DKY

As I just posted on the other thread:

Is there something other than string that I can use to make the variable two digits minimum? It is involved in a loop and increments by one every time but when it's in the 1, 2,3 stage I would like it to display 01,02,03.

putting the public before the Option Explicit and Optoin Compare Database works, thanks!

I'm trying to use public to declare a variable called 'NewStep' instead of dim. Here's the beginning of my code: Option Compare Database Option Explicit Public Function CopyFilesFromR() Dim strYourDestination As String, strFiles As String, strPath As String, StepTotal As String Public NewStep...

same here. Does anyone know of a way around this?

so, you tried it on your microsoft access and it doesnt work for you either?

I'm not sure what you mean by 'internal representation' I want it to put a leading zero in the hour when its less than 10, just like it does with the minutes and the seconds. Since it does it for them, I dont understand why it doesnt do it for the hour. Not sure how to use the FORMAT...

this was an asp issue. case closed.

I set my format for my date/time to hh for the double digit hours and it displays 7 instead of 07. What am I missing here?

k, I looked into this and found out that when I put the value in access to Now() it works fine. Problem is, I want the date and time that the form was submitted and then I also want the date and time for other things so the now will work for this one, but later when I try and put the date and...

Did I mention that I never used access before? HAHAHAAA. How do I do that?

not sure how to use that, is that asp?

that doesnt work and neither do double quotes

so, like this? INSERT INTO hotlines(date_time_opened) VALUES('#3/17/2005 4:02:05 PM#')

AAHHHAAA!!! ...... you lost me. LOL. I'm not sure that I am giving access the syntax it needs to recognize that the text string being presented to it should be interpreted as a date cause I dont know what that means. My sql statement (when I do a response.write on the screen) looks like so...