Search results for query: *

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.

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

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

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?

How could I put the "Show all Records" command on a timer for a form? What code do I need? OR maybe a better way. Here's my situation: I have a main form, with an invisible subform(linked to a query). The main form has a text box linked to a field on the subform. And I would like the query...

When I link pictures in a form in a OLE object on my computer it will only link the filename(not a picture of the jpg file), but if I do it on my co-workers computer it links the picture. How can I make my computer link the picture & not just the name of the file?

I have a main menu in a program & in the control source for a text box is =Format(Now(),"dddd"", ""mmm d yyyy"", ""hh:nn:ss ampm") but it only keeps the day/time for when the form is opened. how could i keep it synchronized with the computer clock. thanks.

On a form, in 1 text box, how could I type in: julian date-----(three digit day)(last 2 digits of the year) and in another text box return the date. ie. type in 00104 & have it return 1/1/04. Thanks

On a form, in 1 text box, how could I type in: julian date-----(three digit day)(last 2 digits of the year) and in another text box return the date. ie. type in 00104 & have it return 1/1/04. Thanks.

I know there is a button on the toolbar for "Filter excluding selection", but what i would like to do is make a button on the form to run this command. Could someone please help w/ code? Thanks.

i am looking for the code to display julian date on a form. thanks.

is it possible to have a form(not in calendar form) where you enter the date(w/ some other info), then have a report print out in a calendar form, what you have coming on that date. I would appreciate anyone's help.