Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. 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...
  2. 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...
  3. 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...
  4. 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,...
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. By the way access to the database would be by...

    By the way access to the database would be by their regular NT logon.
  10. 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...
  11. 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:
  12. 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...
  13. 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...
  14. 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!
  15. 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:
    ...
  16. I'll try that approach. Thanks Patt

    I'll try that approach. Thanks Patt
  17. Filtering a datasheet by any matching entry on a fom

    Some time ago I saw a form that allowed any data entry into the filter field and the results would shorten the list on the datasheet. Example I might enter "62" into the search field and the...
  18. Replies
    21
    Views
    1,080

    Hey Steve, I'm not sure what you just said, but...

    Hey Steve,
    I'm not sure what you just said, but it was said with eloquence! I am still going to try the code you sent originally (when I have a little more time) and see what I can learn. I...
  19. Replies
    21
    Views
    1,080

    Thanks so much everyone. You've saved me at least...

    Thanks so much everyone. You've saved me at least three days of work on just this one project alone. Really appreciate your willingness to help.
    Meleia
  20. Replies
    21
    Views
    1,080

    Rory, thanks, had the formula starting at F1...

    Rory, thanks, had the formula starting at F1 instead of F2. Changed and now see the error value. I think I'll go with your formula; it finds the matches and verifies with the valid list at the same...
  21. Replies
    21
    Views
    1,080

    I have the list of data and the list of valid...

    I have the list of data and the list of valid combinations. I'm not following what you mean by "dual columns". Can you tell why one record would work in the Book 3 example but the others don't?

    I...
  22. Replies
    21
    Views
    1,080

    Here is a sample. Don't understand this at all --...

    Here is a sample. Don't understand this at all -- one record works, the others don't.
  23. Replies
    21
    Views
    1,080

    I am trying the formula above and getting a...

    I am trying the formula above and getting a #Value! error. Any idea why? All data is formatted as general, the range is correct for the list and have entered as ctrl-shift-enter array.
  24. Replies
    21
    Views
    1,080

    I'll give this a try. Thanks. You mentioned that...

    I'll give this a try. Thanks. You mentioned that a simple formula might work if I have a list to compare the text strings to. Can you give me an example of the formula?
  25. Replies
    21
    Views
    1,080

    Can you give an assist with the formula please?...

    Can you give an assist with the formula please?
    Thanks
Results 1 to 25 of 63
Page 1 of 3 1 2 3