Search results

  1. M

    after update issue

    Thanks Plog :)
  2. M

    after update issue

    Im not very experinced atthis and 'self taught' so ...
  3. M

    after update issue

    Guys, Im almost embarrased to ask this but it has bugged me for over an hour. On a record I have Item1 to Item8 and corespinding Quantity figures. so Qty1 to Qty8 All I am trying to do is, if for instance the field Item2 is not null then AfterUpdate Qty2 with the value 1 (that is going to be...
  4. M

    Conditional Formatting greyed out

    Guys, Why is my copy of access graying out Conditional formatting when I am in desing view for reports? Help :)
  5. M

    Make Visible

    I have a check box on a form. I'd like, when it is selected to make a field ( A text box ) called [DanGo] visible on the report generated [rptConsignNote] only when the check box is checked. I hope that makes sense.
  6. M

    After Update

    I could do that but I have 10 colleagues who use the system and they re.. lets say, less that reliable. Currently the font is light grey and can only be viewed from directly in front of the screen.
  7. M

    After Update

    Actually it is not a drop down but a field on the main form. The medicines are selected from a drop down box and this the updates the rest of the form with the details of that medicine. The prescribing details are in a sub section of the same form. It is not a sub form. The rest of the...
  8. M

    After Update

    OK ... I have a database with medicines in stock with storage data. There is embedded in this form an area for prescribing medicines and printing a medicine label. On this area there is a field "Patient" which is the name of the guy I'm giving the medication to. Id like an AfterUpdate...
  9. M

    Countdown Timer

    i have a field on the form with the time countdown to tell the user how long they hve before the application shuts him down. We have power issues where I work (on an oil rig) and if the programme is left running it can corrupt the database. Sorry for not beign too clear :(
  10. M

    Countdown Timer

    I have a countdown to close timer on a form. I can only make the countdown in seconds and 20 minutes is a lot of seconds. Can anyone help me convert this to minutes and seconds please? Private Sub Form_Timer() TimeCount = TimeCount + 1 Me.txtCounter = 1200 - TimeCount If...
  11. M

    Gerated Record Numebr

    Call me a looser but I'm calling it quits. I have been fighting with this for a couple of hours and its time to go home . its 5:30pm here Thank you very much for trying for me. This is the second or third time you have helped me. Thank you
  12. M

    Gerated Record Numebr

    The number is not too important at present. I have set it at 345 at present, during the design phase. I can reset it later. I tried to put it into the control source with no effect ( yes I remembered the =) I'm thinking about dropping the year to be honest. I'm starting to think its a nice to...
  13. M

    Gerated Record Numebr

    It's in the format property of the Consignment Number field on the form
  14. M

    Gerated Record Numebr

    Like this "PUK-NWI-OHS-"&[Consignment Number]& Format( [ConsgnDate],"-YY")
  15. M

    Gerated Record Numebr

    Thanks Bob, all I get is #Name?
  16. M

    Gerated Record Numebr

    I have a database and I am struggling to format the appearance of an AutoNumber to comply with the company standard as an example it should appear like this PUK-NWI-OHS-325-19 The AutoNumber in this is the 325. However, I cannot format this to pin the year on the end I'm using...
  17. M

    Font Size

    Thank you for trying YouTube let me down.. its normally very good
  18. M

    Font Size

    Thanks Dave, Unfortunately it is an older version of access (V3.0) and my system hates it and wont open it.
  19. M

    Font Size

    data not date d'oh... sorry
  20. M

    Font Size

    Hi guys and ladies, I have a report with a large date field that has an address in it. Is there a function that I can use that will increase the font size to fit all of the available space in the field?:banghead:
Top Bottom