F011
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 33 articles for 0.304 sec
For the now() it is working. The problem is when I tried to also consider the Cont. "BruceM" wrote: > Try using Date() rather than Now() > > "Chey" <Chey@discussions.microsoft.com> wrote in message > news:B9640B3B-F011-49E6-A45D-ADBD0164321F@microsoft.com... > >I am trying to have an expression that displays for all current contracts > >the > > word > > Current and for expired the     

Group: microsoft.public.access · Group Profile · Search for F011 in microsoft.public.access
Author: Chey
Date: Sep 16, 2008 10:05

Are you sure that is what you want? If the contract end date is = now, that would mean the contract date has already passed and should indicate the contract has ended. First, I doubt you should be using Now. Now contains a specific time component and may cause some date comparisons and calculations to return results different from those you expect. For example, the DateValue function
Show full article (0.79Kb) · Show article thread
Ugh. You can't use the DateValue function on a field containing non-date values, which means that this cannot be made to work other than by writing a VBA function to do it. You can't even wrap it in another Iif to test first whether it's a date, because both parts will still get evaluated so you'll still get an error. The real problem, however, is your design. Trying to force dates and     

Group: microsoft.public.access · Group Profile · Search for F011 in microsoft.public.access
Author: Klatuu
Date: Sep 16, 2008 09:57

Try using Date() rather than Now() "Chey" <Chey@discussions.microsoft.com> wrote in message news:B9640B3B-F011-49E6-A45D-ADBD0164321F@microsoft.com... I am trying to have an expression that displays for all current contracts the word Current and for expired the word expired. But for the current ones I also need to consider the Cont. (continuous contract, never expires). I have
Show full article (1.50Kb) · Show article thread
----- Looking to wrestle ----- Boise/Idaho, Globalfight Personals: flaggy2000 City: Boise State/Country: Idaho Age: 24 Taste: Gay Prefers: I would like to meet someone close to my age I am looking for someone to wreslte with just for fun. Have been interested in wreslting for years, but never had the opprotunity. --------------------------------------     

Group: microsoft.public.access · Group Profile · Search for F011 in microsoft.public.access
Author: bcap
Date: Sep 16, 2008 09:53

Hi, you can not open report within the form, as I understand you, you can use a subform instead of report -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com "Scott Dufour" <howaredoing@solutions.com> wrote in message news:BF9AF75B-F011-4D8D-B3A0-94A8070E3782@microsoft.com... Hello Alex, Sorry that I was not a little more clearer in
Show full article (1.29Kb) · Show article thread
OK, good luck. -- Gary VanderMolen, MS-MVP (Mail) "gstanford66" <gstanford66@discussions.microsoft.com> wrote in message news:63B72A64-F011-469C-B2AD-AE31CABD6D38@microsoft.com... > Yep, same error. I didn't used to get this error. It's only happened within > the last two weeks. I'll give them a call. > > "Gary VanderMolen" wrote: > >> So your Internet connection was being provided     

Group: microsoft.public.access · Group Profile · Search for F011 in microsoft.public.access
Author: BruceM
Date: Sep 16, 2008 09:42

"Lurcherman" <m0afj@dsl.pipex.com> wrote in message news:76895996-f011-45dc-a5f6-7dee1c792278@w7g2000hsa.googlegroups.com... On Jun 20, 11:55 am, Walt Davidson <g3...@despammed.com> wrote: On Fri, 20 Jun 2008 03:16:35 -0700 (PDT), Lurcherman <m0...@dsl.pipex.com> wrote: <snip> Have a good weekend, just trying to find out how to combine 3 x 37.5kW, 4-32MHz broadband amplifiers to
Show full article (0.64Kb) · Show article thread
"Lurcherman" <m0afj@dsl.pipex.com> wrote in message news:76895996-f011-45dc-a5f6- >Have a good weekend, just trying to find out how to combine 3 x >37.5kW, 4-32MHz broadband amplifiers to give me 100kW to try to upset >a plane!, anyone got any suggestions? I suggest that it is a diversionary tactic to draw attention away from your habitual rudeness and repeated criticism of you for your rudeness     

Group: alt.personals.bi · Group Profile · Search for F011 in alt.personals.bi
Author: bounce
Date: Sep 11, 2008 20:59

Show full article (28.14Kb)
    

Group: sci.military.naval · Group Profile · Search for F011 in sci.military.naval
Author: tankfixer
Date: Sep 6, 2008 21:38

Show full article (0.39Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba.ado · Group Profile · Search for F011 in microsoft.public.access.modulesdaovba.ado
Author: Alex Dybenko
Date: Aug 12, 2008 03:08

Show full article (1.62Kb) · Show article thread
    

Group: microsoft.public.windows.vista.mail · Group Profile · Search for F011 in microsoft.public.windows.vista.mail
Author: Gary VanderMolen
Date: Jun 24, 2008 15:47

Show full article (2.20Kb) · Show article thread
    

Group: uk.radio.amateur · Group Profile · Search for F011 in uk.radio.amateur
Author: Steve Terry
Date: Jun 20, 2008 08:32

Show full article (0.69Kb) · Show article thread
    

Group: uk.radio.amateur · Group Profile · Search for F011 in uk.radio.amateur
Author: 12 WPM Class A
Date: Jun 20, 2008 04:11

Show full article (0.50Kb) · Show article thread
1 · 2 · 3 · 4 · next