Search results for query: *

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

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

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

does anyone know what the RGB values for the dis-enabled controls are? (That nice lovely beige) thanks

Is there a way to see/edit what IE explorer places in those little drop down boxes. More Specifically is there a way to change what logins and passwords IE remembers for each site?

hey does anyone know what a run-time error of 0 (zero) is?... the text of the error just says: Reserved Error this is the code that is giving it (error at --> ) Private Sub Form_AfterDelConfirm(Status As Integer) Dim dbJetAftDel As DAO.Database Set dbJetAftDel = CurrentDb...

Hey, I was wondering if it was possible to append a field to a recordset that I got from calling a stored proc? thanks

hey... what I have is 2 subforms (A and B), A's underlying recordset is based off a remote table, while B's recordset is a local temp table. What happens is that when a user dblclicks on a record in A it gets added to B. When this happens I want the record in A to have its color changed...

So I have a couple of combo boxes in my form, that when they change they need to invalidate data. So when they they change, before they do change they need to ask the user if they are sure they want to change the combo boxes. My problem is that I can't get the combo_box.undo to work, and when...

hey... so I have a form with two subforms on it. in one sub form (A) I have a listing of records, what I want to have happen is that when the user dblClicks on one of the records in A, that record is add to the other subForm (B). Right now it just adds all the records from A to B, and I can't...

I have a table with lots of recurring dates in it.. i.e. 8/23/03 8/24/03 8/23/03 8/25/03 8/23/03 8/25/03... etc. I would like to return from a select statement only one date each. Date ---- 8/23/03 8/24/03 8/25/03 instead right now I get all the dates... is there a way to filter out dates...