Search results

I wonder why this isn't working for me. I am trying to get a customer autonumber like this 08060001 i.e. mmyy0001 and i have tried the suggestions in this thread. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then Me!jobId.DefaultValue = Format(Date, "mmyy") &...

Hey! Rural guy..im not that slow :mad:...well maybe jus a little :p but I know it's an event here's what i was talking about using..:D Private Sub Form_Current() End Sub yea, what Pat said! THANKS GUYS!!

Okay, my lesson: So onCurrent is what i will always use in loading my recordset...

Very niceee!! Thanks guys. I appreciate all your help. @Pat: Thanks. I found it here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconOrderEventsRecordsFormsS.asp Google is my friend :p great resource. @RG: amaXing, i checked out too. never thought to search...

hehe...just what the doctor ordered :D Thanks Pat! Banana, Raskew: Thank you both. I really apprecite your time. That's what i was looking for. love you guys!!! Raskew: would still like to read ur links, can you fix it please? doesn't work :)

nice design folks! good stuff

WOW! thanks for the brilliant explanation. That's the clearest explanation i've seen. I like how you break it down. definately helps :cool: Thanks too Bodisathva!! I've printed this thread and glued it to my wall. I need to know what im doing OnLoading and OnOpening in this project im...

Thanks Banana (nice name :p ) How do i add 8 hours to with code, just do "MM/DD/YYYY 8:00 AM" in my code?

Thanks Bodisathva, um i don't think i quite get it...:o

GREAT!! This does it. Thanks buddy

Please help

How do i make my subfrm record source switch to another saved query (qryPendingStatus) when it's opened from the form. Heres what i am trying to accomplish: I have a subfrm that i'd like to use to display info in 2 different forms. There's a form currently for All statuses. Then another new...

Please don't beat me up, i simply don't know and coudln't find anywhere with a clear explanation. Can someone explain the difference between OnLoad event and OnOpen. They seem to perform the same function. No?

Thanks Pat. I really want to include time (8:00AM) in the cboDate/cboDate2. So that it compares the time and selects only the data that falls within 8:00am - 8:00am (the next day). As a single day! instead of the natural 12:00am - 12:00am. feel me? How do i plug in 8:00AM to the dates i select...

Hard code TIME to selected Date on form (to make it date&time) for my query criteria Hello buddies :D, do you have any idea how to make this work? To select data that falls within this criteria of date range between cboDate and cboDate2 (fields on my form). The date in [tblJobDetails]![timeIn]...

Thank you thank you!!! Thanks for the link pbaldy, that was quite informative. You are too much. I simply plugged this in. works like magic! Thanks again friends: you guys made my day! hehe

Thanks Banana :) I tried this onCurrent, but no luck, still same thing Private Sub Form_Current() On Error Resume Next 'Dim myGT As String 'myGT = Form_subfrmWorkDone.txtGrandTotalTime.Value If IsNull(subfrmWorkDone.Form!txtGrandTotalTime) = False Then Me.GrandTotalTime.ControlSource =...

Hello friends :D Can anyone direct me no how to get rid of the text "#Error" showing up on my form field when there's no value. This is the txtbox on my main form and it's looking up its value from another txtbox on my subform. The main form textbox produces #error when there is no record on...

Thanks all, i had to spend about 2days trying to figure out the changes i made and redoing them again. thankfully, i always try to keep documentation on big changes. I'll keep your suggestions in mind if i ever the error again...hopefully not. Thanks again

Hi Rural Dude :D thanks for replying. Im still looking around online for help files :o