conditional formating in Access

how to use Max funciton for conditional formating in Access form
0
Utf
3/7/2008 9:43:00 AM
access.forms 6864 articles. 2 followers. Follow

1 Replies
1140 Views

Similar Articles

[PageSpeed] 29

On Fri, 7 Mar 2008 01:43:00 -0800, sudyl wrote:

> how to use Max funciton for conditional formating in Access form

Max of What?

Select the control. 
Click on Format + Conditional Formatting.
Select Expression Is
As the expression write:
[ThisControlName] = Max([ThisControlName])
Select the colors wanted.
Save the change
-- 
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
0
fredg
3/7/2008 5:23:16 PM
Reply:

Similar Artilces:

Access OWA during exchange offline
Dear All AS we know, we can access Our inbox (via Ms Outlook) during exhange server down or offline. My concern is, can wee access our inbox or calendar during exchange server is offline? thank you.. In news:%23YTtmu97FHA.2036@TK2MSFTNGP14.phx.gbl, Muhamad Taufik Khasim <Taufik@uniten.edu.my> typed: > Dear All > > AS we know, we can access Our inbox (via Ms Outlook) during exhange > server down or offline. > My concern is, can wee access our inbox or calendar during exchange > server is offline? > > thank you.. No.....only when your mailbox is accessibl...

UPC calculating works in excel but not in access
Hi, ive build a query using the following module to calculate the check digit (using mod 10) of an 11 digit upc number. In excel i can use the same module to calculate the check digit on a 13 digit upc code but in access it doesnt work. Here is the vba (i didnt write it but found it to use on the internet) Option Compare Database Function Format_Upc_String(InString As String) As String Dim OutString As String Dim Multiplier As Integer, Sum As Integer, i As Integer Dim CheckDigit As Integer ' ' Initialize the sum to zero ' Sum = 0 ' '...

Conditional Picture?
Does anybody knows how to insert one picture that changes without use intervention everytime the result of another cell changes? eg.: If the cell A1="Alex" the cell A2=Picture of Alex. Then if change the cell A1 to "Mike" the cell A2 displays the picture of Mike -- Message posted from http://www.ExcelForum.com Hi Alex This macro example from this group a long time ago you can use. The jpg files must have the same names as the number you type in cell "a1" Change the path to the files in the code. Place the code in the Sheet module Right click on a sheet tab ...

Vista Access 2003 & Ole
I have a DB I've been using, updating for several years. I use a = different BMP on every record. Today I started to update it again. Last = update a few weeks ago on my XP. Today I went with 'insert object' 'create from file'. with XP I couldn't = use JPG's so I made bmp's. Today even a bmp is just an icon. How do I get the create from file to work again ? --=20 more pix @ http://members.toast.net/cbminfo/index.html ...

How do i fix this error in access
I created a database in microsoft access. I have been trying to open some of the forms that I created but after several tries I keep getting this error message "Not enough memory. Please close un-needed programs." Can someone please help in fixing this. I created 13 forms and 8 of the forms are opening but the other five forms arent. I get the above error when I try. I have uninstalled and re-installed microsoft office several times, and no other programs are opened when I get this error. Any help is appreciated. Thanks Alicia Alicia, unless you actually do have too man...

Identifying remote Outlook Access
Scenario. I am running outlook 2002 on NT4.0 connected to exchange mailbox on exchange 5.5/2000. Is there any way I can identify whether the Administrator or exchange Admin has my mailbox open on his PC or is accessing my mailbox via his security access. Can i tell on my PC. Is there something left locally on my PC that will tell me. No, you can't. Why the suspicion? -- Roady [MVP] www.sparnaaij.net Microsoft Office and Microsoft Office related News Also Outlook FAQ, How To's, Downloads and more... Tip of the month: -Create your own fully customized Toolbar Subscribe to the...

Not Recognized Format
I've written large workbooks with excel xp, but at home I am using excel 2000. Is there any way to convert the xls file format that xp uses so I can work with the spreadsheet at home? Thanks, Alan All versions of Excel since 97 use the same file format, so no conversion is necessary. If you can't open the file, it is probably corrupt. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SKLwater" <sklwater@bellsouth.net> wrote in message news:VBcSc.9398$5i4.2838@bignews3.bellsouth.net... > I've written lar...

