Search results for query: *

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

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

I have a cbo subPOC if you DblClick it pulls up an add screen to allow you to enter a new POC in the POC table. The code is: Private Sub SubPOC_DblClick(Cancel As Integer) On Error GoTo Err_SubPOC_DblClick Dim lngSubPOCID As Long If IsNull(Me![SubPOC]) Then Me![SubPOC].Text =...

I am using ocxCalendar (MSCAL.Calendar.7) to pick dates. I would like to verify the date selected is >= current date. Can someone help me accomplish this? Thanks, T

I am trying to get the next sequence number for a tracking number. The number is composed of 3 parts YY (year) XX (two set characters and nnnn (a 4 digit number): yyXXnnn I am using: ASeq = DMax("Right([TrkNumber], 4)", "[tblRequest]", "Left([TrkNumber], 2)='" & Format(Date, "yy") & "'")...

I have a form which has 2 cboSelects 1. SelDiv 2. SelectPOC The Div is selected, then used to pull up a list of POC's. The select for the POC is: SELECT tblPOC.POCID, tblPOC![FirstName] & " " & tblPOC![LastName] AS POC1 FROM tblPOC WHERE...

I have a form with the following items: cboLookup, RoomName, Save Record button, Cancel Button, Delete Button, & close button. It has tab stops set in that order. Problem: When I hit tab while on close button, the next record in the file is displayed. I want it to return to the RoomName field...

I have a cbo field cboRoomType it has 2 columns, an index & txt I want to display the text from that field in a txt box. I know this is simple, but I'm getting the syntax wrong. The following gives an error (in effect it is looking for the value (as a variable)in cboRoomType instead of taking...

I used a wizard to "find a record on my form based on the value I selected in my combo box" In my cbolookup I am showing 4 fields. When a field is selected, however, only the the value of the first field is displayed in the cbolookup field. Is there a way for me to show the result of all 4...

I am recording a sequence number in the format of YYAA#### where YY is the last 2 digits of the year, AA is 2 alpha characters (which will always be the same) and #### is the sequence number. I need to be able to do a lookup (or query) that will return the last sequence number for a given year...

I have a form which has a cboPOC field. Through the MS reservations? database I got the procedure to allow entering a new POC in the POC table by DblClicking POC field. This works fine with one caviat: the field name has to be the same as the Control Source. if I change the field name to prefix...

Is there a command that will tell me the name of the field that currently has the focus? Reason, I perform the same verification loop on 10 datefields named StartDate1...StartDate10. I want to know which field has the focus, then I want to do a Right string command to get the # of that...

I would like to create a form which provides a cbobox which selects the record which fills the form based on a ValidationID. It is basically the same form that the original record was entered thru, but now I want the form to open empty, and have the user select the record to view/update based...

I have a situation where a user may enter all fields on a form. The cmdBtn must then search a file for any records that meet a specific criteria "Forecast". If any are found, processing of the original form must stop. The user must Modify any and all "forecast" records found to either cancel...

Hopefully this is the last question on this... I have a selection frame, 2 buttons, Selection says default value is 1. However, when I open the form, the 2nd button is Highlighted. If I click the 2nd button, nothing happens (the form should change). If I click the first button, then the 2nd...

I am trying to set up control which will display one field or another based on an option button. I created a frame called "Selection" and placed two option buttons in it. I get an error no matter how I try to refer to the buttons (the below code gives error "Compile error: Variable not defined"...

I am using pop-up calendars on multiple cbofields. My problem is, Once the calendar opens, if the user clicks on another field on the form, the calendar remains open. I would like it to close. I tried placing " ocxCalendar.Visible = False" in each of : ocxCalendar_LostFocus()...

I have a pop-up calender triggered by several cbodate fields. One of those fields is checked to verify it has a value. If it doesn't contain a date the backcolor is changed to yellow. This works fine. What I want is for the field to return to original color if a date is entered. I have tried...

I want to use a sub to verify entry of required fields, if it fails I want to exit the main sub. All the fields mentioned in the check_Required are on the form. I am getting a "compile error: Expected Function or Variable" on the "AllRequired = check_Required" line my code is: Private Sub...