Search results

thanks nellie i just noticed it was hoping to delete before i looked crazy stupid

This is really bugging me CurrentDb.Execute "INSERT INTO tbl_instructor_dates" _ & "(Instructorid, dagb) " _ & "(" & instridrs![instructorid] & " " & _ ",# " & [Forms]![frm_create_instructor]![Text23] & " #;)"

Is it possible to change the linked table information of one db using a different db.

Recently I created a batch fie to make it easier for coworkers to "install" the front end of my db. I am wanting to take this idea a step further and not sure how to proceed. First, I want an access db that I can open on a cd-rom where a user can browse to the directory they want the back end...

I know this is a small problem but is bugging the hell out of me. Everytime my combo box has a value selected and it doe snot have focus the bgcolor for the box becomes transperent, or at least matches the bgcolor of the form. How do I make this stop

I want to change the border properties of a subform based on information in a query. I.E. normal student no border Bay Chief - yellow floor chief - red How would I do this in vba? in the onload event? and what vba code would i use.

nevermind i got it thanks

so do i just type the same code in the form? or is there a way for me to retrigger the on load event?

I have a form that shows information about a course. if you click on the "edit course info button" a pop appears to edit the info once you edit and hit submit the update query runs and then the original for should requery but it does not. here is the requery code...

damn i am stupid

Damnit now I am getting a missing operator error. CurrentDb.Execute ("UPDATE tbl_courses " & _ "SET tbl_courses.COURSENUM = '" & [Forms]![frm_createcourse_edit]![Text7] & "' " & _ "tbl_courses.COURSEDATE = #" & [Forms]![frm_createcourse_edit]![Text3] & "# " & _ "tbl_courses.COURSETITLE = '" &...

so it would look like this #" & [form]![DateField] & "#

That Worked thanks. One more question. Do date/time fields require single quotes?

Still getting the syntax error in UPDATE statement CurrentDb.Execute ("UPDATE tbl_courses" & _ "SET tbl_courses.COURSENUM = '" & [Forms]![frm_createcourse_edit]![Text7] & "' " & _ "WHERE tbl_courses.COURSEID = " & [Forms]![frm_createcourse_edit]![courseid] & ";")

tbl_courses.COURSENUM is a text field tbl_courses.COURSEID is an auto number primary key Is this what you mean?

Syntax error still. Sorry about the misunderstanding

Still not working here is the exact code from my db. CurrentDb.Execute ("UPDATE tbl_courses" & _ "SET tbl_courses.COURSENUM = " & [Forms]![frm_createcourse_edit]![Text7] & " " & _ "WHERE tbl_courses.COURSEID = " & [Forms]![frm_createcourse_edit]![courseid] & ";")

This is really staring to anger me. I can't seem to get the syntax correct for this query. CurrentDb.Execute ("UPDATE tbl_courses" & _ "SET tbl_courses.COURSENUM =[Forms]![frm_createcourse_edit]![Text7]" & _ "WHERE tbl_courses.COURSEID)=[Forms]![frm_createcourse_edit]![Courseid];")

also what do I use to go to a new line while writing vba code?

I am sorry to admit the previously I always have made update querys in access and then called them using the runsql command. I have always done this because I dont understand the syntax for update querys. can someone please assist me. below is some code I just attempted in my db that is not...