Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879

    I've been working on something similar so I imported some parts of it into a new database.
    It's only a small part of it but demonstrates using fso to manage files.
    Might give you some ideas.
    Attached Files Attached Files
    Last edited by moke123; 02-23-2025 at 03:39 PM.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  2. #17
    yrstruly is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2024
    Posts
    122
    Do you suggest the import and export function should be tied to by the same table or another for export linking to import?

    Import:
    Implement structured document storage: o Dedicated database fields for permit documents (PDF/Word) o Dropdown selection for document type (e.g., DHL docs, Phytosanitary, Import Authorization) o Bulk document upload feature for multiple related permits

    Export:
    Current Issues:  No centralized system for storing export data.  No linkage between export documentation and import records.  Missing tracking of essential export details. Proposed Solutions:  Create a dedicated export management section in the database.  Mandatory fields: o Variety, Clone, Requestor, Permit No, Validity Date o Date Shipped, Destination Country, Material Type, Quantity  Implement a document repository similar to import storage. �� New Feature: Export-Import Linking  Create an import-export traceability module that automatically links records based on batch numbers or permit references

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Load form file in another access file
    By nd0911 in forum Forms
    Replies: 1
    Last Post: 12-10-2017, 05:19 AM
  2. Replies: 14
    Last Post: 03-21-2017, 07:00 AM
  3. Replies: 1
    Last Post: 08-06-2014, 02:22 PM
  4. Replies: 13
    Last Post: 11-07-2012, 03:14 PM
  5. How do you export a file with a unique file name
    By Budman42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-15-2006, 06:10 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