+ Reply to Thread
Results 1 to 2 of 2

Too many fields in the data form

  1. #1
    Registered User
    Join Date
    05-01-2008
    Location
    Illinois
    Posts
    2

    Too many fields in the data form

    All:

    Client has an excell spreadsheet with a large volume of data:

    Greater Than 100 columns
    Greater Than 13000 rows

    Currenlty client has a need to identify approximately 5 fields for any given record based on a search criteria and then report that data to another location.

    At this point client has been using simple excel search to identify the record and copy the fields needed.

    Client would like to instead present the data to staff to allow them to search records.

    Problems:
    Data should be secured to prevent unintended changes (read-only)
    Staff search should be on only the necessary fields and not distracted by the remaining volume.

    Cannot currently use Access -- Staff does not have the right version of office.
    Uncertain MySQL will deploy correctly to thier environment or that there is sufficent time to "develop"

    Attempted to apply a simple excel form however volume of data causes error:

    Too Many Fields In The Data Form

    If nececssary will likely employ MySQL as quickly as possible, however thought I would as the question here to find out if there was an option I was overlooking.

    Thank you in advance for all input and suggestions.
    Thanks in advance to those willing to share the benefit of their knowlege and experience!

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Too many fields in the data form

    The standard dataform cannot work with that many fields so the only other option would be to design a UserForm,but the amount of Fields required seems excessive.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1