Suneido

Integrated Application Platform

  • Home
  • Learning
    • Suneido Manual
    • Beginners
      • Inside Suneido
      • The Suneido Programming Language
      • The Suneido Database
      • Installing Suneido
      • Building Suneido
      • IDE Go To Tour
      • Upgrading To A New Release
    • Advanced
      • Canvas Control
      • DrawControl Part 1
      • DrawControl Part 2
      • DrawControl Part 3
      • SAX Like XML Processing
      • A Plug-In Architecture
      • A Simple Wizard Framework
      • An HTML Include Facility
      • An RSS 2 Feed Creator
      • MIME Generation
      • A New Add-on Facility
      • Workspace Improvement Hack
    • Mockito for Suneido
    • The Suneido Task Scheduler
    • Contributing To Suneido
    • Contributor Assignment of Copyright
    • Language Translation
    • Future Directions
    • Interview With Andrew Mckinlay
  • Forum
    • Announcements
    • Internals & Enhancements
    • Cookbook
    • General
  • FAQ
  • Screenshots
  • Downloads
  • Links

Access help

Integrated Application Platform › Forums › General › Access help

  • This topic has 1 reply, 2 voices, and was last updated 11 years, 3 months ago by j_ferguson.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • October 19, 2011 at 6:09 pm #715
    Anonymous
    Inactive

    Hello. Its me again. I have a small prob with my assess and browse. Here is my code:

    #(Access ssb_load
    startNew: True
    nextNum: #(field: load_num,
    table: ssb_nextnum, table_field: nextnum)
    title: ‘Wagram Paper Stock SSB Load Database’
    (Vert
    (Horz ld_loc (Skip 40) date_proc (Skip 40) load_num)
    (Horz ld_al_wt (Skip 40) ld_drink_wt (Skip 40) ld_pill_wt)
    (Horz ld_ow_wt (Skip 40) ld_hanger_wt (Skip 38) ld_film_wt)
    (Horz ld_book_wt (Skip 40) ld_trash_wt (Skip 40) ld_cb_wt)
    Skip
    (Horz ld_tot_wt (Skip 40) num_bales)
    Skip
    (Browse “ssb_ld_bales”
    stickyFields: #(load_num)
    columns: (load_num, store_num, num_bales)
    linkField: load_num_new
    name: “ssb_load”
    )
    )

    )

    I want to carry the load_num gotten from the nextNum down to use it as a sticky value in each browse line. Im sure that its something very simple but I cant figure it out.
    Thanks
    Benny

    October 19, 2011 at 8:59 pm #900
    j_ferguson
    Moderator

    If you specify the name and linkField options of Browse properly I think load_num will populate automatically on the browse lines for you.

    The BrowseControl ‘name’ option should be the field name you want from the Access record. This is load_num in your case.

    The BrowseControl ‘linkField’ option should be the field in the Browse query that corresponds with the field you specified as the name option. In your case I think this is load_num for the Browse query as well. You have specified load_num_new which is incorrect based on the columns you are displaying in the Browse.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Search Forums

Log In
Welcome to the new Suneido Web Site and Forum.
Register
Lost Password
users of the previous PHPBB Forum should be able to log in with their previous username and password.

Recent Topics

  • Alpha copy of gSuneido to play with
  • how to start jsuneido ?
  • Problem Starting Suneido…
  • Dialog not showing buttons
  • New link for Suneidojo

Contact Us | Legal Statement | Privacy Statement | SiteMap

Copyright © 2023 Axon® Development Corporation. All Rights Reserved. - Open Source Integrated Database and Programming Language