Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108

    Date entry issue on form...

    Hello,
    In my Database I have date fields that need to be entered. I have set the Data Type to Date/Time and copied and pasted the input mask to all the date fields so they would be the same 99/99/9999;;_ and set them all to short date format, but there is one date field that isn't working like the rest. in the others I can enter the dates into the field like 010101, 01012001, 01/01/01, 01/01/2001, 01-01-01, 01-01-2001 and it will accept any of those, but the one I am having an issue on you can only enter it as 01/01/01. I didn't know if there was a field I am overlooking or something.

    Thanks,


    Will

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    trying to understand what the difference is

    I can enter the dates into the field like 010101, 01012001, 01/01/01, 01/01/2001, 01-01-01, 01-01-2001 and it will accept any of those
    but the one I am having an issue on you can only enter it as 01/01/01
    so you can't enter 01/01/2001? even though you've said you can?

  3. #3
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    Ajax,

    I think from what I read in OP he meant this..... In one date field 01/01/01 is the only way the date can be entered. in all the other date fields it can be entered in all the different variations.
    010101, 01012001, 01/01/01, 01/01/2001, 01-01-01, 01-01-2001

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I think it's time for Will to describe
    -what works,
    -what doesn't work and
    -what he wants to do with examples of raw data and final data - so we don't have to guess at the issue.

  5. #5
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Check again the Datatype, Formats and Input Masks of all your date fields. Are the dates imported from another process or only entered manually on your form?

  6. #6
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    Thank you all for looking at this and trying to help!!! I will try to explain a little better... On the form I have multiple data fields, they are all set up the same. I checked the property sheet for them, the general and lookup fields are all the same. the input mask is set to 99/99/999::_ for all the date fields also. So I am entering the data into my form, for field 1 I can enter in 01-01-01 and it will auto populate 01/01/2001, or 010101 and it auto populates 01/01/2001, ect but when I get to the one field if I try to enter the date with "-" instead of "/", or if I try to put "2001" instead of "00" for 2000 it errors out. Another thing I noticed when I was testing it again, if I highlight one of the working date fields and hit DEL and I start to enter it will still show the "__/__/___" on the field I am having issues with if I delete the value and try to enter it in again it does not have the "__/__/____" it is just blank. I hope this helps explain what issue im having... All of the data is keyed in by the user it is not imported or anything.

  7. #7
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    If you putting input mask 99/99/999::_ it should only let you enter it in that format, not those other ones. Why let them enter it in the other formats if the one you want is 99/99/0000;0;_?

  8. #8
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    In the other fields they can enter it in a number of different ways as I described, but when you hit enter/tab it formats the date to match the input mask. so in the end it displays the date as mm/dd/yyyy

  9. #9
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    Sounds like to me that some dates are set in the format option and the other is set in the input mask. possibly on the table level. Just a guess form across the keyboard without seeing it.

  10. #10
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    As Night says, check the table to see if you have any formatting set there. Then try to Delete the 1 field causing the issue, copy one of the fields that work and change the Name and ControlSource.

  11. #11
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    Ok, got a chance today to work on this... Did like you guys said, deleted the field and copied in one that works and everything seems to be good. Thanks everyone for your help.

  12. #12
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    ok, got a question now... since I deleted the field and put it back in now all the data is gone. how do I go about getting the data back in for those fields? I made a backup of my backend, but I really don't want to go through 1000 files and manually enter. I am assuming I can use a update query, but I don't know how to get the data from my backed up backend.

  13. #13
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Import the table that has the good values from your backup BE database into your working Database. Create a query, include both tables and join on the Key field in both tables. Then use an Update query and update that one field in your working database to the value from the backup table you imported.

    Sorry in my other post I was talking about deleted the field on the form, not the table. For future when fooling with fields in table, I rename the field just to keep a copy of the data, then create a new field and update the data over.

  14. #14
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    Bulzie,
    I understand what your talking about in theory, but I am not sure how to do it below is the list of the backup table (left) and the active table (right). and I joined the to key fields. the fields I need to copy from the backup table are EOPFemailSent and date1150SentToPayroll.

    Click image for larger version. 

Name:	update qury.jpg 
Views:	10 
Size:	141.6 KB 
ID:	25631

  15. #15
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Click the 2 fields from the active table (right) into your query. Then in the Update To: for each enter [tablename].[Fieldname] so [tbl_Import_EmployeeData_EmpRecords].[EOPFemailSent] for the first one, etc.

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

Similar Threads

  1. Combo Box Data Entry Form Issue
    By MintChipMadness in forum Forms
    Replies: 24
    Last Post: 08-06-2012, 05:04 PM
  2. Replies: 1
    Last Post: 11-21-2011, 01:09 AM
  3. Help with a form data entry issue
    By kcm4491 in forum Forms
    Replies: 3
    Last Post: 11-19-2010, 12:00 AM
  4. Date/Time entry field on a form
    By Ted C in forum Forms
    Replies: 1
    Last Post: 06-22-2010, 12:28 PM
  5. date entry on input form
    By dzawicki in forum Forms
    Replies: 3
    Last Post: 12-25-2009, 08:13 AM

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