Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BabyPowder2u
  • Order by date
  1. BabyPowder2u

    Date verification using calendar selector

    Hi Missingling, Thanks for getting back. I wanted to make sure that "response" wasn't used as I see it in some of the "Access generated" proc's. Thanks again for the help. And, There are truly many ways to skin a cat. I accept suggestions, see if they can work in my situation, apply if it...
  2. BabyPowder2u

    Saving record to table

    I have a main form with data relating to a request. It has a recordsource = tblRequest. It accepts data for tblRequest, but also data for two other files (related by trknum). I have several buttons (Process as Pending, Schedule Request, Cancel, Close Form). When a user presses Process as...
  3. BabyPowder2u

    Form design

    Continuous form is probably the direction I need, however I must be doing it wrong, when I try it, I get the same "datasheet" view. What I want is for it to look like the rest of the form, titles and datafields lined up in columns with individual blocks, (not the datasheet view) I hope this...
  4. BabyPowder2u

    How can I open a form to a specific record?

    Thanks Everyone, I had researched the filter properties on forms before & didn't understand using them, same with open args. Thanks OnTheFly, that is what I needed, I will try it out shortly, I'm leaving for now. Will get back. T
  5. BabyPowder2u

    How can I open a form to a specific record?

    I have a main form, on this form is a cboSubPOC field which selects a POC name from the available list. I want to right click on that field and open the form POC_ModDel, which gets it's data from tblPOC tabl, and open to the record in referenced in subPOC. I have the mouseup event to capture...
  6. BabyPowder2u

    Date verification using calendar selector

    I did get the field to clear and not accept an invalid date. I added these lines into the If ... End if: cboOriginator.Value = Null cboOriginator.SetFocus
  7. BabyPowder2u

    Date verification using calendar selector

    Well, that's what I'm trying to design. (I kind of asked what I wanted in a new post "Form design") I want the form to look the same with individual fields like this one. I figured on doing it the hard way, a select query and then filling the associated fields. (the 2 files would have a tracking...
  8. BabyPowder2u

    Date verification using calendar selector

    That could be part of the problem right now, the cboStartDate(1-10) is an unbound field. Is there an OldValue property for an unbound field>
  9. BabyPowder2u

    Form design

    I have a main form that accepts primary information about "requesting a room" (username, roomtype, dtsubmitted, etc.) w/trknum hidden the lower portion of the form looks like: StartDate1 Start Hour1 End Date1 End Hour1 StartDate2 Start Hour2 End Date2 End Hour2 ...
  10. BabyPowder2u

    Date verification using calendar selector

    The BeforeUpdate of the form might be an option for this form which is only doing adds. However I'm going to have an "update" form in which the old dates would be valid, but any "new entry" or change of that field to an old date would be invalid. I haven't figured out how to do this since...
  11. BabyPowder2u

    Date verification using calendar selector

    I tried with it in just the click event, that didn't take me back to the calendar after pressing retry, it returned to the field and put the invalid date in the field. Something similar happened with the code in both the afterUpdate and click events. It still resulted with an invalid date in...
  12. BabyPowder2u

    Date verification using calendar selector

    It helps to know what your doing. Placing the code in the afterUpdate (once I found it) does produce the desired message. One problem, if the user presses re-try and returns to the calendar, if they press the same date again, it no longer fails the test and allows the field to be updated with...
  13. BabyPowder2u

    Date verification using calendar selector

    I apologize, I was looking at the properties sheet and there are no "on click" or "after_Update" events there. I am very unfamiliar with using the editor pulling down events like you mentioned. I will try that and get back. T
  14. BabyPowder2u

    form help

    Great, I can get the mouseup event to give me the button pressed. Now, what I want to do is open form POC_ModDel, which gets it's data from tblPOC, and open to the record in subPOC Do you know how I can do this? (I don't know how to use the filter events on a form)
  15. BabyPowder2u

    Date verification using calendar selector

    Thanks for the reply HarleyQuinn, The ocxCalendar doesn't have a "on Click" event. It has: On Updated (tried the code here w/ref to ocx - didn't work) On Enter On Exit On Got Focus On Lost Focus Custom (don't have any idea what that is) Still trying... T
  16. BabyPowder2u

    Date verification using calendar selector

    I have tried the following code in these fields: cboStartDate1_Change, cboStartDate1_AfterUpdate, ocxCalendar_Updated Dim Msg As String Dim Response As String Debug.Print "In cboStartHour1_GotFocus" Debug.Print "cboStartDate1 ='" & cboStartDate1 & "'" If cboStartDate1 < Date Then...
  17. BabyPowder2u

    form help

    HarleyQuin, Do you have a sample of how I might do that? I am unfamialar with the "MouseUp" and button values. T
  18. BabyPowder2u

    Date verification using calendar selector

    The calendar doesn't have an afterUpdate event, so I tried: Private Sub ocxCalendar_Updated(Code As Integer) Dim Msg As String Dim Response As String Dim ChkDate As Date Dim NowDate As Date 'ChkDate = Date ChkDate = Now Debug.Print "ChkDate = " & ChkDate Debug.Print "ocxCalendar ='" &...
  19. BabyPowder2u

    Date verification using calendar selector

    Thanks Missingling, I will check this out. Btw, you "Dim Response As String". I don't see "Response" anywhere else. Can you tell me what that is for? Thanks, T
  20. BabyPowder2u

    form help

    I can't really see using the click event, as I would think, that would be used for any selection of the POC name. I need a distinct event (or check, other than original selection) to indicate they want to make a change to the base POC table. The cbo is used to select a POC name from the POC...

Part and Inventory Search

Back
Top