Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rahel
  • Content: Threads
  • Order by date
  1. Rahel

    runtime error '3708' Parameter object was inproperly defined.

    I am trying to pass a simple parameter to a stored procedure from vb6 and recieve the above error. heres the vb bit: Private Sub Command1_Click() Dim cnn As Connection Dim rst As Recordset Dim Command1 As Command ' Instantiate the object variables Set cnn = New Connection...
  2. Rahel

    Is there a fix for the SendObject method in Access2000

    Does anyone know of a fix for this----can't use this method in Access2000
  3. Rahel

    Does anyone know how to write to a text file using transact sql

    I need to add a header and footer to a text file. I have the header and footer done using transact but, I don't how to attach the header and footer to the text file (csv). Is it possible using transact? what i want to be able to do is open the text file using transact sql and to paste the...
  4. Rahel

    Problem inserting records with apostrophies

    I have an import routine in Access2000 that keeps failing when it encounters records that contain apostrophies in it. When I get rid of the apostrophies, the import routine works. (I am working with text fields.) Has anyone come across this problem or knows about a fix for this to allow for...
  5. Rahel

    How to count the no of commas in a field

    If I had a table for example called Authors which has a field called Topics <Art,Science,Astronomy,Geology> How can I count all the commas and remember their positions? I want to extract individual topics and then append them to another table. I dont know how to look for commas in a string...
  6. Rahel

    ODBC problem with SQL Server 7.0 to FileMakerPro 5

    I have FileMakerPro 5 databases on Apple Macintosh computers which I would like to import data from. I created an ODBC connection to do this successfully. I can use Microsoft Access and import the data successfully however, when I use the same data source with SQL Server 7.0 it doesn't work...
  7. Rahel

    Does anyone have a copy of FoxPro for the Macintosh

    Or knows where to get hold of a copy. It has discontinued on the Apple platform.
  8. Rahel

    Exporting the result of a view to a table in the same database

    I need to extract the results of a view to a table in the same database. The table has exactly the same column structure as the view. I tried to create a DTS package to do this but, you can not see views when creating a DTS package(only tables are visible). can someone help?
  9. Rahel

    Importing a csv file to a sql server table

    I need to import a csv file to a table that already exists on SQL Server7.0 on a regular basis.<br><br>I have tried using the import wizard but had no luck. How do I specify the table on SQL Server that will store the data held in the csv file?<br><br>I tried reading the csv file from Excel and...
  10. Rahel

    How to you specify wild cards as a criteria for a view?

    I have reference field that I need to filter some records based on two different criterias. <br><br>For example, if I wanted to filter for reference numbers that end with 'zzz', how do I specify the criteria ('*zzz' as the criteria does not work)?<br><br>For example, if I wanted to filter for...
  11. Rahel

    Problem performing divide calculations in a view?

    I am having problem trying to do calculations in a view.<br>I am trying to divide the values in one column by a value in another column. <br><br>I have no problem adding, subtracting or multiplying columns and receiving the correct result however, when trying to perform a divide calculation I...
  12. Rahel

    Problem editing or updating database from client machine

    I have a problem enabling a client to write, edit and make updates to a database. The client has full permissions to edit and update the database. When trying to edit a record a message comes up saying this recordset is not updateable.<br><br>The client is able to access and view the relevant...
  13. Rahel

    Can not update/add or edit records on database

    I have a client with relevant permissions to access a database based on NT security. Every possible permission has been granted to the client (NT Login Account)for the database and database objects. <br><br>My client can login and see tables and views, however cannot update or edit any records...
  14. Rahel

    Error 1130: Problem starting the Server service

    I have a fresh copy of NT4 Server installed on Pentium III 450MHz machine,with 128MB RAM, 2048GB NTFS partition and service pack 3,4 installed. The graphics card (ATI) and NIC card were successfully recognised. I can see the network successfully, however, I can not get the new NT Server machine...
  15. Rahel

    Problem starting the Server service

    I have a fresh copy of NT4 Server installed on Pentium III 450MHz machine,with 128MB RAM, 2048GB NTFS partition and service pack 3,4 installed. The graphics card (ATI) and NIC card were successfully recognised. I can see the network successfully, however, I can not get the new NT Server machine...
  16. Rahel

    Any Omnis Studio developers creating front-ends to SQL Server 7.0

    I am having great difficulty in creating a form to read and write to our backend database on SQL Server 7.0. My front-end tool is Omnis Studio which offers cross-platform enterprise solution capabilities. When creating forms using Omnis data files, I don't have a problem.<br><br>However, when...
  17. Rahel

    Can see network but can not copy from network reliably

    We have a Dell Power Edge 4400 server. Windows NT Server installed successfully. The system reports no faults and appears to work beautifully. <br> <br> However, when you connect it to the network we have a little problem. The new server can see the network, we can copy files from the server to...
  18. Rahel

    Problem linking to SQL Server 7.0 from third party application?

    I am having problems linking to SQL Server 7.0 from a third party application. The error message tells me that the data source name was not found and that no default driver has been specified.<br> <br> I have noticed that there is a odbc.ini in the Winnt directory. Is this where you are suppose...
  19. Rahel

    How do u use a combo box as the criteria value in a query?

    How do u specify the criteria value in a query to be read from a combo list on a form. I want to use the value in a combo box on a form to limit the results of a query.<br> <br> If possible, an example of how to write the expression in a FoxPro query would be helpful.<br> <br> For example in...
  20. Rahel

    Can u create a combo box in the detail section of a master\detail form

    I'm trying to re-write an Access database in FoxPro. My last obsticle is to be able to create a combo list within the grid. I have a master\detail form in Access that has combo lists in the detail part of the form. I have been looking for a way to be able to create combo lists in the detail part...

Part and Inventory Search

Back
Top