Results 1 to 4 of 4
  1. #1
    WillemTWC is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2018
    Posts
    13

    DBASE and sub DBASE


    Good Morning.
    I have a small issue. Novice with Access. Using Access 2013 to write a very small program. the part i am stuck now is with the dbase. Main dbase is straight forward 5 items but one item has a sub dbase. Description - every single part in the workshop has a different code(Partcode) and for every Partcode there is a cutting list specific to that partcode - so that is where the sub dbase comes in. The form attached to this dbase and sub dbase is only for inputting items and cutting list which is working perfectly as its not hard to manage the relationships. BUT with a new form i would like to create a jobcard which is also straight forward. i want to use the DBASE and sub DBASE for this process but every time i want to link the Partcode to a combo box so that i can choose one of the 500 codes the box is empty. how do i go about fixing this? This is not allowing me to choose the partcode from that database at all.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    when you say 'DBASE' , do you mean table called DBASE?

  3. #3
    WillemTWC is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2018
    Posts
    13
    sorry correct dbase is a table

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the parts should be in a combo box.
    the combo ROWSOURCE should be a query to provide the items IN the combo.
    the combo CONTROLSOURCE should be the field the answer gets saved to.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. dbase format and VBA2013
    By leonardo.massei in forum Programming
    Replies: 3
    Last Post: 11-04-2016, 08:34 AM
  2. Best approach for Absence DBase
    By JohnMc in forum Database Design
    Replies: 1
    Last Post: 11-17-2011, 12:00 PM
  3. Splitting DBase query
    By GraemeG in forum Access
    Replies: 0
    Last Post: 03-28-2011, 02:48 PM
  4. Linking dbase with website
    By pp100 in forum Database Design
    Replies: 2
    Last Post: 08-24-2010, 05:56 AM
  5. importing Dbase files
    By dzawicki in forum Import/Export Data
    Replies: 2
    Last Post: 01-14-2010, 05:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums