Search results

  1. MsLady

    Auto Incrementing a field without using Autonumber

    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") &...
  2. MsLady

    OnLoad -versus- OnOpen

    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!!
  3. MsLady

    OnLoad -versus- OnOpen

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

    OnLoad -versus- OnOpen

    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...
  5. MsLady

    Hard code TIME to selected Date on form (to make it date&time) for my query criteria

    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 :)
  6. MsLady

    Screenshots - Part 2

    nice design folks! good stuff
  7. MsLady

    OnLoad -versus- OnOpen

    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...
  8. MsLady

    Hard code TIME to selected Date on form (to make it date&time) for my query criteria

    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?
  9. MsLady

    OnLoad -versus- OnOpen

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

    Change recordsource of subfrm to another saved query OnOpen

    GREAT!! This does it. Thanks buddy
  11. MsLady

    Change recordsource of subfrm to another saved query OnOpen

    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...
  12. MsLady

    OnLoad -versus- OnOpen

    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?
  13. MsLady

    Hard code TIME to selected Date on form (to make it date&time) for my query criteria

    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...
  14. MsLady

    Hard code TIME to selected Date on form (to make it date&time) for my query criteria

    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]...
  15. MsLady

    "#Error" shows up on txtbox instead of "nothing"

    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
  16. MsLady

    "#Error" shows up on txtbox instead of "nothing"

    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 =...
  17. MsLady

    "#Error" shows up on txtbox instead of "nothing"

    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...
  18. MsLady

    Database corruption Error "AOIndex is not an index in this table"

    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
  19. MsLady

    Database corruption Error "AOIndex is not an index in this table"

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