Recent content by tis9700

Hi ProgramError, My local settings were correct and it has something to do with the format function... Check this out about Access misinterpreting dates From Allen Browne http://allenbrowne.com/ser-36.html#Interface All I can say is... WAHHHHH!!!

I've never seen this happen before... I have a textbox on an unbound form for entering a Date of Birth. It has an input mask and the format is short date. mm/dd/yyyy But when I type in 13/10/1978, I'm trying to purposely enter a bad date, the month reverses automatically with the day to give...

Hi Aceman1, Sure thing, anytime I can learn someting new is a good thing. I've already learned alot from you on other issues, you've been very instrumental in my project. And JB, thanks once again for your help. Australia! So cool! Nice to meet you from Nashville, Tennessee. Thanks everyone...

Hi JBinQld, Hope you got a good nights rest. I can't imagine where you are if it's 3:30 am. I wasn't getting anything back from the varible when I Stepped Into the code. Hi Aceman1, I added that code to the button and it seems to be what I needed. In additon to this code and the code I have...

Hi JBinQLD Thanks for responding. Love the Aceman1! I created a form level varible... Dim Proceed as Boolean In the Form Event, On Current ... Proceed = False I think I'm stuck on C) I tried .. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Msg As String, Style As Integer, Title...

Good morning, I have a question.... I'm sure some may recognize to following code, I altered it a bit and it works great but when I click a button called "Search Students", which is a dialog, popup and modal search form to select another record, that form opens with the validation message. Is...

Thanks danvlas, I'm going to use those suggestions. Thanks for all the instruction. Have a nice day!

Ok danvlas, I see what you mean about Races. That would be the idea situation. My only concern is that they been collecting this data for the 15 to 20 years. It's on a mainframe and they NEVER attached the race to a specific student record only class records. In fact, there's conflict as to...

Good morning danvlas, It's another beautiful morning in Tennessee! So are you saying I should have a table for each race? Here's my table structure ... CREATE TABLE [Classes] ( [classID] [int] IDENTITY (1, 1) NOT NULL , [instID] [int] NOT NULL CONSTRAINT [DF__CLASSES__InstID__07F6335A]...

Thanks danvlas, So far that works great though I haven't added all my validation as of yet. But it's given me really good direction. Question about the following statement.. "I just hope Caucasian, AfricanAmerican, Hispanic and so on are NOT fields in some table, but values of a field in a...

Hi danvlas, So far I've set up a stored procedure that inserts the record and returns the scope_identity to the adp using an ADO recordset after inserting the data with the command object. Thanks to pwise. I've never attempted putting that type of validation in the stored procedure but would...

Hi pwise, Sorry for the delayed response. That did the trick. I'm now putting a lot of my validation in the Click fevent of my save button. Thanks

Morning, I've been experimenting with unbound ADP forms using stored procedures for inserting records. And one of the things I've noticed is data validation in a bound form may not work as it did in a bound form. For example.. I have 5 unbound text boxes for collecting and storing data...

That's perfect! Thanks!

Bah! No luck! But I learned alot from pwise! Thanks!