User Profile

Collapse

Profile Sidebar

Collapse
Frisco Depot
Frisco Depot
Last Activity: May 11 '09, 08:05 AM
Joined: Mar 29 '09
Location: Arkansas
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Frisco Depot
    replied to Table issue
    in Access
    Table Issue

    Hi Jim,
    I think I got it.
    I had to change the Control Source for the AppID field in the second table form to what the query called it and put in a Default Value of the AppID from the first table form.

    Thanks,
    Gregg
    See more | Go to post

      Leave a comment:

    • Frisco Depot
      replied to Table issue
      in Access
      Table Issue

      Hi Jim,
      The query is working fine if the second table already has a record in it for that employee (AppID). If I open the second table form that is based on the query there are no errors and the form accepts the information but does not create a new record in the second table with the new information.

      Thanks,
      Gregg
      See more | Go to post

        Leave a comment:

      • Frisco Depot
        replied to Table issue
        in Access
        Table Issue

        Thanks for your quick reply - am trying that right now.
        See more | Go to post

          Leave a comment:

        • Frisco Depot
          started a topic Table issue
          in Access

          Table issue

          I have a table (Table A) that contains employee records like EmpID, name, address, city, state, zip and the like.
          On the Form for Table A, I need a control button that opens the Form for a second table (Table B) to enter several fields of additional information for the employee that is the current record in Table A's form. Not every employee
          will have additional information.

          Any help will be appreciated.
          See more | Go to post
          • Frisco Depot
            replied to Run-time error '2287': can't open the mail session
            in Access
            Thanks

            Thanks for your reply.
            I will search for a windows mail library that I can reference.
            There was not one listed in references in access.

            Thank you.
            See more | Go to post

              Leave a comment:

            • Frisco Depot
              started a topic Run-time error '2287': can't open the mail session
              in Access

              Run-time error '2287': can't open the mail session

              I have a Run-time error problem on a Vista computer.

              There are two computers involved,

              The first one is Vista Home Premium SP1 with
              Windows Mail Version 6.0.6000.16386 (vista_rtm.0611 01-2205)
              and Access 2000 (9.0.2720) with the following References selected:
              Visual Basic for Applications
              MS Access 9.0 Object Library
              MS DAO 3.6 Object Library
              OLE Automation
              MS ActiveX Data...
              See more | Go to post
              Last edited by Stewart Ross; Mar 30 '09, 10:38 AM. Reason: Corrected code tags by removing additional spaces
              No activity results to display
              Show More
              Working...