Search results for query: *

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

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?

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

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.

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

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

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

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

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

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

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

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

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

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