Search:

Type: Posts; User: mitchbvi; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. The start is a form that allows me to select a...

    The start is a form that allows me to select a number of reports of which this sequence is one.

    The Sub "ExpReport1Year" is called first that builds the two tables then it opens the report.

    In...
  2. Thank you both for taking the time to reply. ...

    Thank you both for taking the time to reply.

    Mark, I will try and explain. The Batch # referred to in my earlier post groups records that may include both revenue and expenses. What I wanted to...
  3. Can you use an SQL statement as part of another in Having or Where conditions

    I have data base that at present I use a Docmd Run Sql to create a table based on a field not being Null and grouped by a batch number. I use that table in another Docmd RunSQL to filter all the...
  4. Thanks Mark , I am dense I know as I am still...

    Thanks Mark , I am dense I know as I am still missing something but at least problem for now is solved and I will work on your suggestion.
  5. Hi Mark first my apologies for not replying to...

    Hi Mark

    first my apologies for not replying to your post but my internet has been down for two days.

    Secondly I discovered that I need Max rather than Min, I had started out asking for Min...
  6. I had posted a reply and went to edit it and seem...

    I had posted a reply and went to edit it and seem to loose the lot. First thank for taking the time to respond to my post unfortunately I feel I did not outline properly what the problem is.

    The...
  7. I also need to sort by month as well and in fact...

    I also need to sort by month as well and in fact I needed Dmax rather than Dmin. Many thanks for the simple suggestion Occam's Razor got me this time. Using the month in the second query does not...
  8. Use Dmin (or other aggregate functions) on subset of records within query

    In a query each record includes "BatchID" , "Month", "year". There are a number of records for each BatchID, what I want to do is add a field to each record showing the min year in that batch. I have...
  9. Add Vertical Line to an Excel chart with VBA

    First I am using Excel 2011 for Mac and all I can find on the Web seems to refer to windows versions of Excel.
    I have a cumulative frequency chart (line ) and I would like to add a vertical line/bar...
  10. Replies
    7
    Views
    1,220

    Hi Andrew I have started a new thread as I...

    Hi Andrew

    I have started a new thread as I have run into a problem sorting my results and I thought that was the correct thing to do, and wanted to let you know in case you have any ideas. I have...
  11. Replies
    2
    Views
    937

    Sorting two-dimensional array

    I am using a User Form to select outputs for various cells. Then the worksheet is recalculated X times and that data stored in an array. I have had a lot of help getting this far but while I can sort...
  12. Replies
    7
    Views
    1,220

    Think I may Have it

    First My thanks for staying with me on this , it has been of great help. I was having trouble as you would have guessed and I had also posted a request on another Forum. The suggestion from that was...
  13. Replies
    7
    Views
    1,220

    Sorry did not explain the issue properly, I am...

    Sorry did not explain the issue properly, I am not trying to populate the User Form just collect the address's of the Out Put Cells. The main part of my code process the worksheet collecting the...
  14. Replies
    7
    Views
    1,220

    Andrew First thank you for taking the time to...

    Andrew

    First thank you for taking the time to reply to my problem. My post was not from the actual routine I am running, I thought it easier to try and explain my problem with a simple user form....
  15. Replies
    7
    Views
    1,220

    Using RefEdit to return multiple addresses

    I want to be able to get results from a series of out put cells on my worksheets when I run a monte carlo simulation.

    The starting point is a UserForm that has a RefEdit control. It works fine if...
  16. Replies
    10
    Views
    1,381

    Quicksort still needed

    Paul

    Thank you again, I have found the percentile does not work I need to to take the min and max and build the bins smoothly between the two. I was hoping to dump the quick sort but when i do for...
  17. Replies
    10
    Views
    1,381

    Percentile function Does not work with some numbers

    Paul

    This may be the wrong place to post but as I was working on the code you gave me I thought I would try. First though some clarification I wanted to calculate all the possibilities before I...
  18. Replies
    10
    Views
    1,381

    Paul Thanks again this will help me streamline...

    Paul

    Thanks again this will help me streamline what I have done. I only want to run the recalculations once . The object of my exercise is to produce the data and the bins to build a histogram to...
  19. Replies
    10
    Views
    1,381

    Paul Thank you, you are of course correct...

    Paul

    Thank you, you are of course correct there are a number of loops and I was trying to avoid entering data into the worksheet and the loops if possible as that slows processing down. I was...
  20. Replies
    10
    Views
    1,381

    Some Variations

    Paul

    Thanks for taking the trouble to look at my problem I was rather hoping there would be a way of avoiding the loop. i have had to make a couple of alterations to your code because when I fed...
  21. Replies
    10
    Views
    1,381

    Get Max and Min Values from a dynamic Array

    A model calculates a worksheet a number of times and outputs the results to an array. The array is re-dimensioned at startup based on number of calculations required. At present after calculation it...
  22. Thanks for looking folks. Turns out all iAd to do...

    Thanks for looking folks. Turns out all iAd to do was enter all the months headings in the properties of month so problem solved
  23. 12 Month Report Fails if not at least one value for each Month

    I have a report that has as its main part totals for each of 12 Months. The report is based on a cross tab query that has collated al the data it has for each line item. It works fine for years when...
  24. Access 2003 Lost Option to Export to Excel

    A routine I have used for some years annually suddenly stopped working. The code called for an export of table in Excel format. The error I got was 3170 "No installable ISAM" . when I tried to...
  25. Replies
    10
    Views
    1,582

    Hi RG When I was working through college I was...

    Hi RG

    When I was working through college I was hardwiring plug boards on IBM 601's but nothing serious since then in the programming filed. So I greatly appreciate your time in explaining to me...
Results 1 to 25 of 181
Page 1 of 8 1 2 3 4