Search results

Would binding the combo box to the second column instead of the first help any?

Ok, so I was looking at the properties for my Course Registration table. I see the control source property when I look at the form I use to enter or modify registrations. The control source is set to CourseTitle. The CourseRegistration table uses CourseID as the data source for the Course Title...

Row Source: SELECT [Courses].[Course_ID], [Courses].[CourseTitle] FROM Courses ORDER BY [CourseTitle]; Can I add a control source property here? or where?

Ok just checked the properties for that field, and Bound Column is 1. Is this the issue?

Some things I had read on other sites had led me to think that might be an issue as well. My database is pretty mature now, can I change that without corrupting other forms/queries/etc.

Hello, I have a training database that I have set up and utilize to track attendee data and who is registered to which course. I have a course registration table that has a course title field which is a drop down list populated by course titles from the courses table, and a trainee id field...

Hmmm.... My courses will not always have the same number of seats available. Each course is different which is why I have the two values. But I see what you are saying. I am somewhat familiar with creating the calculated field in a query. I would like to learn more about the practical...

Ok, I have a Courses Table. In this table I have two fields Seats Available and Seats Remaining When I register a student to a Course in the Courses table I would like the corresponding Seats Remaining field for that course to decrease automatically. I can, of course, run a report or a...

I actually ended up using a combo box. While it is not exactly what I was looking for I was able to fiddle with it enough to make it meet my needs. Thanks.

I don't know if a combo box is appropriate here because there are over 600 records wich would make for a very long combo box. Also the values are arbitrary, and wouldn't be easy to identify.

Thanks, I had thought about this, but I wasn't really sure where to build the query. Can I use the expression builder through the event tab in the properties window for the Dealer Number textbox, or do I have to build a specific query? Also if I use this meathod, if the data entered in the...

Hello, I am a novice Access 2007 user. I am working on a form that registers new training attendees. One of the fields in my form asks for dealer number. I have a separate table where all the dealer information is stored. One of the fields is a Customer Number field I want to ensure that...