field

I've been looking at different code to use for this but can't find one that works. I'm wanting to create a button which populates a word document with the information currently displayed on the access form. <tbody> Word Form Field Access Field txtCompanyName CompanyName txtAddressLine1...

I have 2 sources: Data (Excel spreadsheet) and item_info (SQL table). They both share a field item_no. I want to join on this field in Data to bring in additional fields from the item_info table into Data. Both fields are data type text. There are no leading or trailing spaces. Join kind is...

Access 2013 I have a form (F_WorkingHoursSub) with 3 fields (Workers, Contractors and Total) Sometimes I have the hours for Workers and Contractors, and other times I only have the Total hours. I would like the total field to show Workers + Contractors if this data is entered. But... If I only...

Field contains 1990NorcrossRoad I need 1990Norcross Road

I created a table as belw. and want to get its text data(CODE) in a pivot table's value field. Table1........ NAME CODE 1 ABC AD-01 2 DEF AD-02 3 GHI AD-03

I have one tab and on it I have 3 columns date, dollar Amt and margin. On another tab I have two columns one is a list of dates and next to them is the Interest rate, this second tab basically is a historical listing of the fed lending rate. I want to place a field on the first tab that looks at...

Hello Everybody! I have a pivot table that is misbehaving. I have a huge table with lots of columns of numeric data that I made a pivot table from. Usually when I click on the checkbox next to a pivot table field to add it to the Values area of the pivot table it shows up as Sum of Column X...

I am trying to develop something in Access when you press a button, it brings up a msgbox (fine) and you enter a reference number. This then launches Outlook, and in the subject field enters the number you just entered into the msgbox (again fine) What I then need is to reference a field in...

Can you help calculating a field in a pivot table. Example - I have 3 columns of Data. Column A ("Month") i.e. Jan, Feb, Mar etc. Column B ("Task") i.e. Task A, Task B, Task C etc. Column C ("Amount") i.e. 1, 2, 3 etc. In the Pivot Table Fields - I drag "Month" into the "Columns" box. I drag...

I am trying to develop a code that will autofilter a field, that will change month to month. I have a userform where the user selects the reporting month, then the script finds that month across the top of a structured table, and then drops down 1 row to select the header of the structured...

Default Access: This is Repost with different title - since my original did not meet posting requirements (in error). Sorry started writing the issue and forgot to get back to the title to complete it. Forum Use Guidelines, especially Item 4...

I have a Combo Box that has 6 columns The source of the data for the list is huge. There is over 30k rows SELECT [ModelGeneral_vluItem].[TotalLeadtimeDays], [ModelGeneral_vluItem].[ItemID], [ModelGeneral_vluItem].[ItemDescription], [ModelGeneral_vluItem].[LastRevisionID]...

Hi all, I'm relatively new to Power Bi and I looked at a couple of questions on the forum, but I couldn't find the right answer. I hope some of you could help me. I have a field which included a StartDate and a field with an EndDate. Between those dates, certain units should be built (let's...

Hello, each time when running the below code, I receive the error, "The item cannot be found in the OLAP Cube". Very confused and cannot figure out what to do :( Any help would be appreciated! I would like this code to filter the pivot field based on the value in M1. Dim HC As String Dim Sheet...

Win 10 - Office Professional Plus 2019 I worked with Pivot Tables for years, however I've been retired for the last 5. I have a rather large Survey that I created. I have many questions with (Yes-No-Sometime) answers to them. Each person has an unique # How can I create a pivot table that...

Hey All Something has me scratching my head and I can't work it out for love nor money, hoping someone here can work their magic. Within Access I've got a linked Excel table of Products, Breaks and Prices. I want to Compare the prices against another linked Access table to see if they've...

Error: "The value you entered isn't valid for this field" The combo box, where I get this message, is a bound field to a table. The Field on the table is tied to an ODBC table. In the Data Type, for this field, I used the Lookup Wizard to create the list. But what is happening is that the...

<tbody> A B C D E F Multiplier Z 10 10 1 Y 50 50 10 2 X 4 4 10 3 W 10 4 </tbody> <tbody> Enter # SUM </tbody> When I write "B" in the field "Enter #", I want that it shows the sum of the named column, in this case sum=(10*1)+(4*3)=22. How can I...

Hello all, I'm working on a spreadsheet where I have numerous pivots. Some pivots I'm able to group the date field, however there's one pivot that I'm unable to group the same date field I'm able to in other pivots. Does anyone know why this might be happening? I've tried creating a new pivot...

Hello, bpml = WorksheetFunction.CountIf(ws_data.Columns(8), "Klik Park" And ws_data.Columns(11), "Field") This isn't working ... Can someone help me accomplish what I thought this would do. I'm trying to get a count of all the values in which column 8 = "Klik Park" and column 11 = "Field"