Recent content by colinmunnelly

  1. C

    Very very simple calculated field prob

    thanks very much. I managed to sort the problem by doing the calculation in a query. But appreciate your reply.
  2. C

    Very very simple calculated field prob

    Yes sorry they are the bound fields and also the names. The ref towas a mistype it should have read procurement_impact.
  3. C

    Very very simple calculated field prob

    I have a really simple problem regarding a calculated field on a report. It is: I have a 2 fields on a form that show the a number of days each. These fields are works_impact and procurement_impact. I want to make theses fields invisible and place a text box simply to add the two figures...
  4. C

    Change Access Icon

    Does any one know if it is possible to change the icon of an access batabase. I have selected an icon within the startup menu and this changes the icon to the top left hand cornere when i am within the program. What i want to change is the icon that appears on the users desktop.
  5. C

    calculated field question

    Thanks alot Mark
  6. C

    calculated field question

    I have a report that lists instructions received together with the days it will take to carry out the work. I need to create a calculated field that simply shows the greatest or highest number of days on the report. Is this possible?
  7. C

    Simple if, then problem

    thanks alot. I understand now. Learn loads on here!! Thanks again
  8. C

    Simple if, then problem

    thanks works well. Any idea why the original didn't work.
  9. C

    Simple if, then problem

    Thanks for your reply. Still a problem though. If text69 is null the message box still does not appear. It opens the form "notice_input_form"
  10. C

    Simple if, then problem

    I am trying to do a nvery simple if, then statement but it doesn't seem to be working as it should. I know the solution must be really simple. Anyone shine some light. Private Sub Form_AfterUpdate() If text69 = "" Then MsgBox ("no impact") Else 'DoCmd.OpenForm "notice_input_form", acNormal End...
  11. C

    Requery List box?

    thanks but cant see the connection.
  12. C

    Can not get my code to save muti selection

    Thanks for your reply. Not sure i can see the connection though.
  13. C

    Requery List box?

    will do thanks very much.
  14. C

    Requery List box?

    Yes sounds like just what im looking for. Is there an example i can see somewhere. Thanks for your time on this
  15. C

    Requery List box?

    I have a multiplke selection list box that passes its value over to a text box. When this is done the user go onto the next record but the list box doesn't reflect what items have been passes to the text box. How do i refresh the selected items in the list box or better still have it show the...
See more
Top Bottom