Search results

Hello all, I have an identical issue i am trying to accomplish here. I have read all the demerits and i know waht the book says and what you guys advice but this needs to get done this way for the best reasons - break the rules a little :o So, I have choosen Pat's method, where the customer...

~Subscribing to thread :cool:

But in this case, i need it to be the JobId tho i have an autonumber primarykey, but thre's a search field in my application, where the users would like to type in jobIDs e.g. 08060001 (mmyy0001) to search for that ID. I was using the autonumber for the search field but the nubmers are going to...

Hi Rural Guy. Thanks. I swayed from that approach since i wasn't getting anywhere. I created a field in my table [jobIdSequence] and use this bound control on my form with controlsource (=Nz(DMax("[jobIdSequence]","tblJobDetails",Format([timeIn],'mmyy')=Format[timeIn],'mmyy')),0)+1) I have a...

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