User Profile

Collapse

Profile Sidebar

Collapse
geraldinegrieve
geraldinegrieve
Last Activity: Dec 16 '08, 03:46 PM
Joined: Jul 17 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • geraldinegrieve
    replied to DateDiff
    in Access
    Thanks I already have conditional formating just wanted the message as form opened but thanks a million for that info would make perfect sense
    See more | Go to post

      Leave a comment:

    • geraldinegrieve
      replied to DateDiff
      in Access
      Thanks a million for this I got it working so as if criteria is on first record then it gives message but if criteria is in any other record message doesn't appear until you click into the record so so close
      See more | Go to post

        Leave a comment:

      • geraldinegrieve
        replied to DateDiff
        in Access
        That was also my understanding of it, but maybe I am putting it in the wrong place i have it in the Form oncurrent and it is not taking the criteria into consideration it is giving back all 3 messages regardless of dates
        See more | Go to post

          Leave a comment:

        • geraldinegrieve
          replied to DateDiff
          in Access
          Date Diff

          Thanks for replying so quickly I did try an Else if but only does 1st message if true and stops and if 1st message not true then 2nd gets displayed and stops. I am not clear on your advice 3 seperate if statements because i did try that but all messages at all dates appeared Thanks in advance
          See more | Go to post

            Leave a comment:

          • geraldinegrieve
            replied to DateDiff
            in Access
            Macro

            I have now tried this in a macro and works ok if 1st record holds the true data but not if it is the 2nd or any other record e.g.
            Condition ([tax_renewal_Dat e]-Now())<15 Action Message Box
            Condition ([MOT_renewal_Dat e]-Now())<15 Action Message Box
            Condition ([Insurance_renew al_Date]-Now())<15 Action Message Box SO CLOSE but not quite correct
            See more | Go to post

              Leave a comment:

            • geraldinegrieve
              started a topic DateDiff
              in Access

              DateDiff

              I have a table in access that holds data on vehicle there are 3 fields holding dates on MOT, Tax and Insurance renewal I am looking for 3 different messages on opening if date of any is within next 2 weeks e.g.
              Code:
              If DateDiff("d", Me.MOT_Renewal_Date, Now()) < 15 Then
    MsgBox "Vehicles Due MOT Renewal", , "Renewal Due"
    If DateDiff("d", Me.Tax_Renewal_Date, Now()) < 15 Then
              ...
              See more | Go to post
              • geraldinegrieve
                started a topic Lookup field
                in Visual Basic

                Lookup field

                Hi I have a lookup field in a able which I know now I shouldn't have but is there any way I can query this field by text rather than number e.g I have a field "Type of Training" which I would like to ask for First Aid but have to enter the number 3.

                Many Thanks for any assistance
                See more | Go to post
                • geraldinegrieve
                  replied to Unique Id
                  in Visual Basic
                  Many Thanks for that sorry I didn''t reply sooner but out of office for a few days...
                  See more | Go to post

                    Leave a comment:

                  • geraldinegrieve
                    replied to Unique Id
                    in Visual Basic
                    I just using the version from within access...
                    See more | Go to post

                      Leave a comment:

                    • geraldinegrieve
                      replied to Unique Id
                      in Visual Basic
                      I am using Version 6.3...
                      See more | Go to post

                        Leave a comment:

                      • geraldinegrieve
                        replied to Unique Id
                        in Visual Basic
                        sorry for being such a pest but how and where do you mean format([uniqueID])...
                        See more | Go to post

                          Leave a comment:

                        • geraldinegrieve
                          replied to Unique Id
                          in Visual Basic
                          Thanks for your reply I am tryint to set it up in a unique id field on a form was thinking about dividing in 2 e.g. prefix and id but don't know how to generate leading 0's...
                          See more | Go to post

                            Leave a comment:

                          • geraldinegrieve
                            started a topic Unique Id
                            in Visual Basic

                            Unique Id

                            I have a unique ID that looks like this ABCD0000ID e.g 3 letters, 6 digit number with leading zero's and I want to increment number by 1 each time automatically, but with a text format this doesn't seem possible. Any help much appreciated .
                            See more | Go to post
                            • geraldinegrieve
                              replied to Creating a unique order number using auto increment.
                              in PHP
                              Hi badvoc

                              Just happened to come across your question and is exactly what I am looking for would there be any chance you still have the code. Thanks...
                              See more | Go to post

                                Leave a comment:

                              No activity results to display
                              Show More
                              Working...