Search results

  1. O

    Date() function

    Brain, Can you please explain me staep by step how to do it in access 2003 ? Thanks a lot
  2. O

    Null Date 31-12-1899

    I'm trying again, if someone know how to help me, I'll more then be gald :)
  3. O

    Null Date 31-12-1899

    First thanks a lot about your trying to help!! You right, now I can get the correct date - but... still the field that I wnat to be automatic - not get the date after someone enter in the other field data. Do you know why? all I want to do is the field B will get date in automaticly way...
  4. O

    Date() function

    Yes It's only set on DATE\TIME format
  5. O

    Date() function

    Brian Hi, Can you please explain it again, since i did that and it's not working and prbebly I don't do it right. I just tried it again. Can you tell me if you put the event exactly on A? you enter to A - Properties and then what ? Can you write me the exact way, step by step? thank...
  6. O

    Null Date 31-12-1899

    :( I need to publish the database on SharePoint 2007 and it's just synchronize with access 2007.
  7. O

    Null Date 31-12-1899

    Any one have answer for me? :confused:
  8. O

    Null Date 31-12-1899

    Great! Thanks! I'll wait:)
  9. O

    Null Date 31-12-1899

    Hi, Do you have access 2007 ? I'm able to open the file from the Zip. I'm trying to attached it again. Let me know if it's ok now
  10. O

    Null Date 31-12-1899

    Hi, please see attahced. this is just an example "Assign to"= A ( the field that get data from users "Due Date" =B ( the automaticly date field) thank guys!
  11. O

    Null Date 31-12-1899

    Sorry, I tried this but it's not working I can't upload the file with accdb suffix.
  12. O

    Null Date 31-12-1899

    I didn't put defulte value becouse when I do it's automaticlly get the date and I want that it will stay empty until someone enter data in the another field. What I have now is: Form - evetnt: before update: me.[A]= date() In B field control source - A Where A is the text field that will...
  13. O

    Null Date 31-12-1899

    I'm trying to update date field in the current date when other field got some text value
  14. O

    Null Date 31-12-1899

    When I put the format as a general number - I get 1.
  15. O

    Null Date 31-12-1899

    Yes :rolleyes: I hope that ok that I out another thread becouse it's another problem
  16. O

    Null Date 31-12-1899

    Hi All, Can someone know what I need to do for get a real date when I'm using the date() function? I have a task list in a table (access 2007) and I don't know how to initiate that.:confused: Thanks for any help
  17. O

    Date() function

    This is exactly what I done but still, it's not working :confused: I don't understand why I got date for 1899 (31-12-1899) when I call the Date() function. I'm working with access 2007 and I more then be glad if someone can help on the date issue. all the other works (meaning I can make...
  18. O

    Date() function

    Sorry, still don't work. :confused: What should be the code?
  19. O

    Date() function

    Thanks for your answer. Do you have a solution for this case? I'm not so professional in access and it will be very helpful to me. Thanks again.
  20. O

    Date() function

    Hi, I hope that the question on the right form :) I have two fields A and B where B is automatically update after someone enter data to A. I'm working with 2007 version. I put on afterupdate event in field A: B= date() and on control source at B field : A It's work but form some...
Back
Top Bottom