Search results for query: *

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(ActiveCell, Union(Me.Range("SeriesNames"), Me.Range("SeriesYValues"))) Is Nothing Then With Me.ChartObjects(1).Chart.SeriesCollection(1) .Name = "=" & Intersect(ActiveCell.EntireRow...

is it possible to "pop-up" an Excel chart by clicking on a cell with the chart name?

This should be simple, but I am puzzled. I have a spreadsheet that keeps track of supply costs per month. When a new max is reached, I have a call that indicates, "new max". I won't to automatically replace the number in the corresponding cell to show the new Max Value; I tried the formula...

MS just updated my Office files again without asking of course. I have been using spreadsheets that I created several years ago and mow they do not work. Especially the macros and I can't save any changes because Office says the files are blocked! I went to trust center in Excel and apprved...

I Have a form, [Cry_Master] and a sub form, [Daily_Value_Subfrm]. the subform lists the value of items by date. i need to show the current or latest value on the main form. I used the following syntax: =[Forms]![Cry_Master]![Daily_value_Subfrm].[Form]![Current_Value] This has worked for a...

I have a DLookup on a form. The form is based on a table "Daily_Value". The lookup is based on a Table called "Cry_Cn". The formula I am trying to use is: =DLookUp("[Cur_Quanity]","[Cry_Cn]","[Symbol] = " & " [Symbol]"). I am pretty sure that the problem lies with the Caption "Symbol" or the...

I have a form based on a query. Under the field "Remarkstxt" is miscellaneous informational text. I have 1 which refuses to let me enter or change text. I get a pop up which states "Unable to change field. Changed by another user.' Since I am the only one who has access to this DB, I know no one...

I cant seem so find a way to incorporate a single filter for an append query and then open up just the appended records. Each day, we must add the current date to an existing table that list the resources (Products) that we handle. That part is simple. I just added a criteria of Date = [Date ?]...

I am trying to run a query which shows the values of all products from yesterday and lets me enter new data for today. SELECT [Daily Value].Date, [Daily Value].Symbol, [Daily Value].[Current Value], [Daily Value_1].[Current Value] AS Yesterday, [Daily Value].[current value]-[yesterday] AS...

i NEED TO TRANSFER DATA FROM EXCEL TO ACCESS. iN PARTICULAR, EMPLOYEES ENTER PRICE ND QUANTITY INFORMATION TO A DAILY SALES SPREADSHEET. i NEED TO TRANSFER CERTAIN INFORMATION, NOT ALL TO A REPORT IN ACCESS. iS THERE A LOOKUP FORMULA IN ACCESS THAT WILL TRANSFER DATA FROM EXCEL?

i have and inner join query that has been working for several years. HOWEVER, 2 OR 3 WEEKS AGO, IT BEGAN GIVING A WRONG SOLUTION TO ONE FIELD. The code is: DoCmd.SetWarnings (False) strsql = "UPDATE [Etrade 6473] INNER JOIN Stock_Data ON [Etrade 6473].F1 = Stock_Data.Symbol SET...

I am a newbie and can't decide what I'm doing wrong. Code: refsql = "select Quantity_owned, Current_Val, symbol, Dont_record from [Stock_Data]" 'Fields(0) = Quanity, Fields(1)= Current Value, field(2) = symbol Set rstStkD = CurrentDb.OpenRecordset(refsql, dbOpenDynaset) C = 0 cv = 0 'Current...

I have been using a form for years with no problems. And, I have made no changes to the form or the on current VBA event. Now, every time I try to open it, Access crashes and is forced to restart. The odd thing is I can open the on current event for the form, put a {F9} to stop the VBA. When the...

I have a field in a subform labeled [Loss/Gain]. I need to put the sum on the main form. The numbers can be either positive or negative. I am using "Sum([Loss/Gain]) in the field. I know from reading other sources that summing on a calculated field may be a problem as well as negative numbers...

This has worked forever. Yesterday, it quit. It is probably simple, but I'm not seeing it. The routine is calculating but net returning the answer. http://files.engineering.com/getfile.aspx?folder=29e9761e-51ee-45a9-ba05-73a57c43ffe3&file=Public_Sub_Rec.docx

I've seen this dome but I don't know how to do it! I need to open a query with a button on a form. I only want to see the items from a single source. i.e. The query fields are: Date Item and Quantity The item is a part number. The query includes all part numbers, and quantities for each...

I have a command button on a form that performs a set of calculations and copies the result to one of the fields. I would like to perform the same functions on all of the records. Right now I have to manually page through each record and click the command button. I tried using the following...

I am trying to write a macro to select a row of cells beginning with the currently selected cell. I want to covert the entire row from the formulas to the resulting values. So far, ActiveCell.Select ActiveWindow.SmallScroll Down:=-84 Selection.Copy Selection.PasteSpecial...

I am using 2010. I need to have 2 or more groups of option button on a single spread sheet. Each set needs to act independently. One set has three options. Pressing one of the radio buttons turns off the other 2. The next set may have 4 options. Again, when pressing one of these, the other three...

I am a novice, so, please bear with me. Is there a way to directly link to the cloud from your computer? Let me explain. I have 2 programs that the employees use to update daily records. One, an excel file has general pricing and other information and is updated daily. The other is an Access 10...