Search results

No, you don't need it. You just think you do. I know hundreds of people that don't own a computer, they are surviving just fine. Maybe that's your problem, you have a basic inabliity to grasp simple concepts. And guess what, I can just as easily kill someone with a paintball or an air rifle.

More automobiles are stolen every day in the US than guns. What control are you imagining?

I target shoot. Why do you own a computer? You don't *need* it.

And there are more than that due to automobiles. What's your point?

That's a blatant lie, or more likely complete ignorance, or just someone lacking in basic chemical knowledge. I can make a bomb out of materials from the local hardware store, and if I go to 2 or 3 of them, no one will question what I am buying. And I kill a whole heck of a lot more than 32...

Neither did his guns. He did. A gun (or a toothbrush) can sit on a table for 5,000 years and never harm a soul until a person decides to take actions. I find it humourous that people blame inanimate objects as if the object has some sort of sentience which allows it to wander the streets at...

Exactly my point.

I own three guns. None have them have ever killed anyone. Well, one propably did - it's a WWI rifle.

If you are still having errors, take out all your error handling and see where it errors. What are the errors?

I don't see how that is relevant to my situation. The HTML output is fine. The files are being written correctly. The code works as it should. What I don't want is Access to continually telling me that it's outputting every file when it cycles through each record in the recordset. Thanks...

It's not a warning, just a dialogue box saying that it's outputting the report. And even after messing with it, it does not seem to work, as I am typing this it keeps taking me back to access.

I've recently "upgraded" to 2007, and here is something that is REALLY ticking me off as it did not do it in the previous version I used. When I get open up my database it checks to the last time I ran a series of reports. If it hasn't been done yet today it runs the report and publishes it to...

Put this in the OnEnter for the date field, or any other event that might be appropriat me.datefieldname = Dmax("[yourdatefield]","[yourtable]")+1

The way to do it is forget about what you used to have on hand. Instead build a query that takes the sum of the received in and the sum of the amount shipped out and subtract them. Why do you need to see a running inventory for every line? My inventory report is similar to the screen shot of...

Just combine the code. It's that simple, really. ;) W/o the error handling: DoCmd.close DoCmd.OpenForm criteria

Yeah, I was running Access 97 with 256MB or Ram with no issues. Upgraded everything to 2007, and it was like watching maple syrup being harvested when I ran certain codes. Bumped to 2GB of RAM and it made a world of difference. Of course it didn't help when I had Aceess/Outlook/Internet...

Some things I like. Some things I do not like. I've used 97, 2000, 2003, and now 2007. 2007 is a resource hog.

Convert it to a string. CStr(Yournumberhere)

There's a default value field in the properties of the combo box.

Where are you getting the [Date] from? Is it an input box, or a text box on the form?