Search results

Hi, I am wondering if any one could help me out with the problem below. Main page: <%if Request("Err")="ERR_USERNAME" then %> <font color="#FF0000">This record is already in the database and cannot be added. Please try again.</font> <%end if%> Action page: Response.Redirect...

Hi, thank you. i got it =p

Hi, in my web page, i would like to user to see a ticked checkbox should the database = True however, i cannot seems to be getting it. Would anybody be able to help me out? strSQL = "SELECT DeptHeadA FROM Employee WHERE EmpId = '" & strEmpId & "'" nRecDHA = GetRecordset(strSQL, arrDHA) if...

Hi, I have a webpage which shows some results upon executing some SQL statements. However, i will met with some problems when the SQL statements return a NULL value therefore i would like to do some error checking such that when the SQL statement returns NULL, i will direct the user to another...

Oh no.. design flaw.. okok.. here is my table structure: 1) Employee ID 2) Name 3) Division 4) Department 5) Section 6) SectionII 7) SectionIII 8) Office Num 9) Mobile Num 10) Role Each employee will have to be in one division, one department and one section and playing one role. However, only...

Hi, i have a database containing employees' information. Each employee will belong to one division, one department and up to 3 sections. My tables are named div, dept, sect, sectII, sectIII. In my report, i would like to see the employee contact numbers group according to the sections. As such...

Hi, i am developing a website and in it, i would like to allow them to print the webpage but without the header, footer, as well as to set the default printing layout to be landscape and not protrait. Does anyone know how i may go about doing it? Do i change the css? Thank you.

Hi, in my dropdown box options, there are department names such as English, Maths, Science, Chinese, Music, PE etc. The primary key for this table is autonumber. I would like to allow these different Department to add Sections. However, when i allow my user to select from a dropdown list of...

Hi, I am doing up a webpage which has a dropdown box with 13 choices(13 different department names eg. A, B, C..) to allow user to insert into database. However, instead of inserting just "department name", it insert "department name," into the database. Eg. What i want to see in database is...

Hi, i would like to return information in the below format but not very sure how it is to be done. Role, Name, ID, Contact Number Z, Mary, 05, 1234567 , Matt, 02, 2233445 A, Bob, 10, 7654321 C, Tammy, 11, 9988776 and the order of Role (Z,A,C) is fixed it has to be in this order and if Role Z...

Hi, I am having some troubles with the syntax of my SQL statement to fit them into a certain layout. Would appreciate if anyone can provide me with advise. In my database, i have 5 fields ( nameid, name, number, section, role) Each person is only assign 1 role(A, B or C). In my webpage, the...

Hi, I would like to display records on a webpage and am unsure of the query statement and would like to seek some advise. I have a lists of contact numbers(home, mobile) and they are from various Sports groups and different teams. Captains from the different sports group will be able to view the...

Hi, I am currently developing a web application which will need to connect to a password protected Access database. Password which i set is "haha". Below is the code which I had set for the connection part but it is returning me error saying that is is an invalid password. Is there anything...