Recent content by Mytitan

I agree, I should have had a separate field just for dates, rather than lumping that into a text box. It looks like the above coding is working smoothly. I'll be adding more data so I'll be able to test it further, just to be safe. Is there an actual manual or any type of quick reference...

I've one more inquiry regarding the same database. I'm not sure if I need to just reply to you or start a new thread? I'll go ahead and send as a reply but let me know if it's better to start a new thread for this: In my database I have the following fields (or text boxes) in my Form...

I've had someone tell me before not to add it to the table but I wasn't sure. But if you're telling me it's a bad idea then I'm more inclined to listen to your advice! Thanks for the help on this, it helped tremendously. I know I'll have more inquiries so it's great that this site exists...

Ok, that did the trick, thanks! I'll work on the naming of the fields, to prevent the underscores and (). Now if I wanted to have this same code set up in the table of the database, would the set up be any different? I'm not sure where I would start at in the design view of the table?

Thanks billmeye I entered the code: Me.Audit_Due_(9_months) = DATEADD("m",9,Me.Sub-recipient’s_Fiscal_Yr_End) Here is what the screen showed afterwards: Private Sub Audit_Due__9_months__AfterUpdate() Me.Audit_Due_(9_months) = DATEADD("m",9,Me.Sub-recipient's_Fiscal_Yr_End) End Sub It gave...

Hellow all, I'm working on a database and trying to go above my skill level, regarding coding. In my Form I have one field titled “Audit Due (9 months)” and is a date format. I have a field before this one titled “Sub-recipient’s Fiscal Yr End”, which is also a date format. What I’m trying to...

Hello to all! My name is Alan and I reside in Missouri. I've used Access for many years and have created numerous databases for home and work. They are pretty basic db's with only one having actual coding involved. I'm looking forward to expanding my Access knowledge with your help, and...