User Profile

Collapse

Profile Sidebar

Collapse
extrym
extrym
Last Activity: Jun 16 '10, 02:47 AM
Joined: Jan 30 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • extrym
    replied to Error with command button which opens form to specific record
    in Access
    @ADezii
    the same error appears again...

    @gnawoncents
    yes, they're two seperate tables. The staff_ID is actually a field in the Staff table. The staff_ID field in the Security table is just a lookup of the original staff_ID.

    * edit *

    Okay, I've solved it! I used a few macros to get the job done:
    Macro name
    Macro6
    • OnError
      • Macro Name. Macro8
    • RunCommand
      • SaveRecord
    • OpenForm
      • Security،
    ...
    See more | Go to post

      Leave a comment:

    • extrym
      started a topic Error with command button which opens form to specific record
      in Access

      Error with command button which opens form to specific record

      I have 2 forms, "Staff" and "Security" (without the ""'s). The Staff form has the following fields:
      staff_ID
      staff_name
      staff_number
      staff_DOB
      priority

      The Security form contains the following fields:
      staff_ID
      staff_pass
      priority

      The staff_ID fields in both forms are linked by a one-to-one relationship.
      I have a command button...
      See more | Go to post
      • extrym
        replied to Generate value in textbox based on combobox selection
        in Access
        It worked! I used (3) for the third column before, so that was the problem.
        Thanks for replying, Nico!
        See more | Go to post

          Leave a comment:

        • extrym
          started a topic Generate value in textbox based on combobox selection
          in Access

          Generate value in textbox based on combobox selection

          I created a product sales database which contains 4 tables. Two of those tables are Normal Transactions and Item.

          Normal Transactions
          normal_trans_ID
          item_ID
          item_qty
          item_cost
          total_cost
          item_date
          staff_ID

          Item
          item_ID
          item_name
          item_cost

          I've used the Lookup function for item_ID (in the table Normal Transactions) so that it displays...
          See more | Go to post
          No activity results to display
          Show More
          Working...