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...
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...
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...
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
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...
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
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...
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
...
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...
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...
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...
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
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)
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
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...
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 ='" &...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.