Search results

Belated Happy Birthday!

Supposedly, these are actual advertisements that have appeared in papers across the country Lost: small apricot poodle. Reward. Neutered. Like one of the family. A superb and inexpensive restaurant. Fine food expertly served by waitresses in appetizing forms. Dinner Special -- Turkey $2.35...

In a way, George Washington was an unlucky President. He could not blame the previous Administration.

Bob, I looked at your objXL code in other threads and made it to work. This is what I used. For simplicity, I used a Form. ----------------------------------------- Dim objXL As Object Dim xlWB As Object Set objXL = CreateObject("Excel.Application") Set xlWB =...

A big shot city lawyer and an old country farmer got into a car wreck. They both got out of their cars to survey the damage. After looking over the lawyer in his $1,000 suit, the farmer walked back to his car, got out a bottle, and brought it back. He handed it to the lawyer, and said...

Thanks Bob. I was not able to make it to work. No error messages. I was using .xls file. I will play with it more. I do have references to Microsoft Excel 12.0 object Library. Jacob

I use WindowsXP and ACCESS2007. Using VBA (in ACCESS) how can I delete any one worksheet from an EXCEL file? I have an EXCEL file called STAFFING.xls. It has several worksheets like ENG, FIN, IT, HR etc. How can I delete just one worksheet (FIN) using VBA in ACCESS? Any help will be appreciated.

Congrats to Hey & Jez. Can you please post a wedding picture? Thanks.

BP announced today that they will no longer hire Cajuns to help in the cleanup. Thibodeaux, Boudreaux,and Fontenot were told to clean as many brown pelicans as they could.... So far, Thibodeaux has cleaned and gutted over 56 birds while Boudreaux made the roux and Fontenot cooked the rice.

The art of politics is given below: 1. Get votes from the poor promising to transfer wealth from the rich to them. 2. Get money from the rich promising to protect them from the poor. Individual politicians are smart to use some adaptation of this theme. For example, some will claim they are...

Where is your church? Country & State Our church in the USA (Virginia) is doing good.

Thanks. It worked. My text align was 'General'. When I changed it to 'Right' it worked. Thanks again. I knew someone will help me.

I have a list box that shows 3 fields: Invoice_number (text) US_amount (number) Foreign_Amount (number) The data is displayed left justified. I would like to see US_amount and Foreign_amount displayed right justified. How do I do that? Thanks in advance for your help.

Thanks a lot. It worked.

I use WindowsXP and ACCESS2007. I would like to programatically close the ACCESS object window on form Load. How can I do it? I know I can close it using 'Access options' on Microsoft buttoons. I would like to do it programatically. Any help will be appreciated.

That is what I thought. Thanks for the reply.

When I open a table using a command Docmd.opentable "tblA" Is it possible to format selected rows (color, Bold, Italics etc) based on a field value of that row. If possible, please let me know how to do it. I use WndowsXP and ACCESS2007. Thanks in advance.

As I started reading this thread I was curious if any foul play was committed by anyone on this issue. Now I have concluded that it's all fowl play. Just joking

Thanks for the quick reply. I will try what you suggested.

I want to create a new column by using ampersand with 2 existing columns in a query. I want to maintain a constant width for the new column. For example: (varA and varB are 2 existing columns.) varA varB July xyz August abcd When I concatenate Using a query, I...