Recent content by ThomMenzies

Zen - worked a treat, you've saved me a headache! Many thanks!

Hi All I've created a dts on SQL Server 2000 that pulls data from Oracle. I have 4 different connections to 4 different Oracle servers via 'Microsoft OLE DB Provider For Oracle'. The transformation tasks run one after the other, upon successful completion. Testing the connections works fine...

I have located the problem! I'll post what it was in case someone with the same issue finds this on a search one day! The problem was with the pre-compile of the nested proc. My bit parameter sql read a bit like this: If @ReturnResultSet=1 Select * From Table1 but during the precompile it...

I have a Proc, let's call it 'spB'. Within that proc I have a nested Proc ('spA') which goes off and inserts some records into a few tables then based on a Bit parameter decides whether to return a recordset. Now when I execute spA from spB I pass 'False' as the paramter for spA so it will not...

You need to use the IIF statement: IIF(Expression,TruePart,FalsePart) Thus, in your Crystal example: IIF({Include Canceled Orders?}="No",1,0)

I'm new to SQL Server and am not sure whether it is possible to link to an Oracle table using SQL Server. I previously used Microsoft Access through which it is dead easy to link to Oracle. I have found out how to import data via SQL Server, but not linking. Can anyone help? Thom

I am having trouble changing a field in a table from text to long integer. So far I have: dim DB As Database Dim tdf As TableDef Dim fld As Field Set DB = CurrentDb() Set tdf = DB.TableDefs("tbl_VisitData") Set fld = tdf.Fields("Org ID") I can't find a way to update...

That doesn't seem to work. The only way I can get it to work at the moment is by using the send keys function. ie: listbox.SetFocus SendKeys "{DOWN}" Which is a bit messy, but its all I've got at the moment! Thanks for your input, Thom

Simple or not I am having a problem with listboxes. All I want to do is have the first (or indeed any) row highlighted when the form containing the listbox is opened. Can anyone help? Thanks, Thom

In one piece of code I have output a text file to the root of the C:\ drive. Later on I want to knowwhether that txt file is there. Apart from opening it is there a way I can test to see if it is there? Any help, greatly appreciated, Thom.

Mr. Ms. Mrs. Dr. would be title or personal title whereas Sr. is a suffix

2 queries really. I have the following simple code to produce a table in code with a unique primary key: Set tdf = DB.CreateTableDef(strTempSR) Set fld = tdf.CreateField("ID", dbInteger, 3) tdf.Fields.Append fld DB.Execute "CREATE UNIQUE INDEX PrimaryKey ON " & strTempSR &...

Everytime I click on a hyperlink on a form the web toolbar appears. I have turnedall menus, toolbars etc off on the start up of the database but it does not help. Any ideas?

Certainly have! You can see the cursor flick into the txtbox then settle on the button. Thom

I have used the following code in the OnKeyDown event of a txtbox to run a command held on the click event of a button (the outcome of which sets the focus to the txtbox): If KeyCode = 13 Then cmdLogIn_Click The code works fine when the button itself is pressed (the txtbox aquires the focus)...