Results 1 to 19 of 19

VBA Coding Related to Data Entry Form

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    23

    VBA Coding Related to Data Entry Form

    Dear Al

    Please find attached file and help me to resolve following issues.

    username - admin
    password

    1) In Add Vehicle Form Contact Number Text Box should not allow value less than or greater than 10 Digits.
    2) In Add New Vehicle Form Only Date Selection option should appear in following Text Boxes
    Insurance date, MH Tax Date, NH Permit Date , Passing Date
    3) When Date will be saved in Vehicle Sheet then it should be in DD-MM-YYYY Format only.
    4) When Vehicle Number is entered only in Numeric Value then Update Vehicle code works fine,
    But If Vehicle Number is entered in Numeric and Text Combined Value (MH09EM2727) then Update Vehicle code gives error.
    5) I am unable to write code for Delete Button -
    Expectations are as follow
    If user will click on delete button then Delete Vehicle form will open
    User will select the vehicle in combo box
    and click on Delete Record button
    It will ask "Do want to delete this vehicle permanently from database"
    Yes No option
    If user will click on Yes Button then message will come " Vehicle Deleted from the database "
    If user will click on No Button then Dialog Box Screen will disappear and user will come on Delete form Screen.

    Thanks in Advance
    Atul
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] In need of help regarding combo box coding and button coding (Access form project)
    By mailblade in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-09-2016, 01:34 AM
  2. [SOLVED] *Urgent * Work related * Generating an Auto-log from data entry on another sheet
    By demetrius323 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-17-2014, 06:13 PM
  3. Replies: 2
    Last Post: 06-07-2013, 09:08 AM
  4. [SOLVED] need coding for macro to move related data from 2 different tabs into a 3rd tab
    By s4driver in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-05-2013, 02:09 AM
  5. Coding script error-cmd button to open form and for to add new entry to list
    By Southfish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 05:43 AM
  6. Replies: 1
    Last Post: 11-04-2011, 04:46 PM
  7. Data Entry Form (similar to default Excel Data>Form)
    By tonydm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 02:59 PM

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