User Profile

Collapse

Profile Sidebar

Collapse
Papote
Papote
Last Activity: Dec 22 '09, 06:42 PM
Joined: Sep 26 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Papote
    started a topic Dlookup alternative
    in Access

    Dlookup alternative

    I am looking for a simple dlookup alternative that would return ONE value to a textbox from a query that is compatible with SQL Server 2005.
    Access will be the front end and the database will run in SQL 2005.
    See more | Go to post
    • Papote
      replied to Relationship problem when inserting records
      in Access
      I managed to to do this via code. A couple of Ifs and dlookups. Works pretty good controlling the the records that need be created.

      I am worried that when I upsize to MS SQL Server 2005, that the Dlookups won't work.
      See more | Go to post

        Leave a comment:

      • Papote
        started a topic Subdatasheet to Form
        in Access

        Subdatasheet to Form

        I have a Food Menu ordering database. There is a daily menu and in that menu one can order any amount of food in that particular menu.
        I have these two tables where I want to create a form to enter the quantity.

        MenuItems (Table)
        MenuItemsID (PK)
        FoodID (FK from Food Table)
        MenuDayID (FK)

        Order (Table)
        OrderID (PK)
        MenuItemsID
        CutomerID (At the moment...
        See more | Go to post
        • Papote
          replied to Relationship problem when inserting records
          in Access
          This is what I originally had.
          zshare.net/download/19770145d4f6257 a/
          Pass:tester0001 .?
          Some items are in spanish...

          I include a working version of the form used to enter / view the menu MenuByCycleEntr y.

          I wanted the subforms to link like the MenuByCycle table nested sub-datasheets upto ordering by institution per food menu item.

          There are 13 different types of diets for each day....
          See more | Go to post

            Leave a comment:

          • Papote
            replied to Relationship problem when inserting records
            in Access
            The retreived fields aren't PKs. Only in the Order by clause.
            I have retrieve the fields CycleID and Year from MenuByCycle table and Day from MenuByDay table to make a where statement it shouldn't appear in the end query. I am missing the MenuByDietID field from MenuByDiet table....
            See more | Go to post

              Leave a comment:

            • Papote
              started a topic Relationship problem when inserting records
              in Access

              Relationship problem when inserting records

              I am making a menu ordering system.

              These are the main tables:
              MenuByCycle
              MenuByCycleID (PK)
              Year
              CycleID

              MenuByDay
              MenuByDayID
              Day
              MenuByCycleID (FK to MenuByCycle)

              MenuByDiet
              MenuByDietID
              TypeOfDietID (PK)
              MenuByDayID (PK, also a FK to MenuByDay Table)

              FoodPerMenu
              FoodByMenuID (PK)
              MenuByDietID (FK to...
              See more | Go to post
              • Papote
                started a topic Link unbound form to bound form
                in Access

                Link unbound form to bound form

                I have a database that in Table form it shows the subdatasheets that make refrence to the main table. It is basically a Menu ordering system. Goes something like this:
                MenuByCycle (Contains: Cycle and year), MenuByDay (Contains: Day), MenuByDiet (Contains: TypeOfDiets), FoodItemsByMenu (The actual menu items)
                That was my best attempt to normalize the database.
                Like I said in the beginning, in Table subdatasheet form I can view...
                See more | Go to post
                No activity results to display
                Show More
                Working...