Recent content by beefwellington

I fixed my Query by changing "NOT EXISTS" to "Time <>". I wanted to post this in case anyone searches the forum for the same problem I was having. Me.ddlAppointmentTime.RowSource = "SELECT Time FROM TimeList WHERE Time <> (SELECT Appointment_Time FROM AppointmentLog WHERE USPAdvisor_ID = " &...

I think we need a little more information. Are you trying to get the most recent date? If that's the case, you'd want to do MAX(Plucked_Days) to return the most recent date.

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

ahh Format... I was thinking it'd be under Data but that makes sense. Yes that worked. This saves me sooooo much work thanks.

I'm a little confused. So this is what I have now: RowSource = SELECT LastName + ", " + FirstName + " - " UniversityID FROM Students ORDER BY LastName; Bound Column = 1 How would I increase my column count and set its width? I don't see any option for this under the combobox property sheet

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 love you guys :P It works like a charm after I did both of your suggestions :D Thanks!!

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

The textboxes "DateStart" and "DateEnd" have the date AND time as their value. DateStart's default value is "Now()-30" and DateEnd's default is "Now()". I used Format() so I could store just the date of "mm/dd/yyyy" (i.e. 8/26/2009 instead of 8/26/2009 9:01:16 AM) so that when it looks up the...

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

"Debug.print sql" I will have to remember to use in the future. boblarson: You were right it was a reserved word so I renamed DateTime to DateTimeLogged and it works fine now. That's the first time I made that mistake.

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 tried all these but no dice. :( UPDATE: OK so I found out the SQL query never grabs the field "LocationName". This was my mistake. I'm working on a database thats a few years old and the person who made it no longer works here. I'm still figuring out there system but thanks for the help...

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