Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BoxHead

  1. BoxHead

    Back End tables exist on an obsolete server

    Thanks for the help! You saved me again!
  2. BoxHead

    Back End tables exist on an obsolete server

    We're using the database as an MDB - actually 2 MDB's - front end/back end. I did hold the shift key down for a long time, several times. My startup options were set up to prevent users from doing that. I'm working on importing everything from the front end into a new DB. It didn't carry...
  3. BoxHead

    Back End tables exist on an obsolete server

    When you say original, if you mean the mdb prior to splitting - I do not. I built the db 4 years ago, left the company for a year and came back in a different position. All of the files, folders, and drives with my projects from the first position I held here were 'cleaned up' when I left.
  4. BoxHead

    Back End tables exist on an obsolete server

    Our server crashed and all of the backup files were moved to a new server with a different name. My front end will not open at all. A message appears stating that the path is not valid. Holding shift while opening and F11 are not getting me any further. Is there a way to change linked tables...
  5. BoxHead

    Monthly Booking Report

    Our Monthly Booking Report is pulling all Sales Orders with Document Dates within the month that are NOT backorders. The result is that I enter a new $75K order on May 4th and that amount is included in the Monthly Booking Report. We ship $5K worth of product against that order on May 6th and...
  6. BoxHead

    Keeping a for on top ??

    It's hard to picture exactly what you have or what you're after, but it sounds like subforms could work for you. However, if the form is working, consider setting the properties of the tab control so it has no tabs (Style = None) and using command buttons to set the focus to the aprropriate...
  7. BoxHead

    riddle picture

    Interesting thread... I looked at the picture expecting an Old lady with babushka -vs- young woman with a feather sort of thing. I noticed that where I have the 'current time of day' on my desktop, this person has the 'current year' so I thought it was maybe the desk top of someone with an...
  8. BoxHead

    Favorite Quotes

    My favs If God wanted us to keep our hands on the steering wheel, he wouldn't have put it so close to our knees. The last words of some poet: "18 whiskeys - I think that's a record." Ugly is no excuse for stupid. Threatening: "I'll f@#$ you so hard and so many ways, you'll think you fell...
  9. BoxHead

    Fake names and silly words

    Santa, With the last name Finnegan, my family also has a "No Michael" rule. When I'm required to provide an email address, I usually use john@leavemethehellalone.com. I figure if there is such an address, he's not checking his mail anyway. And ESquared, I had a friend years ago who would use...
  10. BoxHead

    Certification Training

    Prosper, Thanks! The truth is what I'm looking for. John
  11. BoxHead

    Certification Training

    I've been approved for a grant through the local unemployment office to take computer training. I've been working with Access for seven years building dbs and specializing in streamlining data management. Module-level functions. VBA/SQL coding. Custom forms. etc... While looking for work I...
  12. BoxHead

    right-align a column in ListBox

    With the font set to Courier, the following right-aligns the loan amounts form the loan table. SELECT Space(20-(len( format(LoanAmount,"currency")))) & format(LoanAmount,"currency") FROM tblLoans; HTH John
  13. BoxHead

    "Beagle to Be Awarded for Saving Owner"

    Save a life - get a dog! Seems pretty simple. I would think that more people would be willing to try the Good Samaritan Thing if they thought they might win a dog. Actually, I like to think that there are people like me (who only read the headlines) out there right now calling cabs for...
  14. BoxHead

    Moist(er)(turer)

    Years ago I worked with a carpenter named Frank who found a simple solution to all of the "-er" and "-est" questions. Prone to use the F word at least once per breath, he coined the word, "F--kingest" and used it as "F--kingest Stupid thing I ever heard!" "F--kingest Crazy thing I ever saw!"...
  15. BoxHead

    Moist(er)(turer)

    How about saying, "The brownies on the right are mine. The kids can have the brownies on the left (they'll never know the difference). And SilentAiche, as always, you are definitely somewhere left of center." [wink] Boy, I'm hungry for brownies all of a sudden. Thanks all. John Life is...
See more

Part and Inventory Search

Back
Top