User Profile

Collapse

Profile Sidebar

Collapse
gurmet
gurmet
Last Activity: Aug 27 '08, 05:28 AM
Joined: Jul 29 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gurmet
    replied to Edit a Record, Check for duplication prior updating to the table
    in Access
    Hi Everybody
    As i have dateline to complete this, i have been searching and chit chat with my friend and found a solution. Just to share with others on how this was resolved:

    (1) Create a query to check

    SELECT s_courses.cours e_id
    FROM s_courses
    WHERE s_courses.cours e_code=Forms!s_ courses_edit!co urse_code And s_courses.cours e_id<>Forms!s_c ourses_edit!cou rse_id;


    (2) Create...
    See more | Go to post

      Leave a comment:

    • gurmet
      started a topic Edit a Record, Check for duplication prior updating to the table
      in Access

      Edit a Record, Check for duplication prior updating to the table

      Hi All

      I have been looking around for help, and finally post this problem.

      I created a form to edit a record. Before i can click save button on the edit form i need to check if the data that have been edit exists in the table. But if i m calling the same record and updating the same record without changing anything it should allowed to save.

      Example: I m creating a table to save all types of courses (course_id,...
      See more | Go to post
      Last edited by gurmet; Aug 27 '08, 01:37 AM. Reason: Show code
      • gurmet
        replied to Adding an Unbound Text Box value to Table
        in Access
        Hi
        Thank you very much it helps me. I m able to save who creates the record by saving the network username and also date/time as when it is created.
        The above info helps me as already got the username and date just did not how to save them into the table, and above steps helps me.

        Thank you very much.
        Regards
        Gurmet
        See more | Go to post

          Leave a comment:

        • gurmet
          replied to Create Access Drop Combo Box to display one table field but save an associated field
          in Access
          Hi Guyz...while waiting ...try to figure it out from your explanation step by step again, and i did was to change the code below becuase my couse_id is first column, course_code was second column,

          Me!course_id = Me!course_id.Co lumn(0)
          and now it works.

          Thank you very much.
          Regards.Gurmet
          See more | Go to post

            Leave a comment:

          • gurmet
            replied to Create Access Drop Combo Box to display one table field but save an associated field
            in Access
            Hi H, NeoPa

            I did what you suggested.
            I m able to view my drop down with the values, which mean just display the course code, the course id did not appear.
            Upon my selection of course code from the dropdown, i get this error message:

            The value you entered isn't valid for this field.
            For example, you may entered text in a numeric field or a number that is larger than then FieldSize setting permi            ...
            See more | Go to post

              Leave a comment:

            • gurmet
              started a topic Create Access Drop Combo Box to display one table field but save an associated field
              in Access

              Create Access Drop Combo Box to display one table field but save an associated field

              I have two tables;

              1. Called "Courses" that contains two fields "Course ID" and "Course Name".

              2. Called "Sessions" that contains a field called "Course ID".

              Then I have a form with a combo box that uses the "Course_Nam e" field for its list and stores the item you select from that list into the "Course ID" field on the "Sessions"...
              See more | Go to post
              No activity results to display
              Show More
              Working...