Search results

Thank you so much! Worked beautifully!

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

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!

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

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

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

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

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

Okay, I will read on threads about that.

I don't know about normalisation...

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

MAIN TABLE 01_Zoom 02_Service 03_ManningListPos_# 04_JobTitle 05_HO_MOBDate 06_HO_DemobDate 07_BC/ML_MobDate 07a_HistoricalMobDates 08_BC/ML_DemobDate 09_PAF_# 10_ReceptionDate 11_EntityHVEorExpat 12_HistoricalEntity 13_PayCat 14_Last Name 14a_FirstName 14b_Gender 15_Agency 16_EstimatedMobDate...

Hello vbaInet, It is working. This is what happened. The database has a main table, which has all details of the employee, except contact details. The contact details table is a new table that I was asked to implement. So I have entered a button on a subform for the contact details and on the...

Hello Gina :) I have started a new thread... still have no answer on it. Please help me. I am very close to it but not there yet... Tried sending the thread but can't... can you find it? Thanks.