Recent content by poucedeleon

CL_London, the actual goal was to have the "Notes" control visible if any selection is made in (cboHospClearReason), so I used the following code which is working. Private Sub cboHospClearReason_AfterUpdate () If IsNUll (Me.cboHospClearReason) Then Me.chkReturned.Enabled = False...

I was able to get it to work. I added the column count. Private Sub Form_Current() If Me.ComboboxName.column (1) = "2nd Item" Then Me.CheckboxName.Enabled = True Else Me.CheckboxName.Enabled = False End If End Sub

Will this code work in Access 2010. I copied the code just as you have written it changed the name of the cbo box and the checkbox, but the checkbox will not become enabled.

I have uploaded a copy of the database. I plan on splitting the db. The VisitOfc will be used in reception of the building and the VideoVisit will be used upstairs. They both hit the same data. Thanks for the help.

Thanks Adam, the part I am lost on is how to count the records for each day and hour. I think I can get the formatting part once I can fiqure out how to count through the records. Below is the code I tried, but no luck. For i = 1 To 34 If Me.Controls("CelCnt" & i) = Null Then...

I have a form with 34 text boxes on it. (These represent each visit booth available.) When the form opens it only looks at the current day. I would like to have a code that loops through each visit for the day and hour and turns the textboxes red and adds the text “FULL” as visits are scheduled...

Thanks Dave, I will look at it. I am very close to get the other one to work. I am getting a popup because I changed the name of a field and can not find the reference anywhere, (small problem) I added a combobox for time "InputTime" on the frmInputBox. I basically copied the setup of the Select...

Bob, Not sure if this one will do what I need. I am scheduling lots of people in multiple places for the same time. I need to see how many visits they already have and can't schedule more than one a day. It may provide some insight on how to deal with the time. Thanks for the info

Thanks Bob, I am not sure if that calendar will work for what I need. I am scheduling lots of people for the same time, but it might lend some insight to getting the time to work for the db I post. Again Thanks for the info.

I am working on a calendar that I got from Oxicottin http://www.access-programmers.co.uk/forums/showthread.php?t=161087 I have kind of deconstructed it a bit, since I am using it to schedule visits instead of attendance. I am trying to get time on the calendar. I have added a cbobox on the...

Oxicottin, I would like to try and use your Calendar in a "Visiting Schedule" Program. I must admit I am not a very good programmer although working at it each day. I noticed there have not been any post in awhile on this, so I am hoping you will be open to some questions and advice. Let me...

Modest, Is there a more current version of this App? We use XP machines with most having Office 2007, although all of our db are 2003.

Record Sort using Time/Date, that crosses midnight Nigel thanks for the explaination. You are right I did quote the wrong section. It was your post I wanted to inquire about. I wanted to ask if I should have fields in my table that hold the values for dtefullstrt & dtefullend. It took me a...

Record Sort using Time/Date, that crosses midnight Nigel, Can you explain this part of your Code. The one thing I did not put in my post is I am new to VBA (Probably never heard that before:D) so if you could give me a little more info I don't understand the part about "Input a field in Date...

Record Sort using Time/Date, that crosses midnight The purpose of this application is to log Arresting officers coming into our facility. The Booking Assistant logs the time arrived, the officer’s name, the prisoner’s name, the time they give us their paperwork and the time they leave. The...