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

  1. LLudden

    Search using Regular Expression

    How are the numbers stored, and in what format? If these numbers are in a database, stored as type Float (or Single/Double), then you can use a SQL statement such as: Select * From Table Where Number is between 1234.02 and 1234.22 Doing this with regular expressions is much harder, as you...
  2. LLudden

    Problem with SQL 7.0 adding Trigger

    I have tried adding this script both from QA and from EM. Both went off into nevernever land, and after 14hrs we rebooted the server to speed things up, so it was doing something. There has been no tech people working on this system for a long time. The databases and tables were all created...
  3. LLudden

    Problem with SQL 7.0 adding Trigger

    CREATE TRIGGER [MakeorDeleteStops] ON [dbo].[Transport] FOR UPDATE AS Declare @Ticket int, @Transport int if ( UPDATE([Vehicle ID]) ) begin Select @Ticket = (Select [Ticket No] From Inserted) Select @Transport = (Select [Vehicle ID] from Inserted) if ( @Transport > 0 ) begin exec...
  4. LLudden

    Problem with SQL 7.0 adding Trigger

    I am doing some work at a new customer who is running SQL 7 (unsure of Service pack #). I need to add an update trigger to one of the tables which contains about 70K records. There are currently no triggers defined on that (or any) tables in the database. When I enter the T-SQL for the...
  5. LLudden

    SQL Trigger Question

    I have a table of city names that are referenced in another table by the primary key: Table CityList, CityCode as int, City as nvarchar(25) Other tables that use the CityCode to reference the city name, so to get an address for a customer record, I have to query the customer table for the city...
  6. LLudden

    Capture Print Image to a JPG file

    Easiest way to do what you want is to use Adobe Acrobat and create all the data as .pdf files. Otherwise, you have 3 choices: 1. Alter the generating software so it creates an image file 2. Parse the output file and convert to graphic 3. Write your own printer driver that basically does what...
  7. LLudden

    Dim a variable so it's available to the whole Class

    If you add a public variable to the class declarations, its visible to everyone. Make it private and it will be visible to all functions within the class.
  8. LLudden

    Changing a Table via T-SQL

    I have a software package I am doing a major update to. The original was written as an Access 2000 front end, and I am changing it that to VB6. The backend data is in SQL server 7.0 What I want to do is write T-SQL to transfer all of the existing data to a new database in SQL, and then...
  9. LLudden

    Warning when sending email through vba, OL2000

    If you are using exchange server, you can create a security profile that allows the sending of messages with VBA unprompted.
  10. LLudden

    Recursive Database Design Question

    The goal of the database is to be able to choose a manufactured item, and list all the components needed to make it. Some of the components themselves are manufactured from lesser components. There can be many sub components in any given piece. Using an automobile for an example: Car...
  11. LLudden

    general database problem

    Can you post the code you have on the Click event for the button?
  12. LLudden

    Record Accessing problem?

    Its usually better when processing text files sequentially to stick to a single line for reading the file, then have your loop code determine how to handle that line. For example: Do While Not EOF(varFileNumber) Line Input #varFileNumber, varLineString If...
  13. LLudden

    Two problems in one! Filter and <>.

    To use a wildcard in a WHERE clause, use: WHERE [Fieldname] LIKE 'Bob*' To use dates, surround the date with # #6/26/02#
  14. LLudden

    Access update too fast

    This thread probably has the answer: thread222-298724
  15. LLudden

    Help with Indexing

    If you have many changes occuring to your database, then having too many indexes actually can slow it down (indexes have to be updated with each record modification). If you are mostly looking at existing data, then having each record that is searched on indexed can speed things considerably...
  16. LLudden

    Finding Journal Entries by Date

    From what I see, there is no better way of doing it, since Outlook isn't based on a client/server model. If you have several such queries to run in a given session, and many journal entries to search, it may be faster to copy them all into a temp table then run queries on that table.
  17. LLudden

    Setup screen for Access DB path

    Use the common dialog controls to let the user browse for the database location, then once you have it, call this function with the path: Function ChangeData(strPath) On Error Resume Next Dim db As DAO.Database Dim rs As DAO.Recordset Dim tdf As TableDef Dim strName As String...
  18. LLudden

    Two problems in one! Filter and <>.

    Instead of using the Filter option, just change the source for the combo box and include the filter as a WHERE clause. so if the select for the box is: SELECT Name from tblNames have your code change it to: SELECT Name from tblNames WHERE [Number of Kids] = 2 then do combobox.requery
  19. LLudden

    Data Type problem

    You might want to use the ControlType property instead.
  20. LLudden

    How to use Access on LAN

    The users will need sufficient file level access on the MDB file to read and write to it. One of the reasons SQL is a better system is that because users have access to the data from all programs (even shell), they can do "other" things to it (delete).

Part and Inventory Search

Back
Top