Search results

  1. C

    Preventing user from opening accde directly but only via another access database.

    This is exactly what I need and it works! Thank you very much.
  2. C

    Preventing user from opening accde directly but only via another access database.

    Yes exactly. So I can avoid all the front-end/back-end deployment version comparison etc etc. In case I want to stop user from using a tool, i simply remove the path from the hub, no one can access, instead of having to go thru each tool...
  3. C

    Preventing user from opening accde directly but only via another access database.

    Hi, It’s hard for me to explain. I am currently placing 10 dbs in one but the hub simply manage the “make copy from server to user local then open it”. It does not store anything except the path of the 10 dbs, and any other excel macros files. I will test the command later to see if that works...
  4. C

    Preventing user from opening accde directly but only via another access database.

    This sounds great. Any site with more info that I can lookup? Thanks
  5. C

    Preventing user from opening accde directly but only via another access database.

    Thanks for your opinion. The main purpose is not really about trusting user but to make any of current and futur tool deployment easier. About that Hub, i can set level access etc so each department can only see the tool they are able to see. I created my tool in Access and also im Excel to...
  6. C

    Preventing user from opening accde directly but only via another access database.

    No, that’s not my issue to access to linked table with password. So I have 10 different tool in access, and they are in accde. Instead of sending to the user 10 accde file, and some user doesn’t even need all those 10 tools. Since there are multiple department involved, instead of pulling my...
  7. C

    Preventing user from opening accde directly but only via another access database.

    Hi, Lately, there was an update of an external app that we connect our access database to, so all tools need to be updated, but some user are still using the older version of that external app. So the deployment was quite painful. I am now looking to create like a hub that stores all the access...
  8. C

    Function for auto dropdown for all combobox

    Sure. Basically, I created a Public Function, then I wud call that in the combobox GotFocus fire event. Public Function ShowDropDown() As String Screen.ActiveControl.DropDown End Function I just select all the combobox, and in GotFocus, I call the function: =ShowDropDown() Once the field...
  9. C

    Function for auto dropdown for all combobox

    Thanks. I figure it out.
  10. C

    Function for auto dropdown for all combobox

    Yes I know but doing this I need to add the code to each individual combobox one at a time. Thanks
  11. C

    Function for auto dropdown for all combobox

    Hi, In a form, I have more than 20 combobox, and I would like to create a function so I on GotFocus, it will automatically dropdown that combobox. Any idea how can I make it work instead of adding a code individually to each combobox? Thanks
  12. C

    Iterate thorough listbox field with values using DAO

    I was just trying to see if it was possible to not create a separate table with option but use that feature instead. Because on the current form, its showing as listbox with option, so by creating a new table, i will need to create a subform as well. Was trying to find shortcut. Thanks
  13. C

    Iterate thorough listbox field with values using DAO

    Thanks! Going back to create a table with option field instead.
  14. C

    Iterate thorough listbox field with values using DAO

    Will I have any issue if I decide to move this table to a SQL server in the future? I don’t believe SQL table has that MVF property? Thanks
  15. C

    Iterate thorough listbox field with values using DAO

    Hi, I have a table with multiple fields as Textbox, and one of the field is set as Listbox with values and multiple selection allowed. Using DAO, I would like to iterate and pull all data from all fields, including that listbox. sTable = "tblUser" sProjId = "5" Set rs =...
  16. C

    Populate the name of the active control on focus in a form.

    Awesome!! This solve what I needed. At first, I put the hint textbox on the main form, but I wasn’t able to get the active field from The subform, so I move it to the subform, now I can move it back to the main form :) awesome !
  17. C

    Populate the name of the active control on focus in a form.

    The purpose of populating the name of the control was for me to be able to use it for dlookup for that field name over another table. I wasn’t able to get that active name in order to do the dlookup. The 255 characters was to explain why I didn’t use control tips or status bar only. Now...
  18. C

    Populate the name of the active control on focus in a form.

    I have thought about it too, but the user doesnt like to double click, then click ok every single time. They do nee the Hint to show up most of the time. I have over 400 fields with hint for this project, and I don't think any user remembers how to fill properly for all those 400 fields :)...
  19. C

    Populate the name of the active control on focus in a form.

    Oh yes, this is exactly what I wanted to do, but not to scare you, I have over 400 fields, that will take too long to create extra label underneath, but thanks for this example. I will use it for another project where I have less field :) Thanks
  20. C

    Populate the name of the active control on focus in a form.

    The hint is pulled from the table linked to the backend. So if any changes is needed to do, Ill just go to the table in the backend and change the hint of that existing field. No need to deploy a new front end version if I was to use control tips. And also, control tips have a max of 255...
Top Bottom