Results 1 to 4 of 4
  1. #1
    SoTotallyNonplussed is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2017
    Posts
    2

    Question Adding records to a relationship using form controls (popup box)?

    Hey guys! New to the forums but long-time reader. Casual user of Access who is trying to go pro.



    I'm developing a project management database for my team at work. My department is a group of engineers that researches, qualifies, selects, and purchases vehicles for our organization's fleet. There's a lot of note taking of vehicle requirements, meeting with the end users, memos, writing a specification documents, then finally getting the project thru the byzantine requisition process.

    Right now I have the foundations of the database set up, with the end goal of managing all dat thru forums - so anyone can use it. There are three key tables: Vehicles, which lists all vehicles we're replacing (with columns like type, make, model, unit number); Projects, which summarizes vehicles into groups, and adds columns like the project number, cost estimate, quantity; and lastly Contacts; which is a linked table pulling my list of contacts from Outlook (so that end users can be tied to specific projects). There's also Notes table that has a 1-to-many relationship with the Projects table.

    Right now I have a basic form set up based on the Projects table. The idea is to go thru project by project, adding estimates and tracking numbers as they come available, and then add Notes on an ongoing basis (i.e. everything via the form). I want to figure out how I can create a form-based method to associate or tag vehicles to a project. Right now I have them associated manually by a column that is common to both the Vehicles table and the Projects table (1 to many relationship). However, it doesn't always work and isn't elegant. What I'm visualizing is a popup dialog box that shows the Vehicles table in datasheet form, use the filter controls to get what you need, then hit a button or checkboxes to associate them. This way it's simple enough for inexperienced people to use.

    Is it possible to do this just thru native Access tools? Or am I barking down a VB script path?
    Thanks so much for your suggestions and I apologize if I am asking a lot here.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Cross posted at https://www.access-programmers.co.uk...d.php?t=295165

    When you cross post ---put the same or similar request on more than 1 forum---- please indicate to readers that you have done so.

    Here is why

  3. #3
    SoTotallyNonplussed is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2017
    Posts
    2
    Apologies, it didn't occur to me. No harm intended.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    You are saving a ProjectID into Vehicles table?

    It is possible through native Access tools. A simple db can be designed without a stitch of code, I've done it. A form with subforms placed on a Tab control might be adequately 'user-friendly'. The more 'user-friendly' the more code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Popup form for adding customers
    By ittechguy in forum Forms
    Replies: 2
    Last Post: 09-15-2015, 09:17 AM
  2. Blank Popup form - not showing any controls
    By Williams485 in forum Forms
    Replies: 9
    Last Post: 03-06-2013, 09:20 AM
  3. Replies: 2
    Last Post: 11-19-2012, 10:54 AM
  4. HTML Controls on Popup Form
    By kelann in forum Forms
    Replies: 4
    Last Post: 11-01-2012, 09:29 AM
  5. Adding Controls to a Form
    By msmayhew in forum Programming
    Replies: 7
    Last Post: 12-14-2005, 03:26 PM

Tags for this Thread

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