Search results for query: *

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!

Wow! That's slick! Can this be used in a Form After_Update? Or a Lost_Focus Event? That way the user wouldn't have to click a button before tabbing to the fsubAssistant subform to add Assistants. I'm going to try it.

Man pwise, Do I feel stupid! Misspelling on .. .Parameters("@classComents") = Me!Comments @classComments It works now but I still need it to return the classID to the form because I need to pass it to another subform "fsubAssistants" Can I run this code from a different event procedure...

Hi pwise, I don't believe so. The error I'm getting now is.. Error number 3265. Item cannot be found in collection corresponding to the requested name or ordinal. I'm not detecting any misspellings or any parameters out of order in my sp, code or unbound controls. But what about classID as...

Morning pwise, Thanks for the help. I keep getting a message when I try to save the record.. Error number 2185. You can't reference a property or method for a control unless the control has the focus. What would this mean? Thanks again.

Excellent! Thanks for everything! I always learn so much when I come to this forum. I reading the BOL on Locking Hints. And I am going to do the separate audit tables. They wanted me to name a primary key "studMaster", I kid you not!