Search results

I thought the reason might be that spacwe aliens were breeding among us weakening the species and we would die off by microbes like the Martians in H.G. Wells "The War of the Worlds".

Does anyone over fifty remember anyone getting sick from peanuts as a child? A dentist friends suggests it amy be caused by the extensive immunizations we have given children over the years.

What's up with peanuts? When I was a kid EVERYONE ate peanut butter and jelly sandwiches. No kids died at school or went into spasms because they touched a friends sandwhich. And I surely don't recall anyone dying from kissing their sweetheart with peanut breath. Now shcools in the U.S...

Brian. That's exactly what I needed. Thanks!

I need to enter a date field into an appended table that is the same day but one month prior. For example today is 6/5/2008 and if I ran the query I want the date to appear as 5/5/2008. Thanks for any help on this.

Al Gore won his Emmy for creating a company that distributes information by allowing users to post video. I thought You Tube already did that.

Oh sure. Let's take them to court then.

No Brian, they just used good old American leadership and ingenuity to make computers and software available to people like us.

Yes, we make our living creating databases on computers. Next thing you know you'll be telling me that Bill Gates and Michael Dell are really British.

Erik and Bob, I think you are saying that the array module I inherited may not be the best way to handle this operation. Basically I have one report of 245 vendors, each vendor with it's own page copntrolled by one query. I need to send a RTF (or more ideally a doc) file for each page of the...

When I step into the module it goes through with no prioblem then pops up the error "Too few parameters. Expected 2." error. I tried to compress the application to upload but even after compact and repair and compression it is just too large. Thanks for the help so far.

I tried this and got an If without End If error. When i corrected that I got a "Too Few Parmeters - Expected 2" error. Can I direct the OpenRecordset to a query vs a table?

Here is the entire module. Note that I did not include the entire 241 vendor array but did include the first two and the last two so you can see how it is conctructed. Thanks for any help. Function SendRTFFiles() On Error GoTo Err_Command0_Click Dim strSQL As String Dim strFileName As...

Bob. Where is your post on uploading a DB to the site?

Bob, I only included part of the code. Right now the module does exactly what it is instructed to do - sends the report page by page as individual reports in RTF format to a specific folder with a file name of Vendor Name + Year Month.RTF. The client now wants the file name to be Vendor...

I have an array module which opens a report and sends vendor report cards (245) as RTF files to a folder. The reports are based on the vendor name. All was going well qwhen the client decided that the file name needed to use the vendor number vs the vendor name. The vendor number is a field...

It works perfectly! Thank you!

This worked perfectly... except when I looked at the final files I realized that I need to have the month show the previous month name. For example the report run in May needs to have file names such as April 2008 - ford motor company.rtf . Sorry I wasn't clear on this.

How would that code look replacing april 2008 in the example above?

I have a vendor report card application which creates an individual RTF file for each of 245 vendors through a module with an array. The files are named as shown below. for example a file name might be April 2008 - ford motor company.rtf . DoCmd.OpenReport "Report Card YTD", acViewPreview, ...