+ Reply to Thread
Results 1 to 4 of 4

HTML Form Will Not Submit, Likely Form Validation Issues

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 Apps for Business (v 2306 / 16.0) 64-bit
    Posts
    27

    Question HTML Form Will Not Submit, Likely Form Validation Issues

    Please note, this unresolved question has been posted to another site. While I do not feel that an answer from that site is likely at this point in time, I would recommend a quick check to ensure the question has not been answered before putting in time reviewing this! My intention is to not waste your time!

    ---------------------------------------

    The following code works just fine when it comes to completing the form located on the webpage. The issue arises when it comes time to submit the form.

    This appears to be some an issue with validation, as when the form is completed systematically, the submit button is disabled. However, when I go back over the text boxes and manually type in the exact same information, the submit button then becomes available. I believe the form thinks it is incomplete, thus disabling the submit button. I even systematically reenabled this button using SubmitBtn.disabled = False (which allows it to be manually or systematically clicked), and it still will not submit.

    I have never encountered this type of form validation when filling in webpages.

    I am currently on Internet Explorer 11

    The following code is complete and can be tested without needing modification. This is a website that is made available to the public

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: HTML Form Will Not Submit, Likely Form Validation Issues

    Activating each required field seems to enable the Submit button.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    04-26-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 Apps for Business (v 2306 / 16.0) 64-bit
    Posts
    27

    Re: HTML Form Will Not Submit, Likely Form Validation Issues

    Quote Originally Posted by AlphaFrog View Post
    Activating each required field seems to enable the Submit button.

    Please Login or Register  to view this content.
    That did not solve the issue unfortunately. However, because of your response, I cheated and added reference to Microsoft HTML Object Library. I declared one of the boxes as HTMLInputElement (temporarily, since I must use late binding), and went down the list of every possible culprit that looked like it could help. Here's what I used for each object:

    Please Login or Register  to view this content.
    I ran the code and it worked. So now it was time for process of elimination. I determined the issue lies with the .setActive property.

    Again, thank you for your assistance! I would have likely been stuck on this for another month!

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: HTML Form Will Not Submit, Likely Form Validation Issues

    You're welcome. Glad you figured it out. I wasn't sure how to properly activate each field with code, but I could tell that was the issue when doing it manually.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how can i loop this code through each row (populate and submit an HTML form)
    By GHIREM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2015, 07:39 PM
  2. VBA HTML submit form problem
    By jfgrenier in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2014, 07:30 PM
  3. Replies: 1
    Last Post: 02-28-2013, 08:17 AM
  4. Replies: 1
    Last Post: 02-05-2012, 09:31 PM
  5. How can i Submit This Form
    By kumar_manoj4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2009, 06:26 AM
  6. Help with form/Submit
    By rmagus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2009, 02:52 PM
  7. [SOLVED] Form with submit button
    By Hooter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM

Tags for this Thread

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