I downloaded this off another forum some time ago. The paper is yellow its so old but it works great.
I don't recall whose code it is but it works like a charm for year and sequence. If you recognize it please claim it.
(quote)
Create two fields in your table:
TheYear - long
TheSequence –...
Had a fellow on a local radio talk show talking about the acceptable expression in the US was now "African-American". He had a Jamaican accent.
Caller - Where were you born?
Response - Jamaica
Caller - Wouldn't that make you a Caribe-American?
Response - none
Host - let's go to commercial.
Not unlike the Isle of Dog's Declaration of Independence in the 1960's.
The squeaky wheel gets the grease.
The Cornish local economy was based on their tin mines until the British manufactueres discovered they could buy tin on the world market for less than they could mine it in Cornwall...
An old political trick.
The upper level of government brings in a program just before election time. They fund it until everyone gets used to it. Then they download it on the next lower level of government saying we're not going to fund it anymore. If you want it to continue, you pay for it...
Bill Gates has given substanial amounts to a number or organizations over the years, primarily dealing with world health problems.
He is not especially stingy with his billions.
BTW according to Forbes magazine richest men poll which came out this week, Bill is no the richest man in the world...
You have crossed a threshold. You are no longer dealing with Excel spreadsheets, you are now dealing with Access tables.
On the Access top menu, select File and choose Get External Data.
Select Import
Import your Excel spreadsheet. This should work OK as you have stated the spreadsheet is set...
Some may think you're being a little negative Rich.
As I seem to get the same ones you do, I can understand.
By the way, the bank clerk from Nigeria went to work for a bank in Russia and then for another in Hong Kong.
I have been looking through emailing reports on the search function.
The majority seem to deal with Outlook.
Any special problems I should be aware of if the client uses Lotus Notes?
If you are talking about copying and pasting to a table in design view, you can only do one field at a time.
If you have a large number to paste to, you may want to consider an update query.
BET (Black Entertainment Television) is a cable channel. You have to pay to get it.
If you want to pay, it's your money.
As to the White Entertainment Channel...after you run out of All in the Family re-runs, what are you going to show?
According to FIFA, the most popular sport in the world.
If you look at the TV numbers for World Cup, under 21 etc. They're probably right.
UP THE GUNNERS!!!
I rarely belly ache to anyone about anything.
Do you think if I complained to the local council they would take them away?
Fat chance, now that they've paid for them and all.
Please do not misunderstand. There are situations the police have to deal with that requires a "heavy mob".
There are a large number of ancient fault lines all over the US. It's just that the ones in California get all the headlines.
The plates where the Atlantic coastal plane meets the Appalations (sp) are constantly grinding. I lived for a while in upstate NY near Lake Placid. We used to get...