Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

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

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

    I'll try that approach. Thanks Patt
  13. 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...
  14. Replies
    21
    Views
    844

    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...
  15. Replies
    21
    Views
    844

    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
  16. Replies
    21
    Views
    844

    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...
  17. Replies
    21
    Views
    844

    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...
  18. Replies
    21
    Views
    844

    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.
  19. Replies
    21
    Views
    844

    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.
  20. Replies
    21
    Views
    844

    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?
  21. Replies
    21
    Views
    844

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

    Can you give an assist with the formula please?
    Thanks
  22. Replies
    21
    Views
    844

    Yes, code would be acceptable although I have not...

    Yes, code would be acceptable although I have not done anything with VBA before.

    Just had a thought that may help -- I have a list of the letter-number combinations that will exist in the strings...
  23. Replies
    21
    Views
    844

    Extract specific text from a string

    Hi All,

    I have data which includes a specific text string in each record; letter-letter-number-number-number-number (NM5762 for example). This string may be anywhere in the record (see attached...
  24. Replies
    6
    Views
    1,041

    This is a great, time-saving solution. Glad I was...

    This is a great, time-saving solution. Glad I was browsing the site today. Thanks Maudibe!
    myers515
  25. Replies
    6
    Views
    1,041

    You can use a pivot table for your data. Set...

    You can use a pivot table for your data. Set column A as a filter, then Show Report Filter Pages. A different tab will be created for Jeff, David, etc.

    Meleia
Results 1 to 25 of 59
Page 1 of 3 1 2 3