Search results for query: *

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

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

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

(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

I have a form that accepts BegDate1 BegHour1 EndDate1 EndHour1 BegDate2 BegHour2 EndDate2 EndHour2 BegDate3 BegHour3 EndDate3 EndHour3 BegDate4 BegHour4 EndDate4 EndHour4 BegDate5 BegHour5 EndDate5 EndHour5 I am trying to validate data & force re-entry of the field if it does...

I have a form that accepts BegDate1 BegHour1 EndDate1 EndHour1 BegDate2 BegHour2 EndDate2 EndHour2 BegDate3 BegHour3 EndDate3 EndHour3 BegDate4 BegHour4 EndDate4 EndHour4 BegDate5 BegHour5 EndDate5 EndHour5 Each set of fields go through the same checks. Is it possible to use 1...

I have a form, it requests a start date. I want to make sure that a valid date is entered into this field, before goint to the next field which is startTime. If no valid date is entered I want the cursor to return to the StartDate field. How would I go about doing this (& in which event...

I have a field cboStartHour which gets it's rowsource from a value list. I want to be able to clear the field if the cancel button is pushed. Can someone help me with this? Thanks, Tamra

I have a form to request usage of a room (type). Required information is Office user is in (i.e. Accounting) and then 2 POC fields (Submitting & emergency) the lists for the POC fields are limited to those who belong to the Office chosen. The cboOffice works, The POC field query is: SELECT...

I know I have been at this too long... What seemed simple is now confusing me. I have a form Which lists a type of room cboroomtype (lg, med, tiny) This works I want a subform (datasheet style) that will list all the room names of the type chosen in the cboRoomType The files look like: Room...

I have a form to that requires a user name it's a combobox. I want to be able to double click on it if the user doesn't exist to bring up the user table & enter a new record. I took this code from the microsofts "resource scheduling" database template. In that database when I double click on...

I am trying to create an ADO recordset from a table that exists within the current database, when I execute the code I get: Run-time error '3709': The connection cannot be used to perform this operation. It is either closed or invalid in this context. the code is: Dim rstData As...

I am trying to run a query based on a value entered on a form the field on the form is cboRoomType, row source is : SELECT [room Type].roomTypeId, [room Type].roomType FROM [room Type]; ' this displays the named type of room, but the roomtypeId is what is stored in the field I am trying...

I need to use a subform so a user can request the use of a room and connect it back to another table that contains other information about the request. Unfortunately the user can enter multiple dates & time periods (non contiguous) so the form would look like DateStart TimeStart Date End...

I need a form that will enter user information username, type of room needed, reason. Once this information is entered, I want to create a reference # for the request & save that data to a table. so main for would look like: name room type reason reference # (hidden & calculated) (at this...

I want to have a form that requests data, but I do not want to update the records in the associated table(s) until all the fields have been entered. How can I do this?