Recent content by Pamy

I'm trying to retrieve userprofile form that matches the email of the current document. If there is no matching email, the system should be able to display a blank form.Below is the coding. However, the code always run to Set uidoc =...

Hi, I would like to create a view that display documents submitted today. This is my formula but not sure if this is correct cos i have a refresh icon at the view header. Please help. SELECT form = "frmMain" & frmsession ="AM" & @Date(frmReportDate) = @Date(@Today)

Hi, I would like to display the date by month using SQL statement but not sure how to write the code. Anybody can give a piece of advise. Thks. EG a list of dates in SQL Server Date: 11/3/03 11/3/03 11/4/03 11/05/03 When executing the code I would like to display in the following format...

Hi, I'm creating a lotus notes application database for my company. And would like everybody to access the database, rather than sending the database link to everyone, can i create hyperlink for the database in a webpage and when my user click on it, it automatically launch the database in...

Thks.. I think i got the solution for converting string to date

hi, What if the data types for the date is Datetime? How should the code be like?

Hi I'm trying to insert date from a form input to SQL.. This is how i wrote the code txtDateValue = Request.Form("datevalue") sql = "INSERT INTO tbTopic(Topic,TopicDesc,TopicDetail,[Date],Venue,[Time],MaxAllowed) values('?','?','?',""'#" & txtDateValue &...

Hi SwampBoogie, My coding works!!!! Thanks for your great advise....

I have tried to current_timestamp. But the date capture is incorrect. For ex..if the current date is 27/2/3, it stored in the database as 1/1/1900...

Hi Kurniadi, Tks for yr prompt reply. But I still having problem after trying out yr example. ================================================ Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'varchar' =================================================== The datatype that...

Hi all, I tried to change the coding to sql = "INSERT INTO tbattendance([User],Email,TopicID,DateSubmitted,Dept) values('?','?','?','?','?')" sql = Replace(sql, "?", Name, 1, 1) sql = Replace(sql, "?", Email, 1, 1) sql = Replace(sql, "?", TopicID, 1, 1)...

Hi, I would like to insert current date (in dd/mm/yyyy)format in the SQL Server. Please teach me how to write the code. sql = "INSERT INTO tbattendance([User],Email,TopicID,DateSubmitted,Dept) values('?','?','?','?','?')" sql = Replace(sql, "?", Name, 1, 1) sql =...

Hi, Is there a way to automatically refresh a page when clicking the back button?

Anybody know any dump site for CLP 510 (Designer)?

Yap