Search results

Morning all. I'm struggling with a data entry form. After entering it one time, I'm trying to get the [Week Ending] date to carry forward to the next record(s), until I change it or have entered all my new records. Based on info I received here, I put this code into BeforeUpdate property of...

Thanks so much. Yup, that put me back on track--thanks again for taking the time to help me through brain dead moment. BeckieO

Don't want to sound dense, but... I can't get it to work. I've probably missed a step, but I put" =[Week Ending].[BeforeUpdate] in the Default Value section of the control's properties form. Nothing happens. Did I read the suggestion wrong?

Morning all! I've done some searches, but can't find this one, so: I need to enter multiple new records, all using the same "Week Ending" date. I would like to use a form for the data entry and enter the date only once. With this in mind, I created a Single Form for the Week Ending field. I...

Took the easy way out... I just went ahead and made a second update query to replace the multiple spaces with a single space. There's probably a better way to handle this, but this is quick and gets the job done. Meanwhile, I'll keep working with the code from Moniker, 'cause the more I figure...

Preaching to the Choir Like Grandma used to say, "You're preaching to the choir." I couldn't agree more, and I believe we are actually working in that direction (style guide) for upcoming events, processes and changes. Of course, change comes slowly so meanwhile, we have to deal with the...

First step works, but... Thanks so much for your quick responses. Moniker is right, I do end up with multiple spaces that need to be replaced with single spaces. I've been able to successfully use the single Replace following Michael's instructions. But when I try to use 'AND" to add more...

The records that I'm working with are pulled weekly from another db, which has been modified by a boatload of folks, over the years. Every one of them had their little ways of doing things. The data in "Product" field isn't always entered the same way. For example: SS_11_0101__Z2 and SS...

92 Years Old... Mary (85)and Joe (92) lived quietly in their first floor apartment. They'd had a fine life, married for 70 years, raised a great family of independent, successful children and were just enjoying their last years together, still active and healthy. One day Anne, a beautiful 45...

Code That Works for Me Based on advise from The_Doc_Man, after a little research, I inserted this code into my module: ' Remove Files from Drive Kill ("C:\My Documents\SendFiles\*.snp") It removes all Snapshot files from the folder, as soon as the email is sent. Thought maybe someone else...

Good Deal!! Just the kind of info I was hoping for. Thanks so much. BeckieO

Before I spend a load of time on this, thought I'd check to see if it's even possible. Thanks to some help from folks here, I have some code that allows me to output some reports to a folder and then email those reports as attachments, all from inside my db. Now I'd also like to delete those...

Works Like a Charm Thanks again--you broke it down to my level, and it appears to be working fine. Hope some day I'll be able to provide support for someone else, too. BeckieO

I'm having a total brain freeze here. Last week, I posted for help getting an email (with attachments) sent from inside an Access database. With some help from my friends here, I fought through the issues and got the code in the module to work, when tested from the immediate window...

Thanks again--figured it out and it's working great. Again, thanks for helping me look good. BeckieO

Thanks for the code Thanks for the code. I've worked with it as much as I could today (time constraints) and I can't figure out what to do with it. Hate to sound stupid, but should I use your code in addition to or instead of the code I've been working with? Thanks again, BeckieO

Hi, all!! I need to generate 1 email with 3 attachments from an Access Db. These attachments are canned reports that are generated each week with fresh data. I've done several searches and found a lot of good information here. Based on what I've read, I decided to output the 3 reports to a...

Got IT! Stumbled on the answer and thought maybe there is someone else (like me) who didn't know. Added "Restore" command into Open Query macro that's attached to the button. Thanks anyway. BeckieO

Greetings all. I've got a minor housekeeping issue with my db that I can't seem to crack. The db opens to the main form, which has a boat-load of control buttons that open a variety of forms and reports and 1 query. The problem is that when you select the button that opens the simple query...

Morning All! Boss-Man has a db (humongous) that (along with a zillion other things) tracks which specific tasks have been completed, who has done it and when did they do it. All tasks will eventually be completed by all employees. He's got a query that returns all of the dates on which each...