User Profile

Collapse

Profile Sidebar

Collapse
Anton Melamed
Anton Melamed
Last Activity: Aug 11 '10, 04:52 AM
Joined: Aug 4 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Anton Melamed
    started a topic Please help with database structure
    in Access

    Please help with database structure

    Hi,

    I'm quite new to this and would like to thank you in advance for any help given. It will be greatly appreciated.

    I'm making a database for my shoe store.

    It needs to do the following:

    1. Store suppliers (got it in a separate table)
    2. Store Shoes - brands, styles, fittings, automated barcode etc (got it in separate table also)
    3. Store customers (separate table)
    ...
    See more | Go to post
    • Anton Melamed
      replied to How to use Autonumber & dates to create unique ID
      in Access
      Hi Miranda,

      Create a text box, highlight it and in properties in Data tab in Control Source type:

      Code:
      =Format(Date(),"mmyy") & Format([ID],"000")
      Where "000" is a number of digits used for unique ID added after the date, so if you need a bigger number just use more 0's
      See more | Go to post

        Leave a comment:

      • Anton Melamed
        started a topic adding value from subform field to the field value in the main form
        in Access

        adding value from subform field to the field value in the main form

        Hi,
        I would very much appreciate any help give.
        Im creating database for handling stock of shoes with different sizes and orders.

        I have main form - Stock
        with a subform - Orders

        Each forms have fields with size range (5, 5½, 6, 6½ etc)

        In the main form (Stock) shows size range and number of shoes currently in stock in store for each size.

        In subform (Orders) shown...
        See more | Go to post
        No activity results to display
        Show More
        Working...