Recent content by Blondie96

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

I have a module. It is supposed to get a list of avail Rooms (it does this). Then take a request, compare that request to a schedule. Looping thru each room in the available list & checking the schedule to see if a record exists for that room, date, & hour. Problem is, even my debug.print...

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

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

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.