Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: billheath
  • Content: Threads
  • Order by date
  1. billheath

    Private Sub Worksheet_SelectionCh

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

    excel chart

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

    excel; replace max value with calculated value

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

    Excel blocking my files and macros

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

    Picking value for the latest date in a subform

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

    Dlookup problem

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

    Unable to change field

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

    Filters for append query and resultant form

    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 ?]...
  9. billheath

    Can't enter data into query

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

    i NEED TO TRANSFER DATA FROM EXCEL

    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?
  11. billheath

    Inner Join update querry

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

    Do Loop does not work

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

    Form will not open

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

    Calculating a sum whem some of the data is negative

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

    Get routine not working

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

    Opening a query from a form

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

    Cycling trhough all records in a form

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

    Select Celss in Excel

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

    Excel Option Buttons

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

    Cloud services problem

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

Part and Inventory Search

Back
Top