Search results for query: *

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

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

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.

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?

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

On the On_Open event of a form I want to know if a certain table exists in the Database...Any ideas? Thom.

I have created a Q&A Search Form in Access 97 (its a lot like the Windows Explorer Search screen). It was built to sit on the users PC and delete and append into temporary tables. Now it is required to sit on an NT server and be accessed by many different users. In effect it has to become multi...

Any ideas how to make the list of a combo box non-editable, i.e. only allow people to select the data from the list and not type it in (as with VB6 for example)? Thanks, Thom.