Viewing 15 posts - 1 through 15 (of 70 total)
Much more productive at home. Mostly because I'm physically comfortable. How many offices will pay for a $1000 recliner? When my skilled trades friends visit when I'm working, they're always...
May 26, 2006 at 9:18 am
By the way, the reason this occurs, according to some of the threads, is that Access tries to "help" you with this by saving the filter value when you open...
January 27, 2006 at 3:52 pm
I googled this using serverfilter and this is the best answer I've seen. I've run into this before and I just clicked the filter button twice and it "fixes" it,...
January 27, 2006 at 3:50 pm
you're right. It's user defined functions that aren't allowed to be used as defaults. My bad.
January 27, 2006 at 7:07 am
I don't think you can use functions as defaults, either.
January 26, 2006 at 11:49 pm
shouldn't it be:
" and Person_ID =" & Person_ID
I think the error message came from not having an equal sign (=) AND not having the space.
January 26, 2006 at 11:46 pm
Here's what I use to make the month/day/year.
strYear = right(year(date()),2)
strDay = right("0" & cstr(day(date())),2)
strMonth = right("0" & cstr(Month(date())),2)
Then in one fell swoop, I concatenate all three of these strings to...
July 8, 2005 at 1:46 am
I hope you didn't take my answer as though I was insulting you. I truly hope you CAN add a field. Otherwise, you'd be like one of the "users" people like...
September 9, 2004 at 1:16 pm
Since most databases use their own definitions of what constitutes a date, you'd be better off converting the Oracle date to a string and then converting that string to a...
September 9, 2004 at 4:50 am
A bigger sample of data would have been clearer.
I believe what you're wanting is :
Select a, b, c, d from table
1,23,34,56
56,67,78,89
89,90,32,23
23,36,75,24
Is that what you were talking about? The fourth column...
September 9, 2004 at 4:46 am
Hi Subhash,
Great Plains huh? I've worked with them since version 3.15 and most of their legacy code is still written like they are using Btrieve. All of their examples use...
September 9, 2004 at 12:08 am
The problem that I see is that you don't have the field ZoneCombo listed in your cursor's select statement.
You use the OF keyword to limit the updating to specific...
September 8, 2004 at 10:38 pm
In general, lookups are performance killers in DTS packages.
If I were using DTS against millions of records, I'd not use a lookup. Could you add the foundkey in your source...
September 8, 2004 at 10:30 pm
You would benefit from a performance perspective if you created a separate connection for your lookup. Have you tried creating another connection and using that for your lookup?
September 8, 2004 at 10:27 pm
Is the type1 table in the same server.database from which you're executing the stored proc? It sounds like the table doesn't exist in that database.
September 8, 2004 at 10:09 pm
Viewing 15 posts - 1 through 15 (of 70 total)