fields

I'd like to create a "roster" report from my database, listing every active record. It would be used as a "sign-in sheet", so I'm looking to create a report (pulling 3 fields - Last Name, First Name, Status) that look like the following: Ames, Jonathan (A) _____________ Hayes, Darren...

Hello, I have a 2 page multipage userform. I would like one user to fill out the fields on the first page, email the workbook containing the completed userform to a second user that will complete page 2 of the userform (I would like all the fields filled out by person 1 to remain populated so...

Thanks in advance. I am an intermediate user of Access and have the following issue: How do I omit the parameter windows show for SUMofPLANNEDSCREENS SUMofActualScreens SUMofACTUALMnhrs as part of Query A, that pull the data from Query B? I have a query that pulls data from a Query B. Query...

Hello, I hope everyone is well. Long time, no post :) I receive non-normalized data from our field staff who are in teams of 2. For our final analysis, we choose only the team lead (indicated in its own field/column as TL). However, on rare occasion, they leave their response blank and we need...

Hi, I’m linking 2 tables and want to bring back results where fields in my 2 tables match. My issue is that the fields only match for a maximum of 50 characters so if the field is greater than 50 characters the query won’t see them as a match and won't return anything. I want to return any...

I have the code below linked to a text box on a Form. It searches 2 fields for the textbox value. Is there any way I can edit it so it searches for values which contain the textbox value? At the moment it is only searching or an exact match... E.g. If I search 'Test' it will not show 'Test123'...

Hi, I'm using Excel 2013 and maintaining a table which logs changes to one or more fields. The table below illustrates an example of bonus/salary/rating that could be adjusted during the project. The "O-" prefixed fields are a lookup to the original load-up data in another table. The values...

Hello. I am creating a form for standard patient data input. I have a button that clears all the fields when the user is to enter a brand new patient. However, there are times when the patient stays the same. There is other data to enter for the same patient. How can I clear fields and leave the...

Hello, I need to do the following : in one spreadsheet , we have a list of fields , like : PER_NATIONAL_ID PER_NATIONAL_ID_CAT_CODE PER_NATIONAL_ID_CAT_NAME PER_DATE_OF_BIRTH then we need to add , for example a check (with a check Button maybe ? ) , to allow the user select some of those fields...

I've reported this to MS via Answers, but I'm not crazy am I? You shouldn't be able to type data into a PivotTable at all, right? I have reproduced this issue in builds 1811 and 1812 of Excel in Office 365. I can type over fields in Rows and it sticks. Refreshing doesn't fix it like when you...

I have some data in the data model, and when I go into the measures to create a new one, the tables/columns etc are not pulling up as choices to use hen start typing them. I thought well maybe my query was broken so I physically copied the spreadsheet into the workbook and tried adding to the...

Hi all I have designed a user form to control what is entered into a data table, one of the fields is a free text option via a textbox. The user has the ability to enter as many characters as they wish, but when the user forms updates it only shows 254 characters. To retrieve data from the...

I have a table that has 2-columns with dates in them and a 3rd column with peoples names. I want to use access to get rid of all records except associated with certain people (which I've figured out) AND that has a date in either of the 2-date columns that's greater than 12/2/2017. There are...

Hi, I have a query that I am building where I have a calculated field (within the query) that I want to use to calculate a final value in another column. I cannot get this to work using to columns first would be the first calculation then the second would be the simple math equation. See...

Hi All I have a spreadsheet that has start dates (E) end dates (F) and a calendar style fields I - BU. Is it possible for fields I - BU to lookup fields E - F and fill then in. also I have another field G which holds conditional formatting on WIP (Amber), Closed (Green), etc. Can these be...

Hi all, I was wondering how to unlock cells after certain data was entered, e.x required fields are A1 B1, F1. Once there are values in those fields the next row will become editable and so on... Thanks

Hi there, I have a userform with 100 text fields on it. they are all named dp1 dp2 dp3.... dp99 dp100 when I enter a text field I want the backcolor to change to green and the text white. and upon exiting revert to backcolor white and black text... I can do this using this code: Private Sub...

Hi, I have a table [T_Run] with fields [TeamName],[ID],[RunnerCategory] Table is created with every runner's ID, teamname & runnercategory(ie, captain, runner2,runner3...) <tbody> Id TeamName RunnerCategory 255 abc RUNNER4 260 abc RUNNER3 354 abc CAPTAIN 52 abc RUNNER2 </tbody>...

I'm creating a recipe database, and have a table with 19 fields for ingredients (Ingredient1, Ingredient2, etc). However, not all recipes call for 19 ingredients, and I'd prefer not to have tons of empty fields on the form used to input the recipes. How can I add the fields as needed when the...

Hello all, I have a question when using calculated fields in pivot tables. I have a set of surveys, where each number means either negative, null, or positive. What I want the calculated field to do is the following formula: (count of all positives - count of all...