Recent content by ocan

Is there anything similiar to this faq for Access 2003? Works for 97 not 03. Automatically logging out idle users faq181-1432 Any info would be appreciated? Thanks.

In a query I have a date field with dates(ie.7/7/2010). How can I build an expression that converts the dates to just the year?

In a pivot table, is there any way for a user to be able to change a field value? I want to use for a production schedule purpose. I have a run quantity in a field, but I want production to be able to fill in the actual quantity. I appreciate the help. Thanks.

That works great. Thanks.

still having problems. I'm trying to do this function in a report with a text box Text24=244.1 I want another box(text25) to ready 245 I put in the control source of text 25: ?format([Text24],"#") It gives errors. Am I not putting it in right? or do you have another method?

what is the equivalent of round up in access? Regardless of the number I always want to round up to the nearest 1. I appreciate your help. Thanks, Angie

When I try to compact and repair my database it shows a error that table "Temp MSysAccessObject" already exists. I don't show this as a table in my tables. How can I fix this and get my database so it will compact and repair? Thanks in advance.

I have a continuous form The form setup is: Test Name Test Result Lower Spec Upper Spec Combo box [test result] [Text 118] [Text122] values from query I have to have the Test result a text box because some values are words and some are...

In my 1st message I should of specified there may be situations where [Drum Additive]=-1 and [Units(Blend)]="LBS" and we would need the text box to yield a #. =IIF([Drum Additive]=-1,Round(([Text131]*[LBS per gal])/0.5,0)*0.5) AND =IIF([Units(Blend)]="LBS",[Text142]) And If not text box is...

I have a text box in a report, where the control source is an If statement. =IIF([Drum Additive=-1,Round(([Text131]*[LBS per gal])/0.5,0)*0.5) This works..........but if I want to add a 2nd If statement to this how could I make this work. I want the text box to do: =IIF([Drum...

Perfect. Thank you very much.

I have a query, the query includes 2 fields: Actual Ship Date and Requested Ship Date and I am trying to build an "If" expression to create another field. Expr1: IIf([Actual Ship Date]=Null,[Requested Ship Date],[Actual Ship Date]) The above expression is doing the false part, but not the...

Is there is a function that is equivalent to the MROUND function in Excel that can be used in Access?

The above Me.Recalc works, but I run into 1 problem when that form & another form is open it recalcs both forms. How can I get it to only recalc the 1 form?

Could you expand a little bit on that tip? I would appreciate it.