field

I have a table where I put a field in named "_TIME_STAMP" Whenever a new record is entered into the table I want to capture the date and time in this field Note the user is entering data into the table via a Form (Splitform). What is the best way to do this? Accesstbl_VendorQuoteData - Table...

I have the following code which triggers when the user double clicks on a field: Application.FollowHyperLink "http://www.google.co.uk/search?q=" & BusinessName This works fairly well and opens Google to search for the value in the BusinessName field. However, some Businesses contain "&" -...

I have a button on a form. When I click that button I want it to change the value of a field (Combobox) on that form. The field on the form is named _NO_BID_RANGE_01 I tried with no success: Sub Command1000_Click() [_NO_BID_RANGE_01] = "NB" End Sub here is the source selection for that...

Hi, I'm struggling with the below VBA. I have data In cells A6:S1176 and headings in cells A5:S5. I want to filter column A based on the value in B1. I then at the same time want to always filter out anything minus or below 0 in column G. When I run this macro though I get this error message...

Hello: I have the following code that toggles field selection on a pivot table. It works fine on windows, but fails on a Mac at the line indicated below. The Mac is updated with the latest version of excel. Any ideas? Thank you! Failure line: Set shp = ActiveSheet.Shapes(Application.Caller)...

I know I've seen it here, but cannot find it, so apologies for a potentially duplicate thread: Checkbox added, when "checked", I need a field (AG70) to display specific text/value ("Incld"). How? Thank you!

Hello, Help is appreciated; I need to show a text column in a pivot table as the last column of the pivot table as it comprises notes on the information in the pivot. In my attempts, i managed to move the text by creating a calculated field 'measure' for the column turning it into a values...

Hi all, I have a pivot table with a simple subtraction formula in it but the results being returned are way off of what they should be. The calculated field is in column F and is [=IFERROR(E6-B6,"")]. I have include Column G to show what the expected result should be. Why is this happening...

Guys I have one table that contains a memo field (tblWithMemoField) The second table has some keywords (tblWithKeyWords) What I want to do is a query that can generate a table using the field fldCriteria(tblWithKeyWords) to find the records from the tblWithMemoField on field (fldMemo). There...

I'm trying to calculate the difference in TY vs LY numbers in a pivot table. My set up is: Rows: Client Name Sale Date (grouping by month) Columns: Years (for the TY vs LY comparison) Sum Values: Sum of Sales For example <tbody> 2018 2019 Client 1 May 100 1000 </tbody> I want to...

I have two separate fields of Data in this work book. The top one sorts just fine as the first row of data never moves. However, the second field of data shifts down every time a new entry is made into field 1. the formula I have right now is this: With Worksheets("Sheet1") LastRow =...

Hi, When I try and right click on the field buttons to hide them there is no menu. Everything else seems to be working fine, any ideas what's happening? Much thanks

I have a list of Fields that MUST be in a Table. The data from this table is uploaded into another program. The Criteria for one of the fields is that it equals another field in the same table. Yes, I know repetitious. I am trying to figure out the best way to handle this situation. Can I...

Good afternoon. As basic as possible: I have a field (Response) with 5 different possible results (V Likely, Likely, Neither, Unlikely, V Unlikely), coming in by month (01/mm/ccyy). In a pivot table, I am representing these as percentages of parent column (month), so for example I have those 5...

Hello, I have entered the following code into the tab view code field and it works well when I manually change this field. However D1 references another sheet and when I change it in the other sheet D1 changes, but not the sheet tab name, ideas? Private Sub Worksheet_Change(ByVal Target As...

Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one. Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics. There's only one PivotTable on the sheet. I get the typical error...

I have a field that is a Date/Time. It is a required field so I want to put a default in it. I want to add an expression that will give me 90 days from the date the record was entered. I don't think it is =NOW()+90 because I think that includes time. Is it Date()+90?

Hello Experts, Seeking your wisdom once again... I am trying to come up with a VBA which would - take a Value from a cell, look for it in another sheet, and replace a number of cell values associated with that Value. Here's an example with some dummy data: - There are a number of Names in a...

On a Form, there is a Combo Box Field which lists different Statuses (e.g. Open, Pending, Closed). Is it possible for the following to happen? When 'Status' is changed from 'Open', add the sentence to the end of the text field 'Comments' to be something like this: "05/05/19 - Closed - J.Smith"...