Search results

I have two tables, one that holds a list of times (8AM-5PM) to use as a rowsource for comoboxes and a table to log appointments. I'm trying to do the following: The user selects and Advisor then a Date. Then the RowSource for the Time of the appointment changes to only show the times available...

I have a combobox with its row source set as the First and Last name and University ID of students (format: "Last Name, First Name - Univ. ID#"). I'd like to have it so when I select a student, I get their Primary Key as the value instead of "Last Name, First Name - Univ. ID#" since this would...

I made a Public Function in a module, called Toolbox, where I wanted to place a lot of reusable code. I have the following function in the module: Public Function test(anInt As Integer) As Integer anInt = anInt + 5 End Function I've tried to execute the function these 2 ways: Dim...

I have a form that when I filter it's subform to only shows results between certain dates like say 7/1/2009 and 8/24/2009, everything shows up fine. I have an entry in the subform that is dated 7/13/2009. When I change the filter to 7/2/2009 - 8/24/2009, it gets filtered out an doesn't show up...

Dim sql As String sql = "INSERT INTO EquipmentLog (EquipmentID, State, User, Comment, Status, DateTime) VALUES ('" & Me.EquipmentID.Value & "', '" & Me.cboNewState.Value & "', '" & Me.cboUser.Value & "', '" & Me.Comment.Value & "', '" & Me.Status.Value & "', #" & Now() & "#)"...

I have a form with a combobox that filters a subform based on the location selected from the combo box. When the combobox "change" event fires off, the follow code gets executed: Private Sub cboSelectArea_FAB_Change() If Me.cboSelectArea_FAB = "All Areas" Then...