+ Reply to Thread
Results 1 to 2 of 2


  1. #1
    Registered User
    Join Date


    I'm looking to get some kind of form to store customer details.

    I want one page to enter them and for it to put the details into another page. I know about vlookup etc but what do you suggest as the form method i should use? To go along with the form i need to make it so it gives them a 'customer number'.




  2. #2
    Forum Contributor
    Join Date
    Hi Pete,

    Generally, when one thinks about user input forms, they think about using Access instead of Excel. I know, I feel more comfortable with Excel as well, but here's an example for you ... I wrote an application in Excel for folks to create pricing records. Part of the record is the effective and expiration date, right? Somebody copied May's pricing over to the June column and just changed the 5 (for May) to 6 (for June). Problem ... the expiration date was then June 31.

    Excel let them enter June 31. Access wouldn't have allowed that. If you insist on using Excel, you are going to have to write a lot of Visual Basic code to error check every possible entry error.

    Sorry, I don't think you're going to like this answer.

    - Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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