Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    15
    Views
    2,207

    RG I think I have messed it up again I tried...

    RG

    I think I have messed it up again I tried to reply using the email address you provided and was asked to authentic and that failed as well do you have my files yet?

    Sorry

    peter
  2. Replies
    15
    Views
    2,207

    Hi Maud Thanks for the input tried that and it...

    Hi Maud

    Thanks for the input tried that and it does not cycle twice as it did on exit but it still goes to the command button "Next Stock" bypassing the next text box Opt 6 which is what I would...
  3. Replies
    15
    Views
    2,207

    RG Tried Application.enablevents= False/True...

    RG

    Tried Application.enablevents= False/True same result

    thanks

    Peter
  4. Replies
    15
    Views
    2,207

    Hi RG Do not have a problem passing the file...

    Hi RG

    Do not have a problem passing the file onto you. However I would like to do it directly as there are lots of bits of code from other people and I am not sure I have made that clear through...
  5. Replies
    15
    Views
    2,207

    RG Thank you Still no luck I changed your code...

    RG Thank you

    Still no luck I changed your code to conform with my UserForm hopefully I did that correctly see below.



    It still cycle twice now does not give me an error but moves to the...
  6. Replies
    15
    Views
    2,207

    Thanks for that suggestion, there is not a yes...

    Thanks for that suggestion, there is not a yes option unless I should include an else option in the if then but if the test is passed I want to move on. Deleting the cancel = true for some reason...
  7. Replies
    15
    Views
    2,207

    Conditionally change focus on user form

    I have a user From with 6 input boxes. One of those receives a strike price. If that price is lower than a the purchase price I want to tell the operator and then depending on the response move the...
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. Replies
    7
    Views
    1,380

    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...
  18. Replies
    2
    Views
    1,039

    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...
  19. Replies
    7
    Views
    1,380

    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...
  20. Replies
    7
    Views
    1,380

    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...
  21. Replies
    7
    Views
    1,380

    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....
  22. Replies
    7
    Views
    1,380

    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...
  23. Replies
    10
    Views
    1,659

    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...
  24. Replies
    10
    Views
    1,659

    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...
  25. Replies
    10
    Views
    1,659

    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...
Results 1 to 25 of 188
Page 1 of 8 1 2 3 4