Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. That is correct. The totals that I receive are...

    That is correct. The totals that I receive are always based on the Column A business, and no they wouldn't always be sorted.
    Thanks, MM
  2. Thanks for the extra work on this Maud. And of...

    Thanks for the extra work on this Maud. And of course, that's never the end of it. I didn't initially think about a VBA solution so really pared down the data.
    The attached file shows the expanded...
  3. Thanks Maud, will try this on the expanded file....

    Thanks Maud, will try this on the expanded file.
    Appreciate all of your help, always.
    MM
  4. Thanks so much Zeddy and Maud. Since I am...

    Thanks so much Zeddy and Maud. Since I am unfamiliar with VBA, I'll be using Zeddy's solution as I need to expand this to cover several types of "costs" with several thousand sites and possibly...
  5. Thanks for the VBA solution Maud. Since I don't...

    Thanks for the VBA solution Maud.
    Since I don't know VBA, can you describe how the percent and markup is being calculated? And if I need to change the %'s, say A's will be worth 30% more instead of...
  6. Thank you most Excellent Distrubutions...

    Thank you most Excellent Distrubutions Distributor :D
  7. Hi Zeddy, This might help with the "mostly"...

    Hi Zeddy,
    This might help with the "mostly" part: what I am determining is business interruption valuation. Each of the sites has a specific number of subscriber "units". For the cost (actually...
  8. Knew I wasn't going to explain this very clearly....

    Knew I wasn't going to explain this very clearly. See attached file v2. Since I have only a total Cost that I need to divide across all the Sites, I am using a % of the number of Units. However, the...
  9. Formula to increase % of units based on site type

    Hi All,
    I need a formula to increase the % of Units per Site depending on the Site Type. The % of Units per Site is based on the number of units per site.
    An example, if Site Type = A then the % of...
  10. Actually I think I just found the answer -- I've...

    Actually I think I just found the answer -- I've hit the Access 2Gb size limit. (I have some photos that are stored within the database :-( rather than being linked)
    But as you suggested I will go...
  11. Cannot open database ". It may not be a database that your application recognizes

    I have used an Access 2010 database for several years and recently started receiving this error: "Cannot open database ". It may not be a database that your application recognizes, or the file may...
  12. Thanks for responding. And I apologize for...

    Thanks for responding. And I apologize for sounding so vague. I was looking for ideas that existed instead of anyone doing new work.
    It would have been a very large project but it was just...
  13. Need ideas for tracking inventory lead times and capital forecasting

    I have been tasked with tracking inventory orders and receipt including various lead times and trending for different products and different vendors. Along with this will be capital committed,...
  14. Thanks for answering so quickly. I will need to...

    Thanks for answering so quickly. I will need to convert to text so this works. Now that I read your response I may have asked this before a long, long time ago but just couldn't remember how to do...
  15. Change variable length of numbers to three character text

    Good Afternoon,

    I have a list of numbers
    1
    05
    01
    26
    427

    and I need to change them all to text like
  16. Company policy -- no Access databases on the...

    Company policy -- no Access databases on the Sharepoint sites. There is very little VBA in the database anyway. Think I'll create a few simple queries that I know will retrieve some of the most...
  17. You and Wendell have given me plenty to think on....

    You and Wendell have given me plenty to think on. And part of my problem is that even I don't know all the specific situation parameters. I believe my next step will be to study various scenarios and...
  18. By the way access to the database would be by...

    By the way access to the database would be by their regular NT logon.
  19. A little history. And when you have added all you...

    A little history. And when you have added all you wish to add to this subject, please feel free to say so.

    I am not an IT person nor is it my background. I created a database in dBase 20 years ago...
  20. And yes, I do read alot of what is on line along...

    And yes, I do read alot of what is on line along with the books that I own, but there is just so much data that it's easy to get buried.
    That's why I've asked for your top tips and ideas :rolleyes:
  21. Tables will all be on one server in CO. Users are...

    Tables will all be on one server in CO. Users are all across the country although I wouldn't expect more than 10 to 20 on at any given time and most would just be pulling data for their geographical...
  22. I already have various scenarios for querying and...

    I already have various scenarios for querying and filtering the data-ask but I will have to read up on all that is involved in bound forms as I think that is what I mostly have right now.
    Thanks for...
  23. Yes. I will be responsible for distributing the...

    Yes. I will be responsible for distributing the front-end (probably through link in email) and unfortunately I know just enough to be dangerous!
  24. Need tips on building front-end when splitting database

    Hi All,

    I am in the process of splitting a database. IT has grabbed the back-end (MySQL) and I need to re-do the front-end and keep it Access 2010-compatible. What I am looking for is this:
    ...
  25. I'll try that approach. Thanks Patt

    I'll try that approach. Thanks Patt
Results 1 to 25 of 72
Page 1 of 3 1 2 3