Custom cell formatting
I need to create a custom format for a series of cells that will begin like this. I can't figure out what the code character is fora volitile potentially alpha character. Can anyone help me?? -Monica, Dallas 000000 000001 000002 .... 000009 00000A 00000B 000010 000011 ...... Monica something like this might work for you but you'll need to put all the leading digits in for the entry with the alpha character Regards Trevor "MDavison" <davison@fr.com> wrote in message news:#SD0tUzTEHA.1652@TK2MSFTNGP09.phx.gbl... > I need to create a custom format for a series ...

Date Functions & Formatting
I'm putting together a spreadsheet showing personnel recurring training dates and whether they are overdue or current in that training. I have about 100 people with about 50 different training requirements that are recurring on different timelines (ex: Mark Smith has to take CPR class every 20 months and a driving course every 12 months). I'm trying to develop a function/format combo that lets me type in the date they last had that training, paired with the required frequency of the training, giving me a result of "CURRENT" or "OVERDUE" and turning the...

CreateDatabase / Access 2007
Hi all, Question: Can Access 2007 be forced to create an Access 2000 database when using CreateDatabase? I have a "utility" database that I distribute in version 2000 to users which is used to extract data from their main database (also version 2000) and which then creates and dumps this data into a new database ("Homedata.mdb"). This new database can then be zipped up, emailed, and uploaded into our central database. The basic procedure is: Data is extracted from the user's main database; placed in tables within the "utility" database; "H...

Stingray's MFC Objective Grid with Access 2K?
Has anyone had success using Stingray's Objective Grid v7.0 with the later versions of DAO. I've seen the suggestions to add an entry to my source to force MFC to use the later version. But, when I do this, I get a lot of crashes after compiling. I wonder if there are any mods that must also be made to the Stingray source? Thanks, Jack ...

Keyboard hooking through Accessibility
I am looking for a method to hook the keyboard without running a background process. I know there are APIs for hooking (SetWindowsHookEx), but I want to avoid the overhead of running another background process for this and make the task do by windows itself. I am thinking of tweaking the Accessibility option in windows for this. Can we anyway do this by writing any script or modifying or adding registry entries for Accessibility? Or is there any Accessibility specific APIs which can re-program the Accessibility feature to do our tasks when we press a key with Accessibility feature-on. An...

how to improve shared mailbox access from branch office
Hi, Our organization has consolidated all mailboxes to centralize location. A team of shared services specialist who often work on the shared mailbox encounter performance issues when trying to access the shared mailbox due to the shared mailbox are being accessed over the WAN in online mode. The shared mailbox is attached as a secondary mailbox to their personal mailbox. Personal mailbox does not have this issue due to all are configure to use Exchange cache mode. We have proposed to user Terminal server nearer to the centralize location and Outlook Web Access but the team...

unable to access mail after re-enable account
Hi, After enable an disable account and change its password, it can login to its mail account. What's happening. Is it normal? Thanks a lot What is the error message when user tries to access mailbox? Does the user still show in ADUC has having Exchange attributes? Have you looked at the MB using ESM to see if it is disconnected? "Raymond" <anonymous@discussions.microsoft.com> wrote in message news:136c01c46f11$d16f8390$a301280a@phx.gbl... > Hi, > > After enable an disable account and change its password, > it can login to its mail account. What's hap...

Formatting
I've always used MS Word as my email editor in Outlook. Is this possible in Live Mail. Nope. I'm afraid that's only possible using Outlook. In WLM you have to use the built in editor. Is there anything in particular that's lacking from the built in editor that you're looking for? Colin Brown WL MVP "jrchambe" <jrchambe@discussions.microsoft.com> wrote in message news:5EC21892-D39F-4219-AB0F-47BC14E1CD36@microsoft.com... > I've always used MS Word as my email editor in Outlook. Is this possible > in > Live Mail. "...

Formating
Hi, In a Column 'A' sales Commission is calculated and resulta is as 250, 200, 300, 330. I wanted to format a cell with a Blinking colours where value is 100 to 250, 250 to 300, 300 to 350 and 350 & above. please help to format my sheet ... thanks Ismail, Getting your cells to "blink" is not in the standard Excel formats What you want would require some extensive programming, certainly, ou of my capabilities. However, there are some great things you can do with Excel' CONDITIONAL FORMATTING. Let's say in column A you have numbers that are the result of formu...

