Viewing 15 posts - 1 through 15 (of 60 total)
As mentioned by Rich B, you can cross the seconds boundary. It depends when you execute.
November 17, 2009 at 8:54 am
I've never done this with views, but stored procedures wortk like a charm.
The trick is in the Access ado form property called Input Parameter.
You place and equalization between your stored...
April 21, 2008 at 5:42 am
Thanks Michael! That answers alot. I was just suprised to see this conversion action taking place during a where clause, but it at least it makes some sense...
March 31, 2008 at 9:29 am
How about a coalesce statement? This would provide the first non-null entry amountst the 4 date values
Select COALESCE(date1,date2,date3,date4) as Stage
You could also rever the pattern to check date4...
March 7, 2008 at 7:28 am
I would start the process with the Access upsize wizard utility. Since they want to end up with an Access viewer, the upsize wizard wizard will give you two...
March 7, 2008 at 7:23 am
If I'm not mistaken, you can highlight all the colums you want to change with a ctrl-click or shift-click. Then make the data type change on the right side...
January 10, 2008 at 5:43 am
What error message is being thrown?
January 7, 2008 at 6:09 am
Looks like you're being handed a report or screen copy. You can try to run 7 different imports to stagin tables, 1 for each report header line, then one...
December 27, 2007 at 8:45 am
I don't have a solution, but shouldn't it be "toys 'r us" with a single quote before the r? Maybe the data can be corrected before you receive it?
December 27, 2007 at 8:24 am
Have you tried to change the error handling section for the data source object? You can set the Truncation portion to ignore failure.
Right click on your data source and...
December 21, 2007 at 6:09 am
I'm guessing that the pdf is throwing out the initial page break while excel is keeping it. Try changing the Page break at start to a page break at...
December 18, 2007 at 5:15 am
I tried to find a "Middle Join" definition thinking they added something new to 2005 which might be helpful.
December 14, 2007 at 6:07 am
Can you convert the item to text in the select statement?
SELECT CAST([Item #] as varchar(20)) , [Description], [Pack Size], [Price] FROM
[Database=C:\Test.xls;Excel 8.0;HDR=Yes;IMEX=2].[Sheet1$] Where
[Item #] Is Not Null
December 14, 2007 at 5:59 am
It looks like you are summing the sqm total over each widget type, not over the entire dataset.
Widget factory 1
Widget type 1 50 - 1000 sqm
Widget type 2 75...
December 10, 2007 at 5:27 am
I agree. A master adp is the way to go. I created a version table visible through a Help...About menu and placed some version checking in the software....
December 7, 2007 at 5:06 am