Viewing 15 posts - 286 through 300 (of 621 total)
Well, no one has responded yet, and, admitedly, I can't say why you are getting your errors, but I would suggest trying to use a format file. You can...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 25, 2009 at 4:51 pm
pwatson, the below is one example of how to post readily consumable code, so we can simply cut and paste into QA. This is just a general example of...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 25, 2009 at 1:35 pm
I might be over simplifying this, but why can't you do
SELECT
Col1,Col2,Col3,Col4
FROM YourTable
?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 24, 2009 at 5:21 pm
iapearsall, I'm not really sure what you are asking. Do you think you have an Access problem or a SQL Server trigger problem? Without full table definitions...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 4, 2009 at 11:58 am
Ken, if you have to use datasheet view, you may have to leave it locked, in a subform, then on a different form, possibly a popup, have some unbound text...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 20, 2009 at 1:11 pm
Are you trying to update the records directly from an Access form or grid? Typically what I do is have some unbound text boxes on a form, then with...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 20, 2009 at 9:34 am
You could try this, which would eliminate the CASE. There are probably some instances that would break it, but for cases where there is never a space in the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 17, 2009 at 8:49 am
Karthik, how is the country choice passed to your database? String? What does it look like?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 9, 2009 at 7:14 am
Brent, I have to agree with Allen. Unless there is data in the Access database you are using in your crosstabs, you would probably be best served doing as...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 8, 2009 at 8:59 am
Gent
This is a 2000 forum, but this...
SELECT DATEPART(qq,GETDATE())
will give you the quarter.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 2, 2009 at 9:16 am
Greg Snidow (6/1/2009)
Lowell (6/1/2009)
I would switch tou using the row number function then...
I think he's using SQL 2000?
I'm not sure if I'm over simplifying this, but is this what you...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 1, 2009 at 6:31 pm
Lowell (6/1/2009)
I would switch tou using the row number function then...
I think he's using SQL 2000?
I'm not sure if I'm over simplifying this, but is this what you are looking...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 1, 2009 at 4:25 pm
Aha...that makes much sense now. Thanks for the input.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 28, 2009 at 10:54 pm
Look in BOL for 'linked servers' or 'OPENROWSET'.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 28, 2009 at 11:45 am
Daryl
I'm not getting the same results as you are getting. Check out my code below, just to make sure I have captured your process correctly. Please note how...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 28, 2009 at 8:04 am
Viewing 15 posts - 286 through 300 (of 621 total)