Recent content by Keefay78

  1. K

    Multiple ComboBoxes on 1 table

    Unrecognized format. Arnelgp, thank you so much for trying to help me, unfortunately I can't read the file. We only have 2007 and changing the software is something way out of my hands. Still very much appreciated. Sent from my SM-G930F using Tapatalk
  2. K

    Multiple ComboBoxes on 1 table

    Ahh I cannot get it to work. It is just a pity that it is 2007 that is on the work system :( :( Million thanks anyways Arnelgp :)
  3. K

    Multiple ComboBoxes on 1 table

    Unrecognizable to my Access 2007. I will see if I can run compatibility mode on it
  4. K

    Multiple ComboBoxes on 1 table

    Wow thanks, I will have a look when I get home in a couple of hours as it is not compatible with the 2007 access here!!
  5. K

    Multiple ComboBoxes on 1 table

    In a way, this is what I am trying to achieve. this type of layout. none of these boxes are filled, it is purely for display purposes.
  6. K

    Multiple ComboBoxes on 1 table

    Yeh, we have about 200 staff, 4 departments and each department has 3 role sets. Each department has to select 6 people (2 for each role set) to be on emergency call. Each department has a computer and we all share a desktop where the database would be located, each department manager would...
  7. K

    Multiple ComboBoxes on 1 table

    I will have about 200 members of staff in 4 Departments and 3 roles within each department and I need to pick about 20 out every day for this contact sheet
  8. K

    Multiple ComboBoxes on 1 table

    Well I tried.. i attempted to re create your forms but ended up just lost. On your datasheet is it possible to have selections from the columns? Like first column "Dept" you chose from that selection meaning the next column "role" would display relevant roles available in that dept I don't...
  9. K

    Multiple ComboBoxes on 1 table

    Ahhh yeh I see where you are going, I had never thought of it this way, thank you so much. I will try this way with the information I require and see if I can make it like yours and show you
  10. K

    Multiple ComboBoxes on 1 table

    Appreciated. Here is the db. i have been using the form titled Form with combo and text boxes. Ideally I would like a list of combos to select multiple staff members. If i recall if i try it unbound it doesn't show up in report.
  11. K

    Multiple ComboBoxes on 1 table

    If I have it unbound the selected data disappears when the form closes. Is there a way I could have a form with say 20 combo boxes that would stay selected until manually cleared off?
  12. K

    Multiple ComboBoxes on 1 table

    Is it possible to have multiple Comboboxes running off 1 Control Source table? My table has 4 columns, "names,dept,phone,address" first combobox listed by names works fine and i populate the 4 text boxes with this selection I created another combo and 3 text boxes underneath to select...
  13. K

    Report not showing data

    Hi there, I have a form which I select staff members from a table and it shows the contact details of these people in a text box, I have tried many tutorials and watched videos but I just cant get the report to show the chosen data, obviously im doing something wrong. I have attached a screen...
  14. K

    Multi user DB with simple UI

    I appreciate that, I happily take any help and critique as it comes. You are correct of course, I see in my mind how it will look (i hope) when its finished and wanna skip to the end :) but to be fair I do love the learning, I taught myself a lot of stuff on photoshop and Cinema4D etc.. its...
  15. K

    Multi user DB with simple UI

    Thanks, ill work on some other layouts that might be more workable than a confined amount of selections (ie: more staff on for X dept) Sorry yeh the question was, if I go on and select X members for Y roles, how do i make these selections stay put until manually wiped? say, at the end of the...
Back
Top Bottom