Search results

You should be able to do this given the following. Where is the OrderID assigned using AutoID. If it's in the Order table you should be OK. If an OrderID is being assigned in the Basket table, you're going to have a problem as the autonumbers in Basket and in Order will be fighting for...

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 –...

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?

I'm sure Rich will try to link this to Iraq somehow :D

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.

The trick is to know the things you don't know. That way you can stick to the things you do know. For the things you don't know... Hire a contractor.

I assume you have this logo somewhere else on your computer. If so, simply insert it into your report while in design view. Be sure to Embed it.

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".

Actually I was just checking with my Rand McNally. I-75 to Cincinatti State Route (unknown) to Illinois I-43 through Chicago to WI.

This is a common problem (for me at any rate). It often occurs when you atempt to multiply zero times zero or divide zero into zero. Access can't do this with zeros. Try the IIF function with the calculations: IIF ([Field1]>0 and [Field2]>0 ([Field1]*[Field2])),0 Haven't done this for a...

Going by this post and your previous one (answered by Gemma) it sounds as though you are using the default workgroup - System.mdw as your workgroup file. Each database where you wish to have security should have its own workgroup file (don't name it System) saved in the same folder as the back...

I-75 to Detroit. Then ask.

On those few occasions I have required police assistance, it has always arrived promptly.

SWAT Special Weapons and Tactics. Originated in Los Angeles in the late 60's as an excuse to give police automatic rifles and other toys. Some of the other definitions offered may be closer to the mark.

1957 - Colin and Rich (lol) trade sandwiches at lunch. Colin eats Rich's tuna and Rich eats Colin's peanut butter. Both break out in rashes. Nurse puts lotion on rash and tells Colin & Rich not to play in the Poisin Ivy. 2007 - Colin & Rich rushed to hospital, filled full of eppy, placed on...