Search results

  1. M

    Story

    in his kecks?
  2. M

    Story

    thermo nuclear explosions
  3. M

    Test for Field IS NULL on Form

    Thanks Rich Toby
  4. M

    Test for Field IS NULL on Form

    I am tring to test is a field is null on a form. If it is null I want to preform an action. However I am having problems checking to see if the form is null. The code I have is IF me.cbo_TrancheNo (isnull) then me.cbo_trancheNo.requery This Obviously does not work I am hoping for a few...
  5. M

    confirm changes

    Thanks Rich et al - this is perfect
  6. M

    confirm changes

    I have a form currently if someone moves off the form it automatically saves changes what I sould like to do is if someone makes a change on a form the tries to move a message box appears asking them to confirm changes or not...
  7. M

    Looping REcords on a form

    I have now managed to get this to work using CurrentRecord
  8. M

    Looping REcords on a form

    I am attempting to export data from my database and create separate data files for each record. I have created a form, and I am attempting to export all the records in the filter applied on that form. (This would depend on the dataset required at the time). I have attempted to do this by...
  9. M

    Error Message "Module Not Found"

    I have now resolved thios problem by going to a backup at 12:30 today and rolling the data forward.
  10. M

    Error Message "Module Not Found"

    I have attempted to do a repair on the DB but with no luck.
  11. M

    Error Message "Module Not Found"

    Hi, I need your help, some how my database has got corrupted, new when ever I try and navigate using the buttons on the forms I get an error "Module Not Found". I have been using "event procedures" to call VB code to open the next form. Any help would be greatly appreciated
  12. M

    Story

    made of poo
  13. M

    Number of Fields in a query that are not null

    Mile/Cable We seem to be getting our replies slightly out of synch. :eek: Thanks for the help I will check out you suggestions this afternoon let you know how I get on...
  14. M

    Number of Fields in a query that are not null

    I can post the structure of the two tables, whoever the query I run shows the correct information I just wish to know which fields within that data have not been completed yet? If you believe that supplying the table structure would help with this problem I am happy to oblige, I am just unsure...
  15. M

    Number of Fields in a query that are not null

    Yes that is all I am trying to do, the database is normalised, I just have blanks where no data has been entered yet.
  16. M

    Number of Fields in a query that are not null

    Sorry I will try and try explain more fully. We are collecting data from different sources and populating the database. I have created a query that displays the records that we are particularly interested in and shows that attributes we have collected so far. (This is the one described above)...
  17. M

    Number of Fields in a query that are not null

    So what are you saying? That it cannot be done ?
  18. M

    Number of Fields in a query that are not null

    we are collecting data on system/server attributes currently I guess about 80% is completed, However we have not collected data on all the attributes hence the fields are blank.
  19. M

    Number of Fields in a query that are not null

    I have created a query that gives me results of records from across two tables. Currently it returns about 450 rows and 16 columns. What I would like to-do is find out what the number of the fields within the query that are null (or filled in). I guess there is a simple way to do this. Thanks...
  20. M

    Boolean Display Values in Union Query

    I have created a union query, The query works correctly the only problem is that one of the fields types in the query is Boolean, The query now displays “-1”and “0” rather than “Yes” and “No”. I understand why it is showing “-1” and “0”. However is there a way I can get the query to display the...
Back
Top Bottom