Pivot Table formatting #6
When I format my pivot tables I have "preserve formatting" checked under "PivotTable Options", and "Autoformat Table" unchecked. Even so, I either lose portions of my formatting, or different formatting is applied when I refresh. Does anyone know what I am doing incorrectly or have any other suggestions? Thanks, Phil Other things to try -- if they don't work, you could record a macro as you refresh and reformat the pivot table. Then, run that when you want to update. --Instead of selecting the cells to format the numbers, right-click the field but...

how to turn off automatic format in Excel?
Hi Excel automatically change the first character in a cell to be uppercase. I just want lowercase. How can I turn off this function? Thanks Ngoc Hi Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence. Andy. "ngoc" <linh@chello.no> wrote in message news:BOKNb.271$O41.819@amstwist00... > Hi > Excel automatically change the first character in a cell to be > uppercase. I just want lowercase. How can I turn off this function? > Thanks > Ngoc > ...

Date Format turn to Year
Hi, I tried to convert the date to YEAR and then the year plus 25 Years later. =Year(A1) I'm getting the result 1900 instead of 1965. I tried to add 25 years later to 1990 from 1965. Your help would be much apprecated. Thanks What's in A1? Are you sure it's a real date? "learning_codes@hotmail.com" wrote: > > Hi, > > I tried to convert the date to YEAR and then the year plus 25 Years > later. > > =Year(A1) I'm getting the result 1900 instead of 1965. > > I tried to add 25 years later to 1990 from 1965. > > Your ...

Problem access variable in On Format
Hi, I'm using Access via Office XP Pro. I am trying to format the Zip Code on the detail line of my report. I have tried the following lines of code in both the On Format event and the On Print event: If len([PostalCode]) > 5 Then : : end if or if len(Me.PostalCode) > 5 Then : : end if In both events and either code, I receive the error message: Access can't find the field 'PostalCode' referred to in your expression. If I put "PostalCode" as the source of the report's control...

Background changes conditionally
Hi all, I have a spreadsheet that shows the floor plan layout of my call centre. On each desk, the desk number and identity are displayed. I would like to colour the background for those pcs that are on the same subnet. I have a sheet called data - it contains Table Number, Desk Number, PC ID, IP Address. How could I get it to change the background colour if the pc is on subnet 162, and set a different colour for those on subnet 167 any ideas? -- PeterG ------------------------------------------------------------------------ PeterG's Profile: http://www.excelforum.com/member.p...

Running an Excel Macro from an Access Command Button
Hi , Can anyone help me with this, I am trying to run an excel macro from an access command button. I want the macro to Bold the Headings on a excel spreadsheet. The code runs without any errors but the macro doesnt seem to work, I think I have got the line ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong The code: Private Sub cmdRunMac_Click() Dim ExcelApp As Excel.Application Dim ExcelBook As Excel.Workbook Set ExcelApp = Excel.Application ExcelApp.Visible = True Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and Settings\...

outlook web access 2003
web page downloads ok to my home 98SE based PC with 5.0 IE browser, but will not load ok with 6.0. The outlook web access program from work is on a 2000 Professional based server. thanks. all other webpages download ok but when i login to this remote email the page hangs up. try emptying the browser cache and if it's still a problem, repost in the owa newsgroup, http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.exchange.clients -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for W...

Opening and formating a CSV file?
Could someone remind me how to handle CSV files please? I had assumed the Text Import Wizard would pop-up when I use File|Open, but the data goes straight into the worksheet. (Presumably because it is not 'delimited'?) Without the Wizard at my side, how do I get each comma-separated field in its own column? -- Terry, West Sussex, UK Try renaming your .csv file to .txt Terry Pinnell wrote: > > Could someone remind me how to handle CSV files please? I had assumed > the Text Import Wizard would pop-up when I use File|Open, but the data > goes straight into the worksheet...

Formatting Cells in Excel 97
Hi Guys, Sorry if I sound real stupid but is there anyway that we can control the column formatting in Excel 97 like let's say column A = GENERAL(6), column B = GENERAL(4), column C = TEXT(18) etc? Appreciate any form of advice, thanks!! I replied in the programming group. Are you seeking a programming answer? It's usually best to only post to one group, and include the remark "Please tell me if I should ask this in another group." On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <daryl.ho@tnt.com> wrote: >Hi Guys, > >Sorry if I sound real stupid b...