Search results

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.

Or the English to the Scots and Welsh.

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

WHAT FREEDOM. If they did it once, what's to prevent them from locking up all the Kens on national security grounds! We'll save a cell at Gitmo for you.

Without resorting to the difference in conditions, please remind me...how much did the Allied governments pay the German, Italian and Japanese POWs. It seems to have slipped my mind. They may have only been token remarks, but at least they were made. The Japanese apologies I am referring to...

Ken: If you were imprisoned for four years without a charge, without any evidence and without a trial and then were released to discover everything you owned had been sold without your consent...how long would it take you to get over it? Rich: The Japanese government did apologize for it's...

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.

When the government of the day realizes an injustice has been committed in the past, they should apologize and do what they can to make ammends. Just like adults are supposed to do. In 1941 and 1942 the governments of the US and Canada deported thousands of Japanese from the Pacific coastal...

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

Place your index in the Report Header of your report. Set the page break to go to a new page after it prints the report header. That way it will only print on the first page.

Believe or not, there are war mongering Democrats and peace loving Republicans. The party lines in the US are not as clearly defined as they are in other democratic countries. Don't forget it was Theodore Roosevelt, a Republican who brought in anti trust and pure food and drug laws. Lyndon...

I was called in on a consult. The database was on a server with no security. A couple of employees who thought they knew Access had been making changes and of course they messed it up. "How long will it take to fix it" asked the Manager. "I don't know" came my reply. "Why don't you know?"...

With your subreport in design view, check the properties of the sub report. Find out the name of the table or query that runs the sub report. It sounds as though you may have missed updating the query that runs the subreport.

These functions are available as macros. Create a minimize macro and a maximize macro, then put command buttons on the form set to run the appropriate macro.

This is a unique question - Congratulations. Could you explain why you wish to do this as I don't see what the purpose would be.

Are you sure this shouldn't be in GEEK TOYS?

I do this frequently by way of a macro. In the query for your report enter in the criteria line for the field you wish to use on your form to generate the report: [Forms]![FormName]![textboxname] Where FormName is the name of the form you are using and textboxname is the name of the textbox on...

Rich: While your instructions for making tea are correct, try finding loose tea on this side of the pond.