User Profile

Collapse

Profile Sidebar

Collapse
learnaccess3
learnaccess3
Last Activity: Feb 12 '10, 09:32 PM
Joined: Jan 29 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • learnaccess3
    replied to Field is based on Expression and can not be Edited
    in Access
    Dear NeoPa,
    Sorry for the late reply.
    I have notunderstood what I have done wrong. I have asked teh question. Do I hv to post in some other section b4 posting.

    Sorry for the inconvenince caused.

    While retriving a 5 bfields form a table (Out of which 2 fields are say Name,Address shd be editable, other 3 shd be non-editable.) ..

    This is not an expression based query no calculation is involved...
    See more | Go to post

      Leave a comment:

    • learnaccess3
      started a topic Field is based on Expression and can not be Edited
      in Access

      Field is based on Expression and can not be Edited

      I am using a simple query (i.e.) select query taking soem fields , & binding with the controlsource property of the textbox. But I am unabel to edit the same same .Erroe Message when try to enter in that box "Field is based on Expression and can not be edited" .

      After clicking on button I am dispalying teh data on 1 form, but some of teh fields only I need to edit & not all.


      Request your ...
      See more | Go to post
      • learnaccess3
        replied to Need a Query...
        in Access
        Dear Nico,

        The issue got resolved. Thank you very much.

        Regds
        See more | Go to post

          Leave a comment:

        • learnaccess3
          replied to Need a Query...
          in Access
          Thanks Nico. Will it work IF I need to take out teh value of Extract_Dt from another table with the same crieria.
          See more | Go to post

            Leave a comment:

          • learnaccess3
            started a topic Need a Query...
            in Access

            Need a Query...

            Dear Team,

            I need to write a query from one table say Employee in MS Access
            Following is Structure :
            Name,
            Emplyee Date of Birth = dd/mm/yyyy
            Extract Date= dd/mm/yyyy

            In this table Extract date field value will be same through the all rows. This field be refreshed after every 1 month.
            I need to take Month & Year from this field (Say Field Value for Extract Date is “11/30/2010”)...
            See more | Go to post
            • learnaccess3
              replied to Like Opertor is not working in MS acces-Retun error code 3021 -eith EOF OR BOF is tru
              in Access
              team,

              Sorry for mis-spelling, In the code it is right, now again I have searced on the net. For DAO we need to put * & for ADO we can use %.

              Now it is wokring. Thanks for u r help Stewart.

              Sorry for the inconvenince

              Regds
              Amogh...
              See more | Go to post

                Leave a comment:

              • learnaccess3
                started a topic Like Opertor is not working in MS acces-Retun error code 3021 -eith EOF OR BOF is tru
                in Access

                Like Opertor is not working in MS acces-Retun error code 3021 -eith EOF OR BOF is tru

                Dar team

                need u r help

                I am new to aceess . I am writign a query in access for finding the last name mathcing with criteria using Like operator.
                Code:
                selct a,b,c from Table1 where last  name like '*"&  Paramter value &"*'
                When in debug mode I can see teh in immediate window teh query and when i put this query in query window in access it is returning the
                data also which is very good...
                See more | Go to post
                Last edited by Stewart Ross; Jan 29 '10, 04:44 PM. Reason: Please use the [code] tags provided.
                No activity results to display
                Show More
                Working...