Recent content by gstreichan

  1. G

    Hide a field in Subform (Datasheet) form based on Form Value

    Dears, I have a database with 2 roles: Requestor & Approver. The role is always stored in form textbox after user logs in. This form has a subform (datasheet) with field A, B, C, D and F. What I want to do (if possible) is to make fields D and F not visible if Form.Role = Requestor (Current...
  2. G

    Select First Row of a Value in ListBox

    Dears, I have a ListBox0 in a Form that shows all different on hand quantities for a BOM_Pos. I would like to click on a button and have all first rows for BOM_Pos selected, is it possible? For instance here below, there are 6 different BOM_Pos and how I am trying to get it to select. Would...
  3. G

    Query to Show the Exact Position of MaxValue in Other Column

    Dears, I am facing one issue that I think might be easy to solve but I am not getting it. In 1 query I have 3 fields: Item_Recv# BOM_Pos On_Hand I want to show the max On_Hand quantity of every BOM_Pos followed by Item_Recv_# of the item as well. For instance, on the screenshot example...
  4. G

    Access Options Confirm: Record changes, document deletions, action queries

    Dears, I have a split frontend database that I place in server for users to copy, paste and open it through their desktops. We are all connected to same server, of course. However, this database has some action queries, which I have previously set in File>Options>Client Settings>Confirm as...
  5. G

    Hide Privacy Options in MS Access 2016

    Dears, I have searched so much on the topic but can't get the Privacy Option in MS Access 2016 hidden. I am trying the following now: Created a Table called "USysRibbons" with two Fields "RibbonName" and "RibbonXML". I named RibbonName as Default and in RibbonXML I have entered the following...
  6. G

    Question Delete Multiple Selected Records in a Table based on ListBox Multiple Selection

    Thank you so much Arnelgp. In fact I meant OnClick event of Button. It is very cool to have your quick reply. All the best!
  7. G

    Question Delete Multiple Selected Records in a Table based on ListBox Multiple Selection

    Dears, I am stuck and have searched so much on the topic as there are many discussions about it but I can't seem to get it done. I have a Table1 with 3 Columns: Name, Surname, ID (Unique) I have a ListBox (List37) on a Form1 the List37 is with Multiple Select "Extended" and has 3 columns (Row...
  8. G

    Question Pass 3 MultiSelect ListBox Columns to a Subform

    There are hundreds of names and to double click on each one will be a huge work.... does it mean it is not possible?
  9. G

    Question Pass 3 MultiSelect ListBox Columns to a Subform

    Dears, I have looked for a thread on this subject but can't find, I am hoping someone can help me. This is the scenario: Form1- Main Form Form2 - Subform with TextBoxes: Name, Surname, Birthday Multi Select ListBox (List22) - It is a summary showing all people with 3 columns: Name, Surname...
  10. G

    Table Rich Text Column Color

    Dear friends, need your help. I wanted to know how I can set a color on table column formatted as rich text and memo. For instance this table has 4 different columns of remarks, one from each engineering operating center. Remarks_1, Remarks_2, Remarks_3 and Remarks_4. Each one of the 4...
  11. G

    Disable all fields on a Form when a field is not null

    Hello NamLiam, Thanks for the reply. I guess that might still be something I am doing wrong. Let me explain you a little more please. I have a form with a combobox and when selected a value, the subform PAF_Assignement shows all data from that field selected. The Subform PAF_Assignement...
  12. G

    Disable all fields on a Form when a field is not null

    Dear Access Support, need your help. I have a form called PAF_Assignment and on this form there are many textboxes for editing. After all fields are entered, the user clicks on a button and this button populates the PAF_Issued_Date field with the actual date. Then I want to disable...
  13. G

    Populate Subform Field when Open with a Subform Field

    Okay, I will read on threads about that.
  14. G

    Populate Subform Field when Open with a Subform Field

    I don't know about normalisation...
  15. G

    Populate Subform Field when Open with a Subform Field

    Yes, I have done this way because construction extracts the data to excel for creating the dashboard. As their spreadsheet has a very illustrated header, I have numbered their dashboard spreadsheet and also the table in access, so when they copy from access and paste on the excel spreadsheet...
Top Bottom