Recent content by intern42

I have a listbox (lstTookCourse) where a user can select multiple names. There is a "hidden column" that contains a field called "personnelID" which is the primary key for a table. I need to reference this value in a query. In the module, I can access this value on a name...

OK, I forgot that I set an error trap... that's why I didn't get an error message. It's a syntax error in the INSERT INTO statement: DoCmd.RunSQL _ "INSERT INTO CoursesDates (courseID, dateOffered, time, hours, seats) VALUES (" & Me!cboCourse & ", #" &...

Same thing. It displays all message boxes BEFORE the DoCmd.RunSQL command, but nothing AFTER that command. Weird.

I checked that, and unfortunately, I matched everything up. Here's the SQL command: DoCmd.RunSQL _ "INSERT INTO CoursesDates (courseID, dateOffered, time, hours, seats) VALUES (" & Me!cboCourse & ", #" & Me!txtDateOffered & "#, " & Me!txtTime & &quot...

I'm trying to run an INSERT statement on a form and it doesn't work... I've done this same thing on several other forms with no problem, the only difference is with this INSERT, I'm inserting into a table who's primary key is an auto number. So for the INSERT, I only listed the other columns...

Thanks. That helped. I forgot to drag the checkbox item onto the form. Gotta love Mondays.

I have a Yes/no field called "required" that comes up as a checked or unchecked box when I reference it in a report. For my latest report, I had to build a query that combined 3 different SELECT statements with the UNION command. In the report I generated from this query, the...

That's it man!! Thanks a TON. That was the LAST bug I had to work out of this application. Much appreciated.

That looks good, but I now get the error: Run time error 3075: syntax error (missing operator) in query expression '[RecNumber] = & 1'. when this line of code executes: IsKey = DLookup("[CountOfRecords]", "Key Exists", "[RecNumber] = & 1") "Key...

Thanks Bob. I know how to dimension variables, my problem is how do I get the results of this SQL statement: SELECT COUNT(*) FROM PersonnelCourses WHERE PersonnelID = Me!cboPersonnel AND courseID = Me!cboCourses; This query will return a one-cell table with either a zero or a one in the...

I'm using an Access 2000 database and need to check the value of a table to decide on an action to perform. Basically, I have an SQL query that returns a one-cell value of either 1 or 0. If the value is zero, I need to add a row to a table; if the value is one, I need to update a row of a...