Recent content by misterhux

Stupid me, I ended up figuring it out. That's what happens when you take a break and go do something else for liek 20 minutes the solution just pops in the head.

Thanks alot for your help. But I ended up figuring it out. That's what happens when you take a break and go do something else for liek 20 minutes the solution just pops in the head.

I'm having a major problem with my docmd.transfertext for some reason it is not importing the last line of the .CSV file. I looked at the last line, and it ends in a carrage return, and when I load the .CSV into excel it works fine. does anyone have any idea on how to fix/work around this...

I'm having a major problem with my docmd.transfertext for some reason it is not importing the last line of the .CSV file. I looked at the last line, and it ends in a carrage return, and when I load the .CSV into excel it works fine. does anyone have any idea on how to fix/work around this...

ronnies ... did you ever solve this?

Erik160 did you ever get a solution to this problem?

and even if they don't "offically" support it (I'm talking about OS's here) they still test all there new software to see that it plays nice with their old OS's

find it interesting that they (RNC) is trying to reach the youth population kinda like Dean, but they are going about it completely backwards and typical of republicans (throw money at what they don't fully understand). cause nothing tweeks me off more then popups

thanks for your advice... don't know what was wrong with it, but created a new (another) index for the table and it works fine.

okay so I'm bashing my head against a wall here... we just upgraded our SQL Server 2000 hardware and now one of the tables no longer returns its records in the correct order (ie sorted by primary key) it seems to just pick a random order, and only when its not a select * operation. I was just...

FYI ... figured it out by creating own function CREATE function dbo.udf_columnDataType (@txtTableName nvarchar(50), @txtColumnName nvarchar(50)) returns nvarchar(25) AS BEGIN -- purpose is to return the data type of the supplied column declare @txtReturn nvarchar(25) declare @txtDataType...

have you tried using something like union selects : select u.male, u.female from (count(field) as male where field = "male" Union select count(field) as female where = "female"...) as u (note this wont actually run, but its a start)

quick question is there any way in SQL server 2000 to get the type of an field ... ie something like select ID, "TypeOf"(ID), Name, "TypeOf"(Name) from blah_table returning something like ID Name ---- ------- -------- -------- 1 integer Andy nvarchar 3 integer...

yeah I'm all in it for the Lattes

even having a single proof reader is not enough.... This once got through my readering (2x) and a co-workers reading: "The Untied States of America..."