Search results

the last two items are comparing a combo box with a field in a table both fields are numbers and both combo boxes bound columns are number fields

now it says data type conversion error. Dim misc_update As Recordset Set misc_update = CurrentDb.OpenRecordset("SELECT tbl_instructor_dates.InstructorID, tbl_instructor_dates.InstructordateID, tbl_instructors.Instr_rank, tbl_instructors.Instr_lname, tbl_instructors.Instr_fname...

ok if i put the sql into the query builder it works, but if I put the sql intoo the vba in th eon current event of the form i get the datatyoe mismatch error?

whats name of the ID field on your forms? is it ID? If it is I would name it something more meaningful and then add the docmd.openform in each of the if statements

I checked all the fields and all the fields are bumbers, and the field in the where is a number and the combo box from the where statement is bound to a number field. still saying data type mismatch

I dont understand how I could be getting a data type mismatch in a select query. Set misc_update = CurrentDb.OpenRecordset("SELECT tbl_instructor_dates.InstructorID, tbl_instructor_dates.InstructordateID, tbl_instructors.Instr_rank, tbl_instructors.Instr_lname, tbl_instructors.Instr_fname...

correction: If I add conditional formatting you have to hover over it. If I just set the =IIF statement as the control source you have to click on the field for it to show up How do I get it to load automatically

ok i got it to work mostly. what I did wah use DCOUNT to count how many req where in each chapter, and then another DCOUNT to see how many that particular student had finished. I then used IIF statement to see if the number they have finished is less than then total number of requirements...

The requirements will vary and can honestly be anything. The condition will always be whether or not the cw_date has a value. If it has a value the req is complied with. The issue I am having is I am listing the chapters with a label that says completed or a label that says not completed...

Here is the issue I am having. I have a continous form that displays different chapters students have to complete for different courses. So the forms list changes when you select a different course. I.E. Chapter 1 Chapter 2 Chapter 3 Now each chapter have different requirements to be...

thank you that worked great

How do I set a combo box to default to first in list?

Thanks it worked great!!! Way simpler then I thought it would be

What I want to do is have the the insert query run one time for each record in the recordset that I pull. I have never done anything like this before so I am posting the code I have so far and would like someone to help me out. Private Sub Command2_Click() Dim instr_block_reqdb As Database...

DJkari that worked perfectly thanks a lot!!!

I have one form that is capable of being opend from two locations. First- there is a button to add an instructor appt Second- there is a link in the instructor profile page I only want to have one add new form. The easiest way for me to do this is if the individual clicks the add new link...

Yes I did... I apologize fo rnot updating this earlier but I found the problem although I don't understand why it was causing the error. The problem was with the next line. And I replaced the "." with an "!" between the table and column name. ", " &...

Bob thanks that worked, VbaInet, I think I have normalized my db. I am attaching a copy tell me what I have messed up.

currentdb.OpenRecordset("select * from tbl_list_281_types where tbl_list_281_types.281ID = [Forms]![frm_create_instructor]![Combo1]") It says its missing an operator in the where statement

I am including all of this becauseI dont know what the error means. I bolded the text that is highlighted by access. ElseIf Combo21 = "yes" And Combo1 <= 1 Then CurrentDb.Execute "INSERT INTO tbl_instructor_dates" _ & "(Instructorid, dagb, 281type, fisddue...