Recent content by Peanuts

Sounds just like mine, except that I don't get an error message on anything, and I can't even get into the design view of my form.

I have been trying to think of what might cause this to happen. My form is where I enter the data. This data changes, so what I do is go into my form, deleate the old data (highlight and type over) and reinter the new data, save then compact and repair. Some days I might have to do this 3...

Well, I'm not sure about compiling the code, I have saved the code. I set my databases up to compact and repair on close. When I transfer everything over to a new database everything works great.

What would make a form just quit opening? I have a database with 6 different forms in it. Only one is a sub form. My main form, ( the one I use most) has quit opening. I click on that form, the hour glass runs then turns off and nothing opens. All other forms, tables,queries, reports open...

Hi Elana, raskew, Thanks for your help and info ! I just took off the "close" in the DoCmd in the code. It works great now although the thought for the day stays on, which will be alright. Our company has several lines of it "creed" and several leasing/marketing "tips" that they like to...

Hey, kool idea, I installed it in a form but when it closes down the whole form closes. How do I stop that from happening? Thanks

Hey, Thanks for yyour help Nouba! I'll see if I can get one of these to work for me. Thanks again Peanuts

The report I am working on is a lease agreement. If a person moves in on a date after the first of the month, then the lease actually starts the first of the next month. The partial month that the person moved in on is pro-rated. The persons rent is the full amount the first of the next...

I Figgered it out ! Hey, Many Thanks to Raskew, I finally figgered it out. He was exactly right and If I had any inkling of what I was doing I would have seen my mistakes earlier.

Enter Parimeter Value? This code works from the debug window, but for the life of me I can't get it to work in the text box on my report. I either get a blank box, or an enter parimeter value? Any other ideas? Thanks Pat

Ok, I'm thick headed, I'm just not catching the clue on working with dates. Comming from my form to my report I have a set date relating to that particular form/person. That date might range from 01/03/1999 to today's date. I need to make another text box that returns the end of the month...

I have a report page that has to calculate a formula using the days in a month. The formula I use on my job is say: $500.00 divided by 30 days, = $16.66 per day Times a number of days left in any given month. So, if the purchase date was the 8th day of March, then it would be 24 days times...

I have a report that I have to send on random days. I can print it out and the current date showes 03/13/03 just like it is susposed to do. Now, On two other lines in the report it needs to say period beginning March 1, 2003 and the other line needs to say period ending March 31, 2003. Is...

I need to print a packet of reports. What would be the easiest way to print, say 5 reports, from the current form that I have open?

Thanks Kevin, I finally got it figured out. My problem was "where" I was sending it. report name vs id number. Duh. NOW, that I/we have it printing the correct file in the report, I need to have it make three copies. Can you help me on that?