Search results

i want to let it run

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 was looking at the datepart(). And it is fairly simple for me to evaluate whether or not the start date or the end date are part of the current week, but what about the days inbetween those days.

I think I might have misexplained or I misunderstand your answer. What I need to do is see if any of the days involved. I.E. start date, end date and every day in between are part of the current week/month/quarter

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

Thanks for the quick response How would I do the others? This week, Next Week, This Month, Next Month, This Quarter, Next Quarter, This Year....

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

Not sure if this is problem as access is at a higher priority than outlook.

It turns out I am an idiot the issue is that sometimes these fields are null, and when they are null I get the error in the subject line. How do I fix that?

The IIF is not associated with a mouse over. It is the control source of a textbox in a continous form. It evaluates to fields that are part of the record. The mouseover is the glitch. With outlook open the text boxes remain blank until the user hovers over them. If outlook is open and the...

It does work in the immediate window. It also can work with outlook open but the user has to hover over the control. If the user hovers over the control to quickly it will evaluate incorrectly. However, if it the user hovers over each block slowly it will work. If out look is closed it...

it is outlook 2007

no it is just open. If I close it the IIF works, but if Outlook is running it does not

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

I did.. I took all the lines out and put them in one at a time. These three lines give me the syntax error in expresion '#'. Those lines are basically identical to all the other lines so I don't know what I am doing wrong. All three lines are tied to a date field, and the text boxes associated...

The issue seems to exist with the highlighted lines 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]...

I did not figure this out, but just mde three different recordsets to achieve what I wanted.

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 = #" &...

Sorry for not specifying. The other statements you wrote is true. I still do not understand why it works in query builder and not in the .openrecordset