Search results

  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...
  16. C

    Transfering multiple list box selection to a table

    I have a list box on a form which looks up the records from a customer names table. When the user selects the customers to be associated whith the current record of the form i need this information to be written in the 'associated customers' column of the form table. Hope someone can point me in...
  17. C

    query problem

    Thanks for your reply but there is no field within the cor_log that notes any outgoing instruction therfore the is null doesn't work. By the way i call the outoing instruction a CMI_Number and COR_Number.
  18. C

    what operating system and office version

    Hope you can help. I want to create a macro to install templates into microsoft office. I need to establish firstly what operating system the user has and then what version of office. This will the dictate where the template files will be stored on the users hard drive. Any suggestions as to the...
  19. C

    query problem

    At the moment i just use the COR_Log as a lookup table really. The only join there is is when i enter and outgoing with the incoming.
  20. C

    query problem

    I have a linked table called (COR_log) This is for incoming orders. I have a main table which holds the data for outgoing orders. Each outgoing order is funded by particular incoming so when entering thje data for an outgoing order i can choose which incoming instruction i want. I need to...
Top Bottom