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 Chriss Miller 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: *

  1. godfrey62

    passing parameters to function when multiple input

    Thank you very much - I have some code for running processes in a loop, which is likely going to be the answer. I appreciate your time and expertise !!
  2. godfrey62

    passing parameters to function when multiple input

    Thank you for options. And now I'm gonna look stupid - it appears the process is a stored procedure and not a function at all. I tried both methods offered but neither worked - presuming because it's a stored procedure and not a "function" after all. Anyone offer anything with this new insight?
  3. godfrey62

    passing parameters to function when multiple input

    Everyone's gone for the day and I need help. Working in Management Studio and I've been given a function to run that needs two parameters, an ID# and a date. I have a table with the ID#s and dates to be used, but having trouble figuring how to pass info to function and returning four fields...
  4. godfrey62

    Please help. I'm stumped. One of

    Another thing we found was that users were going to the SAVE option, thinking they had to save their data. We explained how Access works, and showed an example, and cleared that problem (one of many) at least.
  5. godfrey62

    Tab control form linked to two different tables?

    If I may jump in here, one solution I would have is to put the second table on its own form and then make that second form a subform on the second tab. I'm doing the very same thing with data I am working with. The subform has its own query/table as a source and you can set up a Master/Child...
  6. godfrey62

    Combo box issue..........need help!!!

    Chris, Yes, unfortunately separate tables is the only way I know how to handle the different data. If someone else "out there" knows how to identify certain rows, Chris and I would love to hear it!! My thoughts, though, Chris, are if your data ever needs updating, you would have to...
  7. godfrey62

    Combo box issue..........need help!!!

    I think I have a solution, or at least a start for you as I have done something similar. I had two combo boxes and subsequently, two fields to populate: tBCSvcReq (Broad Service Category or whatever type of name you need for your IssueClass1.) and (not seen in code below) tSCSvcReq (Specific...
  8. godfrey62

    using code to create Excel CHART objects.

    To all, Skip helped me with a posting about four charts I had positioned on a worksheet in Excel that looked at source data on four separate worksheets in the same workbook. One thing we had trouble with inside Excel was the axes changing size and moving around. We went to each chart and...
  9. godfrey62

    Excel VBA Chart SeriesCollection cycle through rows of data

    Just so the rest of you know the culmination of the rest of the conversation SkipVought and I had offline, here's the end result. And it works like a charm!!!!! Option Explicit Sub DoCharts() Dim lRow As Long, lRowCount As Long, iChart As Integer, rng As Range, sName As String...
  10. godfrey62

    Excel VBA Chart SeriesCollection cycle through rows of data

    That looks like the real key to it all, and I've brought it in and fixed my worksheet order, etc., to utilize the code as it's set up . . . HOWEVER, I now get a Run-time error -438- message that reads: Object doesn't support this property or method. and the line...
  11. godfrey62

    Excel VBA Chart SeriesCollection cycle through rows of data

    they are embedded in a worksheet. Hence my supposed need to use WITH statements for each iteration.
  12. godfrey62

    Excel VBA Chart SeriesCollection cycle through rows of data

    sorry for the confusion. I do have four charts on one worksheet. The four charts have four separate worksheets as their SOURCE DATA. For chart 1, for example, source data is Worksheet("DRE_Info"), Row 2, Columns 4, 7 and 10 for first data element in series. For second data element...
  13. godfrey62

    Excel VBA Chart SeriesCollection cycle through rows of data

    sorry for the confusion. I do have four charts on one worksheet. The four charts have four separate worksheets as their SOURCE DATA. For chart 1, for example, source data is Worksheet("DRE_Info"), Row 2, Columns 4, 7 and 10 for first data element in series. For second data element...
  14. godfrey62

    Excel VBA Chart SeriesCollection cycle through rows of data

    I have four charts on a worksheet. Each chart has three series of data as in the source data (a separate worksheet for each chart). I need to have code that will look at the source data, create the four charts for a certain company, then go to the next row of data in each worksheet of source...

Part and Inventory Search

Back
Top