Recent content by SteveF

  1. S

    Access and the Future

    I struggle with the 'lease' model on these things, I much prefer a world where I buy something and it's mine to keep but the world changes. I'm pleased to find that Access 2007 is still relevant though; a little light in my cynical worldview :) Thanks for input guys; appreciated.
  2. S

    Access and the Future

    Thanks for the welcome :) I'm super rusty but there's nothing complex about the new project at this stage, just a few forms and data storage, so I'll make a start with some confidence that I'm not heading into a technological dead-end; thanks for that.
  3. S

    Access and the Future

    I haven't done anything with Access for a long while but my last big project, a stocktaking DB, is still working like a charm. It's still my daily workhorse and has kept me going for the best part of ten years so absolute kudos to all the knowledgable folk here and the few who I drove potty...
  4. S

    Message Box

    Just tried that and it worked a treat, thanks :)
  5. S

    Message Box

    I didn't think of other things being entered, you have to think of everything don't you? The numbers, 1 - 5 , are stored in a table and queried from there so inputting the number ( I think ) is necessary.
  6. S

    Message Box

    How would that work in the table though? I'm entering the numbers into a table, does a combo box not need a list of stored numbers to pick from?
  7. S

    Message Box

    The message box should appear when the user enters a number higher than 5. The message reads 'please enter a number between 1 and 5' It's a form that is tabbed through and this is a textbox. It's a '5x5' risk assessment so only numbers 1 to 5 should be used.
  8. S

    Message Box

    Need some help with a message box if possible, thanks in advance. I have a text box that the user enters a number into between 1 and 5. I can use the validation rule in the table and that works nicely, the trouble is that I don't want the standard Access message box. I've read through the...
  9. S

    Lookups...

    Resolved I think, forms do the looking up. No need to do it at table level. Thanks John :)
  10. S

    Lookups...

    Thanks for the sample, I like that and can see how it's working I think. It looks to me like the tables don't reference each other, the form references them both. What if I'm trying to reference tables directly though? If I have tbl_clients and tbl_sites, where one client may have several...
  11. S

    Lookups...

    ...are, I fully accept, the work of the devil. So what do we use instead? My last database ran into some issues because of my clumsy/inept design and probably the biggest mistake ( among many :) ) was using lookups to reference one table from another. I want to get this one right from the...
  12. S

    Filtering a Form

    The option group was perfect for me, all working now, thanks Bob :)
  13. S

    Filtering a Form

    That looks perfect, many thanks Bob :) I will test it and let you know if I can get it to work; I have a history with these things...
  14. S

    Filtering a Form

    Hi all, I'm trying to filter a form and really struggling with it. I've spent some time searching the forum and tried the various solutions posted and can't get it done. I want to filter products based on a checkbox, so a list of around 1000 products filters to show only the 100 or so 'active'...
  15. S

    Referencing dates from a different DB

    Thanks Dave, I will give that a go this evening.
Top Bottom