Search results

  1. P

    Show Users Button

    Thanks David. I currently use a similar tool (LDBViewer) but had hoped for a simple 'built-in' function. I believe I am half way there. The code is based upon Microsoft's ShowUserRosterMultipleUsers module that lists current users in the imediate window. I now need to know how this code can...
  2. P

    Show Users Button

    Good morning, I am attempting to add a button to the front of my database that will produce a message box listing the current users. I have attached the following code to a button but the message box is currently only displaying one user. Does anyone know what modifications need to be made to...
  3. P

    Export Access Query to Excel

    I've sorted it!
  4. P

    Export Access Query to Excel

    Is there any way Shanwels original code can be expanded to create a second sheet for a second set of query results?
  5. P

    Populate table with id of combo box selection

    The usual reply - sorry!... Row Source "SELECT ProcessID, ProcessDescript FROM tblSubProcesses ORDER BY ProcessDescript;" Can you help me with what bits I need to change. ProcessID and tblSubProcesses I'm ok with, just unsure what the ProcessDescript bit should be changed to. Many...
  6. P

    Populate table with id of combo box selection

    Not sure if I can due to it's current size. I can try and explain it a bit more... User selects process, clicks 'data entry' to open a data entry form. Data entry form has a tab control with various sub forms. The subform in question's record source is a table (sub processes) with columns...
  7. P

    Populate table with id of combo box selection

    No, a sub process can only belong to one process. I have manually assigned (via the sub process table) some sub processes to processes by inputing the process ID. This has allowed me to play about with the form and try and get it to work. As previously mentioned text box's show all the sub...
  8. P

    Populate table with id of combo box selection

    Hello, I have a table that lists processes (with process ID's) I have a table that lists sub processes. Within my sub process table I have a process ID column whereby sub processes can be assigned to processes by inputing the relevant process ID. I have a form linked to the process ID...
Back
Top Bottom