A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can Access 2007 Do this???



 
 
Thread Tools Display Modes
  #1  
Old October 13th, 2009, 05:14 PM posted to microsoft.public.access
Blueliner975
external usenet poster
 
Posts: 26
Default 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  
Old October 13th, 2009, 05:47 PM posted to microsoft.public.access
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default 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  
Old October 13th, 2009, 06:22 PM posted to microsoft.public.access
Blueliner975
external usenet poster
 
Posts: 26
Default 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  
Old October 13th, 2009, 06:58 PM posted to microsoft.public.access
Jackie L
external usenet poster
 
Posts: 148
Default 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  
Old October 13th, 2009, 08:09 PM posted to microsoft.public.access
Blueliner975
external usenet poster
 
Posts: 26
Default 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  
Old October 13th, 2009, 08:31 PM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old October 13th, 2009, 08:58 PM posted to microsoft.public.access
Blueliner975
external usenet poster
 
Posts: 26
Default 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  
Old October 13th, 2009, 09:34 PM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old October 13th, 2009, 11:44 PM posted to microsoft.public.access
StopThisAdvertising
external usenet poster
 
Posts: 334
Default 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  
Old October 14th, 2009, 12:56 AM posted to microsoft.public.access
Blueliner975
external usenet poster
 
Posts: 26
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.