Search results

I have my sql field in ## marks for an update query written in VBA. ",tbl_instructor_dates.isdcw = #" & [Forms]![frm_instructor_misc_info_update]![ISDcw] & "# " & _ It works fine as long as the field is not blank. Unfortunately if the field is blank it equals null and gives me an error...

All I am trying to get dcount to work in the query builder. In the below example [BLOCKID] is supposed to be from the current record of the query. I can't get to work. count2: DCount("[REQTYPE]","tbl_instructor_req","tbl_instructor_req.BLOCKID = [BLOCKID]")

I have a query that has two date fields start date, and end date. I need to write criteria to see if either of the dates, and any day in between these dates are part of the current week/month

I want the title of my report to list the date in the title. I.E. Unavailable Instructors for 06 Mar 12 I tried this: ="Unavailable Instructors for " & now("dd-mmm-yyyy") I also need one for this week, next week, this month, and next month,this quarter, next quarter, this year, next year...

Below is the IIF statement I have as the control of text box. If Microsoft outlook is closed it works perfectly. If Outlook is open then it does not work until the user mouses over the text box. Is the a known glitch...

CurrentDb.Execute ("UPDATE tbl_instructor_dates " & _ "SET tbl_instructor_dates.dagb = #" & [Forms]![frm_instructor_misc_info_update]![DaGB] & "# " & _ ",tbl_instructor_dates.[281type] = " & [Forms]![frm_instructor_misc_info_update]![281_type] & " " & _ ",tbl_instructor_dates.fisdcw = #" &...

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...

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...

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

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...

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...

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...

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.

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...

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];")