Search results

Dear Experts, I have been looking for a solution as there are lots of threads on the topic, but I can't figure out. I have a template in excel users fill out and several times they enter line breaks in excel field. When copying data from excel and pasting in a Datasheet form, the different words...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Need your help, please! I have a form called frm002_PAF_MonitoringMAIN and on this form I have a subform called frm002_PAF_Monitoring. The subform has a button to another form for contact details called Contact_Details. The Contact_Details form opens with the details of the person who I have...

I really need your help. I have searched the forum but couldn't find a thread on this. I have a FE and BE database in Access 2010 and several times I want to force all users to log off so I can perform changes, compact and repair, etc. I found a post on it in Microsoft but it is not working for...

Hello everyone, It is just a pleasure being part of this amazing forum. I have read so many threads and it has helped so much on these past years, today a light came in my head, why not joining it? I am Guilherme and work on the management of warehouse control system so I am constantly trying...