Conditional Format Hyperlinks
Feb 23, 2005Because they are more efficient, I am using hyperlinks to connect my forms. I want to be able to deactivate hyperlinks based on criteria that are selected.
Please help! :o
ADVERTISEMENT
Conditional Formatting Format
Apr 18, 2006Hi,
I am trying to place some code in the "expression is" section of conditional formatting. Need some help converting from code to conditional formatting format.
I have set up a check box "Check83" next to a standard control box "Title(O)".
Below is the code I am currently using. This code is in the after update section of the check box, and in the oncurrent section of the form.
This code turns the box blue when I click the check box.
Private Sub Check83_AfterUpdate()
If Me.Check83 Then
Me.[Title(O)].BackColor = vbBlue
Else
Me.[Title(O)].BackColor = vbWhite
End If
End Sub
My form has 46 records and all have check boxes linked to the control box with the code above. When the box is blue in record 1, I don't want there to be a blue box in record 2. Can't figure out how to do this. Tried to do in with code, but failed. Thought it may be possible using conditional formatting.
Thanks in advance for your help
Jcwishart
Reports :: More Than 3 Conditional Format
Dec 2, 2013I have a report with a list of employee names (and other information). A handful of them need to be a different color (other than default). There will always be more than 3, so I can't use the conditional formatting tool.
View 14 Replies View RelatedConditional Format Based On 2 Fields
Jan 24, 2008Hello All,
I have searched the forum but I don't quite get what I am looking for.
I have a subform that has these 2 fields:
- Status
- LastFollowup
What I want is if the Status shows "Pending" and the date entered on the LastFollowup is more than 7 days. Then it should turn Yellow.
I tried this code in the expression box but it doesn't seem to work
[Status]="Pending" and [LastFollowup]>7
Could anyone please assist? I know this is simple but it's not working for me.
Thank you
Conditional Format A Comman Button?
Dec 7, 2005Quick question.
I have a continuous form in Access 2003 listing products for return for a customers. I am in the process of creating a completion form which will just have the product number, model number and then a command button called complete.
What I'm doing is have it so when the person clicks the button it adds a value to a field saying Complete. OK. But, what I then want it to do is for any record thats associated with this customer where the field = complete to have the command button gray out.
Is this possible? I know I can conditional format a text box to do this but can't see a way to do it with a command button? Any ideas?
I have though of layering a transparent button and having a textbox behind this with complete in and having this change colour but not sure if thats the best way?
Conditional Format - Form Background
Mar 24, 2006Could some kind person out there help me out please?
I have been 'dabbling in' the area of "conditional formatting", particularly in the area of changing the colour of my active form based on the result of whats input on a text box. I have had some success in this area but where I am getting confused is getting the colour of my form to change on the basis of what is entered into a text box control that does not match exactly. My form background changes to the required colour when its value is 'set exactly' or matches, but what I am trying to achieve is to change it according to the first letter of entry regardless of what follows thereafter? It always starts with a letter, either a ‘D’ or ‘V’ to indicate whether its ‘Vital’ or ‘Desirable’ and is subsequently followed by no more than 6 numbers and finally a letter. Basically I need my form to change colour based on the whether it is either a ‘V’ or a ‘D’ irrespective of what follows???
What I have been using so far is:
Private Sub Model_Number_AfterUpdate()
If Me.Part_Number = "V111145K" Then
Me.Section(acDetail).BackColor = 12632256 'Light Red
Else
Me.Section(acDetail).BackColor = 8421631 'Blah Gray
End If
End Sub
.................................................. .................................................
Private Sub Form_Current()
If Me.Part_Number = "V111145K" Then
Me.Section(acDetail).BackColor = 12632256 'Light Red
Else
Me.Section(acDetail).BackColor = 8421631 'Blah Gray
End If
End Sub
Your help would be gratefully appreciated:confused:
Thanks Very Much
Carol
Conditional Format All Fields In ACTIVE Record
Feb 1, 2005:D I am using a continuous form, and I cannot figure out what conditional formatting expression to use to change controls in the ACTIVE RECORD.
For example, continuous form may have:
RECORD1: Field 1 Field 2 Field 3 Field 4
RECORD2: Field 1 Field 2 Field 3 Field 4
RECORD3: Field 1 Field 2 Field 3 Field 4
When I am in Field 1,2,3, or 4 in RECORD2, I want Fields 1,2,3 AND 4 to change color in RECORD2
PLEASE HELP!
Modules & VBA :: Conditional Format Excel Export?
Dec 11, 2013I'm exporting a query to Excel, and I want to be able to conditionally format certain rows of the export using Access VBA. Is this possible?
View 1 Replies View RelatedGeneral :: Fields On Form - IF Then Conditional Format
Jan 14, 2014I have a field on a form OrderDate and a field DOB. I am not sure how to create an expression in conditional formatting that:
=IF([DOB] - [OrderDate] <30), Then background is red
So if the OrderDate is 1/1/2014 and the DOB is 1/15/2014 then the DOB field turns red
If the OrderDate is 1/1/2014 and the DOB is 2/29/2012 then the DOB field does not turn red.
Conditional Format Based On Previous And Current Record
Feb 4, 2005I'm having trouble with a tricky conditional format in a continuous subform.
The criteria is based on field [GroupNo] when it changes (increases) which are always listed in numerical order.
Basically all I want to is for the text box colour to alterante (eg blue & yellow)when GroupNo changes value
So it would look something like this....
Group NoID (highlight colour)
1 (yellow)
1 (yellow)
1 (yellow)
2 (blue)
2 (blue)
2 (blue)
3 (yellow)
3 (yellow)
etc etc
btw, although values will always be in order they may not all be output, so it's not just case of odd, even, odd, even (that would be too easy!)
I can retrieve the Previous Record's GroupNo value (via a function) in another text box and compare current GroupNoID with this in the Format Expressions and manage to change the colour, but it won't sustain this new colour for the subsequent same GroupNos, obviously as the values have changed.
So how can I....
Change the colour when the value changes.
Keep this new colour until it the value changes (increases) again.
Many Thanks
Conditional Format Form Based On Text In Txtfield
Sep 14, 2006Hi All,
I'd lile to show/hide selected subforms based on the the text in a txtfield.
The text in the selection field (txtSelect) I'd like to use for that may be either one of the following:
book-01, book-02, book-03 etc OR,
folder-01, folder-02, folder-03 etc OR,
record-01, record-02 record-03 etc. OR
it can be just a 4 digit number.
If the txtSelect contains "book" I'd like the subfrmBookdetails to be visible.
If the txtSelect contains "folder" obviously the subfrmFolderdetails etc.
What I'm struggling with is the If-Then statement for selecting the partial text in txtselect.
I've tried things like this:
On current
me.txtSelect.setfocus
if me.txtSelect.text="book*" then
me.subfrmBookdetails.visible=true etc etc.
No joy.
I know how to get this to work in a query with a like-statement but I have not been able to find anything on this in relation to conditional formatting of a form. Any one and good ideas?
Thanks,
Walter
General :: Set Up Conditional Format To Highlight Any Dates Within January Red
Jun 17, 2015I have a report and i'm trying to set up the conditional format to highlight any dates within January red.
View 1 Replies View RelatedReports :: Conditional Format Date Field For Current Month
May 20, 2014I have a short date field 5/20/2014
I would like to set up a conditional format to format those fields in the current month. For example, this month is would format all fields with "5".
Next month all fields with "6"
In the month space.
I can't seem to figure out the expression, I know I'm close.
Forms :: Conditional Format One Field To Alter A Second Field
Jun 26, 2015Have a continuous form with 2 date fields in each record .
If dateField1 is empty ,Then I want a way to make DateField2 Take its Place .
I know how to make things happen with conditional formatting on one field by UsingIsNull ,I have tried sending datefield2 to back.But cant work out how to bring it to front If DateField1 IsNull.
HyperLinks?
Jan 20, 2006Hey all,
I have a table for my documents and I have to add all these documents which need to be entered into the table, is there a faster way then right click edit hyperlink and go through the folders and find the file? Since I have a lot of doc this will take a while so I was wondering if there was another way? Thanks
Hyperlinks
Jun 4, 2007Help please. I would like to be able to create a browse button that will allow the user to find a file that when they click ok on the browse window is assigns the file to a hyperlink .
I have used the following code to open a dialog box which works fine and puts the file name in the hyperlink field on my form however when I click the hyperlink nothing happens.
Dim strFilter As String
Dim strInputFileName As String
strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")
strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input file...", _
Flags:=ahtOFN_HIDEREADONLY)
Me![txtFile] = strInputFileName
any ideas
Hyperlinks That Don't
Feb 28, 2006A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://".
Alternatively, be pleased to know the code to concatenate "http://" onto the urls.
Hyperlinks
Dec 20, 2004I am trying to link to a specific page in a word document from my Access database. I pretty sure I've done this before, however my brain doesn't seem to want to retrieve that information at this time. Does anyone know how to do this?
Thank you!
Jamie
HyperLinks?
Jan 20, 2006Hey all,
I have a table for my documents and I have to add all these documents which need to be entered into the table, is there a faster way then right click edit hyperlink and go through the folders and find the file? Since I have a lot of doc this will take a while so I was wondering if there was another way? Thanks
Hyperlinks
Sep 14, 2006Hi all
in my table, i have a field type set to hyperlink.
I'm sending a hyperlink address to the table using ADO.
the control property is set to hyperlink yes on the form.
i then display the captured information in a subform data sheet with the filed property set to hyperlink yes. It displays as it should (in blue and underlined) ... but the hyperlinks aren't working. I click on it and nothing happens. If I right click on the hyperlink and "edit" the hyperlink address is missing.
But...
If i go into the table and reset the field to text, save it and then reset it back to hyperlink.... presto is all seems to work. Now when I edit the hyperlink... the address is there. Weird!!
something isn't right. I shouldn't have to do this. I'm being driven mad.
Any ideas??
HyperLinks... ?
Feb 16, 2007Hi,
I am new to Access, what is the hyperlink feature in Access ?..is that used to store hyperlinks in their native form ?, am creating a small application where a column is a hyperlink column, this when output to the page should take the use to the correct link. It's part of a news feed program.
I have the forms/HTML all done up to accept and to store the info, it's only the display area that i have a problem with. There are 3 cols in the db, one is an ID, one is a short desc, and the last one is the URL (this is the actual hyperlink).
Hyperlinks
Aug 22, 2007One more question....
I created a table with one field being a hyperlink
I created a query to query out specific fields including the hyperlink.
I then create a subForm on a form and point to the query.
Everythign works great except the Hyperlink.
It just stops working....I can Delete the Hyperlink field and recreate it then delete the subform and recreate it and it works once....
But then Stops....any thoughts...
I dont know what else to do...I am currently returning multiple records into a Subform based on a query. I did it this way becuase I can click individual fields, including the hyperlink fields.
If I use a List Box then I can select the whole row.
AnYone know why the hyperlinks stop working...or can throw another idea out there of a better way to do this.
Hyperlinks
Oct 8, 2007Hi,
I have a database I use at work. We have to manual enter in the the hyperlink eg "h:quotes12345.doc". I was wondering if Access can do this for us.
I tried to use the combine function eg [open quote] = "h:quotes"&[Quote No]&".doc". This does appear to work it has the the text in blue and underscored but when you try to click the link nothing happens.
Any ideas on how to get this to work.
Regards
Mike
Hyperlinks And Access
Jun 23, 2005Hi,
I am a newbie at Access and this forum. Here is the question I have a database set-up in Access'97 which recently got converted to Access'03. Now previously database reside on my computer and I have a field that holds hyperlinks to documents which were set as relative paths. Now the database has been moved to another location..where ofcourse the relative path don't work, as the parent directory is different. There are a huge number of records in the database with hyperlinks. I need to convert all relative path to absolute paths. Is there an easier and faster way of doing this? Perhaps via a query? I don't want to do this one by one.
Thanks in advance for your help.
Automate Hyperlinks?
Sep 20, 2006I have a database of chemicals and one of the entries is the MSDS number. I would like a hyperlink, pointing to the .pdf of the chemical, created when I enter the MSDS number. If the MSDS number is 1111 the .pdf file will be something like (\servernamefolder1111.pdf). Is there a way to store \serverfolder in a string, append the MSDS number, and .pdf then store that in a hyperlink field. Any suggestions?
View 3 Replies View RelatedEntering Hyperlinks
Jul 13, 2005I have a form in which the user must put in a description in a text box. Within the description, the user will have to reference a PDF file that he will put a hyperlink to. Is this possible for him to do?
View 1 Replies View Related