Search results

I'm assuming that since you were struck by lightening you voted that YES you are an atheist.

OK. After 22 views with no response I'm guessing that I've finally bumped into a limitation of Access with no resolution. The client will jusdt have to watch the reports (pages) fly by.

I have a report that provides report card performance information for 245 vendors. An array in a module sends each page of the report (By vendor name) as an RTF file to a specified folder. In this module the report is opened and each report (page) is viewed (DoCmd.OpenReport "Report Card...

jzwp22 - that worked perfectly! Thank you. Any ideas on creating PDF files in the same manner?

I inherited a report that shows performance for 245 vendors. An array creates a seperate report (one for each page of the Access report) for each vendor in RTF format. It works beautifully except for thwe fact that the output winds up, usually, in my C drive My Documents folder though it can...

Speaking of someone not understanding facts, we have not dropped bombs on everybody else - Great Britain for instance. And we haven't dropped bombs on Greenland or Iceland either.

Better than waiting so long that we're the recipients of the bombs.

I see Obama finally took a stand against Reverend Jerimiah Wright. Good to know that if he becomes president it will only take him twenty years to realize when something is amiss and take corrective action.

Bob, I performed steps two and three before your reply. It seemed the only way out after thinking about it. For my own learning purposes - what is the purpose of step 1? Also, is there a single on/off for autocorrect or do I deselect all the choices in options?

I have a table with more than 700,000 records. There are no unique fields or unique combination of fields. I would like to add an AutoNumber field but when I try I get the message: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. If I answer yes I get an error that...

I have three queries that count non-compliant records in each of three catagories per month. One catagory has records for both Jan and Feb and returns the rersults as follows: Jan 3 Feb 4 The other two vatagories however have no non-compliant records for January so they return as follows...

I'd just like to add that most queries are multiple criteria across multiple tables. I don't know about it being easier but I'm sure it's not wise to put all of the information into one table.

Maybe Hillary can get an embassadorship to Lower Ebonia working for Secretary of State Reverend Jerimiah Wright.

I heard Barak was planning to make Pastor Jerimiah wright Secretary of State.

Thank you both for the quick reply. Bob, you concise solution was exactly what I needed - once again. This will save a ton of data entry so I know the end users thank you also.

I have a database where the majority of fields are the same record to record. For instance the only thing that changes is the line item number for a purchase order. I have a button that copies most of the fields to the next record (code is below). The problem is that if any field does not...

I have a form with two required fields. I have used the following code to show a message box and set the focus to the proper field. It works great if a field at a tab stop after the required field is chosen. The problem comes when a user begins a record the goes straight to the create a new...

Thanks Guus2005. This is exactly what I needed - though I took the liberty to exchange dombo with something more P.C. for my client.

I have a form from which I send and Email to the responsible party for a task. The e-mail address is picked up from a fielsd in the form named Email and the VBA runs on an on click event from a button on the form. The only problem is when someone clicks the button but there is no email entry...

Thanks Fifty2One. I think I need to clarify my problem a bit. Form A is a continuous form with an enty for each Purchase Order/Line Number with info sucha as qty ordered, price matl description etc. On this form is the command button which opend Form B which shows the corresponcence...