Recent content by ozzy68

Thanks, I figured that out earlier today, shortened it as you stated, and put the code in the after update control...works like a charm!

Thanks for the reply, However, I'm not using record sets. cboEmployeeName has three additional columns (full name, last name (column 1), first name (column 2), and work area (column 3)) the full name is used to make it easy for the scheduler to choose an employee. The other three columns are...

Hello forum, I am running into a wall and desperately need assistance. I have a form that contains a combo box (cboEmployeeName) that pulls data from a query and populates three text boxes (Work Area, Last Name, First Name), This part works fine. Because the text boxes are being populated by...

I will give that a try, thanks!

Can I use a subform combo box to update data in a text box on the main form?

I have run into a bit of a problem while attempting to create a form to update a table. Initially my form “frmTrainingScheduler” worked perfect, but after receiving feedback from users to make it more user friendly, I decided to make some changes. On the original form the user would choose a...

Thanks for the reply. That layout is really simple, it is a single table that lists the course ID, course title, and student/s that are scheduled. There are a number of other related fields as well. I have created a query based on the table, the query works to pull the data that I want, but it...

Hello all, I am attempting to create query results based on fields with multiple values, and populate a report based on the result of the query. The report is a class roster and the fields in question are "CourseID" and "StartDate". The goal is to pull all data from "trainingSchedule" table that...

Mr.B, Thanks for the reply, I am restricted to using Access 2003 where I work but I was able to get it working the way I wanted. I keep telling them they need to upgrade to at least 2007 because it would make life much easier in regard to working in Access...maybe some day...

Thanks for getting back to me... There are may fields of information, LastName is one of the fields for each row. So the best way to answer your question would be to say that I am creating a new record each time I populate the form. So, if I were to select two names from the list box, and...

Hello forum, I have a form that I use to populate a table that schedules and records training events for employees. I have many combo boxes that I use to populate most of the fields in the table, and one list box that I want to use to select one or more employee/s to add to the table. When I...

LOL, as soon as I read your reply I knew what the problem was...target field data type was "NUMBER" but the format was not "FIXED". it is working now, thanks for jogging my memory!:)

I have searched the threads and tried solutions but none of them have worked thus far, this is why I am asking the question again. I have a combobox on a form that I use to select a decimal number (.5, 1.0, 1.5, 2.0, 2.5, etc.) sourced from a query, the query source is a table field containing...

I have created a query that has several fields of data, one of fields is "CourseStateDate", the records under that field are "short date" format. I would like the query to produce only those records with "CourseStartDates" from Monday of the current week and looking four weeks into the future...

Got it, thanks!