If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Access 2007 Do this???
Im new to this so everything that i have so far has been using the wizard not
coding it myself i have a simple form with 3 tabs so far... i have dates in most of my boxes on the form... i know how to make the date change color if it is expired or past due... is there a way that if date1 is expired i can make it appear on a seperate tab? |
#2
|
|||
|
|||
Can Access 2007 Do this???
On Oct 13, 11:14*am, Blueliner975
wrote: Im new to this so everything that i have so far has been using the wizard not coding it myself i have a simple form with 3 tabs so far... i have dates in most of my boxes on the form... i know how to make the date change color if it is expired or past due... is there a way that if date1 is expired i can make it appear on a seperate tab? Use conditional formatting. |
#3
|
|||
|
|||
Can Access 2007 Do this???
Ummm ... ok how??? lol... im new to this! thank you for the help... i am
going to try to play around with the conditional formatting and see if i can figure it out... if anyone knows exactly how to do what im doing more help would be greatly appreciated Thanks again |
#4
|
|||
|
|||
Can Access 2007 Do this???
First of all, conditional formatting on a form will change the field for all
lines in the detail section so hopefully, you are using the single view (not continuous). You will need to have the field exist in both places. You will just change whether or not it is visible. You can use the same type of code as changing the color except use Visible. IF Forms!frmMainForm!ExpiredDate Date then Forms!frmMainForm!ExpiredDate.Visible = False Forms!frmMainForm.OtherExpiredDate.Visible = True Else Forms!frmMainForm!ExpiredDate.Visible = True Forms!frmMainForm.OtherExpiredDate.Visible = False End IF You will have to work on the syntax if you are using subforms on your tabs. "Blueliner975" wrote: Im new to this so everything that i have so far has been using the wizard not coding it myself i have a simple form with 3 tabs so far... i have dates in most of my boxes on the form... i know how to make the date change color if it is expired or past due... is there a way that if date1 is expired i can make it appear on a seperate tab? |
#5
|
|||
|
|||
Can Access 2007 Do this???
jackie that helps out alot... but if you dont mind taking a minute to break
down that syntax... i have no idea what it means... i understand the concept of it but What is Forms! is that just a generic name or is that going to be the name of my form? is expireddate an actual command or is it the title of whatever my expired date might be so if my expired date box is THEDATE would i replace expired date with THEDATE?? Also where do i edit/add syntax at? Thank you so much for all your help |
#6
|
|||
|
|||
Can Access 2007 Do this???
On Tue, 13 Oct 2009 10:58:21 -0700, Jackie L
wrote: First of all, conditional formatting on a form will change the field for all lines in the detail section Actually, no, it won't; and it doesn't need any VBA code at all. If you select a control in form design view and select Format from the menu, one of the options is "Conditional Formatting". This lets you specify a criterion on the field value (or enter an expression) and change the color or visibility or Enabled status of the control based on that value. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Can Access 2007 Do this???
John thank you for your comment... however... i dont think i can do what i am
trying to do thru the condituional formatting.... please check the original post and if you know how to do that thru conditional fopormatiing please let me know ! "John W. Vinson" wrote: On Tue, 13 Oct 2009 10:58:21 -0700, Jackie L wrote: First of all, conditional formatting on a form will change the field for all lines in the detail section Actually, no, it won't; and it doesn't need any VBA code at all. If you select a control in form design view and select Format from the menu, one of the options is "Conditional Formatting". This lets you specify a criterion on the field value (or enter an expression) and change the color or visibility or Enabled status of the control based on that value. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Can Access 2007 Do this???
First, understand that although you have three tabs, all controls on your
form and all controls on the three tabs are on the same form. A tabcontrol merely "groups" a set of controls on the form. To answer your question, put two textboxes where you want Date1 depending on if it is expired or not. Name the textboxes Date1NotExpired and Date1Expired. Assuming you have another field named Expired and it is a Yes/No field, put the following in the Current event of your form: If Me!Expired = False Or IsNull(Me!Expired) Then Me!Date1NotExpired.Visible = True Me!Date1NotExpired.ControlSource = "Date1" Me!Date1Expired.Visible = False Me!Date1NotExpired.ControlSource = "" Else Me!Date1NotExpired.Visible = False Me!Date1NotExpired.ControlSource = "" Me!Date1Expired.Visible = True Me!Date1NotExpired.ControlSource = "Date1" End If Steve "Blueliner975" wrote in message ... Im new to this so everything that i have so far has been using the wizard not coding it myself i have a simple form with 3 tabs so far... i have dates in most of my boxes on the form... i know how to make the date change color if it is expired or past due... is there a way that if date1 is expired i can make it appear on a seperate tab? |
#9
|
|||
|
|||
Can Access 2007 Do this???
"Steve" schreef in bericht m... First, understand that although you have three tabs, all controls on your form and all controls on the three tabs are on the same form. A tabcontrol merely "groups" a set of controls on the form. To answer your question, put two textboxes where you want Date1 depending on if it is expired or not. Name the textboxes Date1NotExpired and Date1Expired. Assuming you have another field named Expired and it is a Yes/No field, put the following in the Current event of your form: If Me!Expired = False Or IsNull(Me!Expired) Then Me!Date1NotExpired.Visible = True Me!Date1NotExpired.ControlSource = "Date1" Me!Date1Expired.Visible = False Me!Date1NotExpired.ControlSource = "" Else Me!Date1NotExpired.Visible = False Me!Date1NotExpired.ControlSource = "" Me!Date1Expired.Visible = True Me!Date1NotExpired.ControlSource = "Date1" End If Steve -- Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's a shame !!) For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post... We warned him a thousand times... Sad, but he is not willing to stop advertising... He is just toying with these groups... advertising like hell... on and on... for years... oh yes... and sometimes he answers questions... indeed... and sometimes good souls here give him credit for that... == We are totally 'finished' with $teve now... == Killfile 'StopThisAdvertising' and you won't see these mails.... Arno R |
#10
|
|||
|
|||
Can Access 2007 Do this???
Steve... what is the ME! part... is it going to ME! or is it going to be
something else? "Steve" wrote: First, understand that although you have three tabs, all controls on your form and all controls on the three tabs are on the same form. A tabcontrol merely "groups" a set of controls on the form. To answer your question, put two textboxes where you want Date1 depending on if it is expired or not. Name the textboxes Date1NotExpired and Date1Expired. Assuming you have another field named Expired and it is a Yes/No field, put the following in the Current event of your form: If Me!Expired = False Or IsNull(Me!Expired) Then Me!Date1NotExpired.Visible = True Me!Date1NotExpired.ControlSource = "Date1" Me!Date1Expired.Visible = False Me!Date1NotExpired.ControlSource = "" Else Me!Date1NotExpired.Visible = False Me!Date1NotExpired.ControlSource = "" Me!Date1Expired.Visible = True Me!Date1NotExpired.ControlSource = "Date1" End If Steve "Blueliner975" wrote in message ... Im new to this so everything that i have so far has been using the wizard not coding it myself i have a simple form with 3 tabs so far... i have dates in most of my boxes on the form... i know how to make the date change color if it is expired or past due... is there a way that if date1 is expired i can make it appear on a seperate tab? |
|
Thread Tools | |
Display Modes | |
|
|