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...

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, 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)?

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

Hi, Can anybody tell me how do i export access table into Excel as individual worksheet? For example, if i have 4 tables, I would like to export them into as single file as 4 individual sheet eg sheet 1, sheet 2 sheet 3 and sheet 4.

I have create a report with the following fields. ProjectID ProjectName ===================== 0701-1 0701 0721-2 0721 M024-5 0782 When i tried to export to Excel, the format becomes ProjectID ProjectName ===================== -437924 0701 -437559 0721 M024-5 0782 Why is this so?

Hi, How can i change the Print Heading from Query Page Setup?

Hi, I have a few tables and i would like to create 1 report for all. The problem is some of the tables have different field as a result, the report generate error "Missing fields". How can i overcome this?

Hi, I need to check for existing table in Access. How should i go about doing this?

Hi anybody know how to create a Export Specification dialog box in MS Access Export Text Specification? I do not want to go throught the Wizard Process again if I need to amend the Specification. Tks

Hi, I would like to run an SQL query to delete all duplicate records in a table. Problem is I can't think of an easy way to do it. Can anyone please enlighten me? Thank you very much!