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 Chriss Miller 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: *

  1. Slugmaster

    How to delete data that is duplicated in two different tables?

    Brendan, I did as you suggested, on a demo database and your SQL suggestion. The result is another error: The specified field <field> could refer to more than one table listed in the FROM clause of your SQL statement. (Error 3079) So I tried the following: DELETE fvmCalResults.* FROM...
  2. Slugmaster

    How to delete data that is duplicated in two different tables?

    I have two tables of the same structure in an Access DataBase. One table is linked from an ODBC source and the other is an Access table. I want to delete the data in the Access table that contains duplicate information from the ODBC table. The tables are joined by the primary key. When I try...
  3. Slugmaster

    Database synchroniztion between field and server?

    How can I synchronize my field laptops with my server machine on a periodic basis? My field laptops Retrieve/Modify/Add information to their local database. When that laptop gets back, I want to update the central server, then update the local laptop again. The central server is only used to...
  4. Slugmaster

    Creating an SQL statement that outputs data to a text file.

    Also, his notes have a reference to Sysbase SQL Anwhere 5.0, ISQL.
  5. Slugmaster

    Setting Objects to Nothing Problem

    The original should be automatically discarded (set to nothing) when you create the second object. This happens &quot;behind the scenes&quot; and you should not have to explicitly do it. One good reason to do it explicitly is that you know exactly when (in your flow of code) the object is...
  6. Slugmaster

    adding variable through multiple forms!

    I would make a public BAS module that contained the Public variables that are common to multiple forms. Then anywhere in your code, you can refer to those variables. More complexly, you could have a Public variable in each form that you could set before you show that form, for example...
  7. Slugmaster

    Help choosing please

    Very broad question. There is no right answer. It all depends on what kind of applications you want to develope. I have written in Assembly, C, C++, Visual Basic, Quick Basic, VB Script, and a few more. Each one has or had its place. I found Visual Basic to be the simplest GUI based...
  8. Slugmaster

    Creating an SQL statement that outputs data to a text file.

    I am not sure what is being asked, but here is some more information. I am using Sysbase SQL. In VB, I am using DAO 3.6 object library and connecting with ODBC.
  9. Slugmaster

    Creating an SQL statement that outputs data to a text file.

    I am trying to write an SQL query that selects specific records from an ODBC database and outputs them to a text file in a specified format. A co-worker of mine recently attended a workshop which gave us the idea. Unfortunately, he is not an SQL person and has no idea of how it is soppose to...
  10. Slugmaster

    Shrinking Images

    There are two common image viewing controls in VB, Picture Box, and Image Control. If you use the Picture Box, then you need to fit the image before you load it into the control. If you use the Image Control, then all you need to do is set the property Stretch = True. Its been a couple of...
  11. Slugmaster

    Which API to use ???

    I too would like to know this. I posted a similar question last week, but I still do not have any responses. If you find something, I would like to know.
  12. Slugmaster

    Access 97 Select Query using Date in Where clause not working.

    That did not seem to work, if you don't mind, can I send you an email with a sample database?
  13. Slugmaster

    How do I connect in VB with ODBC w/o having Sysbase client running?

    I am using a VB6 application to connect to a Sysbase SQL database. The problem I have is that I first need to launch the Sysbase DBClient.exe application in order for my VB code to connect. I desire to connect completely by code, without having any user interaction. I tried to use the VB...
  14. Slugmaster

    Access 97 Select Query using Date in Where clause not working.

    I have a very simple query based from a very simple table that I cannot get to work. Table1: Field1: TAG, Text Field2: TimeModified, Date Query1: SQL: SELECT Table1.TAG, Table1.TimeModified FROM Table1 WHERE (((Table1.TimeModified)=#4/12/2001 10:39:35#)); The output of the Query is nothing...
  15. Slugmaster

    Hi ! I am again needed of help. M

    This may help a little. I found a reference to that file extention. .rtp Rtpatch software update package data file Here is a WebSite for that company: http://www.pocketsoft.com/products.html
  16. Slugmaster

    How do I connect in VB with ODBC w/o having Sysbase client running?

    I am using a VB6 application to connect to a Sysbase SQL database. The problem I have is that I first need to launch the Sysbase DBClient.exe application in order for my VB code to connect. I desire to connect completely by code, without having any user interaction. I tried to use the VB...
  17. Slugmaster

    Remote replicate problem with netwoked linked tables.

    It seems that I need to remove the links to each other, replicate both databases, and write my code to juggle access to both databases. I don't see too many drawbacks other than writing a bunch of code to handle it. JerryDennison stated that replicating both db's is not a good idea, what are...
  18. Slugmaster

    Remote replicate problem with netwoked linked tables.

    I have an Access database(DB1) that contains a couple of tables linked to another Access database(DB2). Both databases are on a network drive (ie: \\Computer1\folder\db1.mdb, \\Computer1\folder\db2.mdb). I then used the Access replicate feature on DB1 so that my technicians can use the...

Part and Inventory Search

Back
Top