Conditional Format A Comman Button?
Dec 7, 2005
Quick 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?
View Replies
ADVERTISEMENT
Aug 28, 2005
I have a startup splash screen with a "OK" button, similar to Nortwind database. The OK button works as far as opening my switchboard page. But how do I get the Splash screen to close after I click the OK button? So I can see my switchboard page.
View 2 Replies
View Related
Apr 18, 2006
Hi,
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
View 3 Replies
View Related
Feb 23, 2005
Because 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
View 3 Replies
View Related
Dec 2, 2013
I 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 Related
Jan 24, 2008
Hello 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
View 6 Replies
View Related
Mar 24, 2006
Could 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
View 1 Replies
View Related
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!
View 5 Replies
View Related
Dec 11, 2013
I'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 Related
Jan 14, 2014
I 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.
View 8 Replies
View Related
Feb 4, 2005
I'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
View 14 Replies
View Related
Sep 14, 2006
Hi 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
View 2 Replies
View Related
Jun 17, 2015
I have a report and i'm trying to set up the conditional format to highlight any dates within January red.
View 1 Replies
View Related
Sep 15, 2005
I have created a Media Contact Database and have a few issues that I believe are probably related to something I have done wrong. I am kind of a novice and I can't see my error and was hoping some one could look at my DB and see where I have gone wrong
1. on Company info form have added a dropdown box to select media type and it fills in on table a number instead of the actual word Eg. "Radio"
2.on contacts form when I save a new record it says "Microsoft jet database engine cannot find a record in the table 'media types' with key matching fields 'mediatype ID'
3.Also on contacts table when I select from dropdown box "Company Name" it works but if I try to change again it errors and won't let me change unless I close form and go back into record.
4. I am trying to create a report on company info with contacts related to this company as there can be many contacts to one company. but when i create a query including both table I only get company info if there is a contact associated with it. Sometimes there will be no contacts associated with company.
I will attach database so you can look at. I have worked many hours on this and it seems when I get one thing working another goes wrong. I know it seems a lot but I think its small issues that I just can't see. Any help would mean the world.
Thanks Rickilynn (ricki.kleinfelder@gov.ab.ca)
View 1 Replies
View Related
May 20, 2014
I 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.
View 4 Replies
View Related
Jun 5, 2006
I am trying to make a form that will append when you click on the button I have made, but i want to make it so that the form wont let you append the table until you have filled a few "Required" fields.
I am new to VB and am pretty much clueless, please help!
View 2 Replies
View Related
Feb 3, 2005
Hi All
Is it possible for a command button to appear on a form only if a certain condition is fulfilled ? Otherwise it is invisible. The condition would be that one of the field entries on the form must equal a specific value.
How might I make that happen ?? (I'm a beginner !)
NoVoiceLeft
View 1 Replies
View Related
Jul 17, 2005
Hello there,
I was wondering if any of you experts out there know a way to help me out here.
I was wondering if it is possible to color the text on the last pressed button on a continuous form different from all the others, so people will know which one they pressed last?
I've been trying a lot of different things here but i'm stuck. All i can get done is that all the buttons turn a different color, but doesn't solve anything.
I hope some of u can help me out here.
Greetz,
And thanx in advance,
Rutger
View 7 Replies
View Related
Jun 26, 2015
Have 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.
View 3 Replies
View Related
Nov 3, 2006
Hi
Please help me,
I have the form, in this form there is list of value which run query and resulting the report. For example if I have 5 item in list, i have to choose one of then and the query running and the report is print preview.
My question is,
How to export all 5 report to 5 sheet in one excel file.
I know may be the problem in format if I send to excel, but I will fix it in the excel. The most important is, I export the report to excel, each of the report in each of sheet of excel.
Thanks in advance
sorry my english is not good.
View 2 Replies
View Related
Jun 7, 2006
I'm almost "there" with what I'm trying to do in Access.
I knew this bit would be tricky - perhaps a guru can help me here. :-S
I've taken screen shots of what I'm attempting to do to help describe the situation. (Go easy! It's the first DB I've ever done :-s)
Basically, I need a button on the "Company Job Summary" page that will let me print out one selected record from the job summary shown.
More importantly - I need it to come out looking like the form shown in the "Job Sheet View" which I have set up as a form that gets it's info from both the "Customer" database and the "Jobs" Database.
The Job sheet is controlled by a "Job ID" number - unique to each job.
What's the best way to approach this?
You help, as always, is much appreciated.
Thanks :D
View 8 Replies
View Related
Feb 17, 2014
I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
View 2 Replies
View Related
Jul 30, 2013
I have a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.
datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.
View 2 Replies
View Related
Jul 7, 2015
I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).
str = Format(Me.word, xxxx)
View 3 Replies
View Related
May 4, 2012
I am exporting data from access 2007 to Excel 2007 using VBA code. I have a whole number, which I want displayed as whole number. But after the export, the number is using the 1000's seperator in Excel. So for example if my original number in access table is 12000, it is showing up as 12,000 in the excel file.It has something to do with the NumberFormat property. I have tried doing this but doesn't work.
objSheet.Range("A1:A7").NumberFormat = "General"
View 2 Replies
View Related
Mar 2, 2012
We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?
View 3 Replies
View Related
