Search results

ok Start: txtBegDate End: txtEndDate

Mr. B is correct. I want the user to be able to choose between the Start and End date

1. myDate 2. Date/Time, and is in short date

LOL I just sent you a private messge vBaInet. I'm not sure if this is what I'm looking for or this is quite confusing. Can you explain to me how exactly do I implement this? I only have one date text box, unless I'm suppose to make two?

How do i do that?

I'm getting it out of a query. but I'm not entirely sure on how to do this. what do I write under criteria, in the query? and Since I only have one Date on the query, am I going to need two since I'm going to have a Start and End Date?

Hi, I need help in creating a date range for a form. Based on the dates selected I want to generate a report. I'm assuming there's some VBA coding needed and two text boxes. Please Help, thanks

This is Awesome!!!! I tweaked it and integrated into the database and it now works like a charm. Thanks, You rock.

So there's not easy way I can make the button check to see if the Notes section is also filled out? Regarding the Note Default value properties, I checked what you said and they all blank.

It looks good. Note1_subform is the subform itself. So How can I validate it? Also I'm noticing that if I type in a Note and hit New Call, the note from the previous record transfers over. Is there a way that it can come out blank everytime I hit new?

Let me know if there's another issue I missed

The New call Button doesn't work with the code you gave me, do you want me to remove your code? I dont' know if I can test it if it continues to give me an error

Sample database

I can't send it to you there's confidential info in it. YOu know what I'll make a copy of it without any data. Give a sec.

do you think there's an issue because the the subform is a data sheet?

Just did it no change

DO YOU THINk it might have to do with the On Dirty code you gave me earlier?

I noticed everything after Caller Type is giving me the #2 error i mentioned. I don't know how to edit the #1 error. I've edited all I could and it still gives me that error. Maybe I can't do it from a subform.

What do you mean broken code? please elaborate I added the the code under Private Sub Add_Record_Click() in the New Call button and the I added the validation code two lines under End Sub like you said.

OH ok now we are on the same page.:cool: I did what you said to do. but now I'm getting two errors 1. for this part of the code I'm geting this error >> Compile Error: Type mismatch ElseIf IsNull(Me.NOTE1_subform & vbNullString) = 0 Then MsgBox "Note Needed"...