@JoeM,
I finally found the download button.
@bo16tx,
I opened the table and added the two dates.
I closed the table and reopened it. Dates still there (I used today's date to ensure I was looking at the correct records)
I closed the dB and reopened it. Opened the table. Dates still there.
When I extracted the dB, the size was almost 21,000 KB. I did a "Compact and Repair". The size dropped to a little over 17,000 KB.
Then I entered the dates. I think doing the "Compact and Repair" probably fixed some corruption in the dB.
Advise you to do the same.
==============
Other issued I saw
------------------
The top two lines of EVERY code module should be
Code:
Option Compare Database
Option Explicit
Then do a "DEBUG/Compile HWTS".
You will find several errors - one of which is "End Sub" instead of "Exit Sub"
- The object naming is horrendous (IMHO).
- There are many subroutines that do not have an object. (ie code for the click event of a button that has been deleted. Deleting an object does not delete the attached code.
- You have a *LOT* of spaces in object names. Bad Idea!
- You have special characters (example: in table DODACC - field name "Gp/Bde/Dir")
- You have reserved words as field names
- You have Make Table queries. Make Table queries can cause corruption in your dB. A better option is to create the table once, then delete existing records before appending new records.
- The dB is still an MDB instead of being converted to ACCDB. Since you have Access 2013, converting to the newer format is a very good idea.
Remember - 1)back up, 2)back up, 3)back up BEFORE you try converting to the new dB format.
- Lastly, your table design looks like an Excel workbook was imported into Access. The table designs are not a relational design. This is called "Committing Spreadsheet" in the RDBMS world.
Excel worksheets are typically short and wide. Database tables are typically tall and narrow.
You might also want to read about Autonumbers:
Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp
Not trying to slam you - just pointing out things that could/will bite your six............