Search results for query: *

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

Hi, I need to run different SQL statement in the same query. And this is what i have coded. Set db = DBEngine(0)(0) strSQL = "Select * from XXX" Set qdf = db.CreateQueryDef("QryApplicant", strSQL) The code execute for the first time, but failed on the second attempts. I...

Hi I'm wondering if Access 2k has CountIF function? For eg, i have a form in tabular format Year | Data ========== Year 1 | Data Year 2 | Data Year 1 | Data Can i use countif to calculate nos record for Year 1?

I would like to know how can i restrict certain user from editing the form. For eg, if the form status = "closed", only the Manager access is allowed to edit. If the form status = "open", everybody can edit. This is what i have written for the access formula but it doesn't...

ANybody has the formula to calculate age based on DOB

Poky, The sendobject doesn't solve my problem. thks for helping