Search results for query: *

Thanks for the help! You saved me again!

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...

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.

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...

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...

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...

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...

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...

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...

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

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...

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

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...

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!"...

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...

Penultimoist? John Life is short. Build something.

2ffat, Don't you mean 'hanged'? See thread1256-1201508 [smile] [wink] John Life is short. Build something.

smuthcrmn777, Didn't mean to leave you hanging. I could have sworn I submitted a reply to you 6/8 post... If you comment out the code on the Load event that throws the focus to the last record, does the form open to the first record in the recordset? If it doesn't, do a CTRL+F search in...

Sorry it didn't help. It sounds like you have multiple users using copies instead of just the "problem" user. That suggests that there may be something special about this person? Is this user logged in as the SQL Administrator? The Network Administrator? Are there other programs hitting the...

What code do you have that throws the focus to the last recor? By default, when I create a continuous form, it will open to the first record. Look for another event that's moving it to the last record after the form loads. I created a quick continuous form to re-test the code and it works...