Search results for query: *

I wanted this in a form, not a report. Does the same function exist there? Thanks, Tamra

I have a form which shows information about a request for scheduling a room type. The user can schedule multiple days @ differing times with the same request. That part is done in a different form & process.These are tied to a tracking # I want a summary form which shows all the info in the...

I will give you a specific example. This same code is used to validate the cboendHour3 field. I would like to modify it so that I can call it for cboendHour1,cboendHour2,cboendHour3,cboendHour4 ...cboendHour10. How could I do that? Private Sub cboEndHour3_Exit(Cancel As Integer) If Not...

Thanks PHV, There's a lot I need to learn about the VBA editor & Access

...of program 'turn off warnings ' 'DoCmd.SetWarnings False ' Delete unnecessary with the make 'RmSQL = "Select * From tblRmList" 'Delete Existing Data in tblRmList ' DoCmd.RunSQL ("Delete * From RmList") MkRmList = "SELECT DISTINCT RoomName.RmKey, " & _...

This just reminds me, How much I love to hate programming. I remember years ago, a colleague working in cobol kept getting an error something like "expecting variable name found ," They were dealing with communications & declared variables: comma.....pic x(3).. commb.....pic x(3) or however...

Thank you PHV, When I changed that, I found Office = 0. so I added an Or to the test & it works correctly now. Thanks, Tamra

...Response = acDataErrContinue End Sub Private Sub Office_Exit(Cancel As Integer) Debug.Print "Office---" & [Forms]!frmScheduleRequest![Office] & "*****" Debug.Print "LEN---" & Len(Nz([Forms]!frmScheduleRequest![Office])) & "****" If Len(Nz([Forms]!frmScheduleRequest![Office], "") = 0) Then...

Oh, Ok. That's why I had it in the On_exit event. I want it to fail and not go past that field if nothing is entered. Any more ideas?

I commented out the on_exit, & placed your code in the before update Results: Without the on_Exit() code it passes the field w/o data entirely, even if it goes to the dblclick code

If I remove the code from the Sub Office_DblClick, it will not allow a new office to be entered if the user dblclicks the office field. it does that now, & I want it to. What I don't want is for it to bypass the office field if nothing is entered at all. If it goes thru the dblclick code &...

I can't set the required property in the table. If I do, the dblclick to enter a new office will not work. I tried that before.

I have a form which requires an office name(cbobox). I want it required. I took a function from the MS resource scheduler which allows one to double click on that field and enter an office where it doesn't already exist. This part works. If I tab past "Office" when I first enter the form, it...

I have a mainform/subform. The main form requests some of the data that is associated with initially requesting scheduling of a room. ie type of room, division requiring use, POC... The subform requests multiple days/hours, non contiguous usage stuff. There is more information that goes with...

It is an unbound field, so it isn't linked to a table. It is the OnExit event code that is causing this.

Hmmm, I just went into the subform, now it is creating that message every time I try to close it, even if no data has been (or attempted) entered.

I have a main form, which provides information about requests for room usage. (office symbol, poc.. etc) It has a subform which collects: (start date/hr enddate/hr) 1-10 occurrences. Problem: while testing the form, if I hit escape with no data in any fields (or esc & clear fields from main...

Tranman, Thank you. This looks like just what I need. I will be passing a month, stringing the first day and then looking from there (I won't be dealing with the middle of the month stuff....famous last words though). I doubt the code is "too oblique" but I will be giving it a try shortly...

(I put this in the wrong forum, so I'm posting it here, where it belongs) I need to produce a list of the dates (i.e. 4/18/05, 4/19, 4/20, 4/21, 4/22...) of the weekdays of a month I pass as a variable. Does anyone know how I could produce this? Thanks Tamra

I need to produce a list of the dates i.e. 4/18/05... of the weekdays of a month I pass as a variable. Does anyone know how I could produce this? Thanks Tamra