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

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

    Transcations and DTS Packages

    Hi all I am using MS SQL Server DTS packages called from VB6 code to perform imports of data from text files. The problem I am having is that there are several packaages to perform the imports run one after another, but if one fails I need to whole thing to roll back. I have placed the calls...
  2. smada80

    File Browser in VB

    Hi all I looking for the code to display a standard windows folder browser in VB6, i.e. a tree structure where you can choose a directory to save into. Would appreciate any help you could give! Thanks Matt
  3. smada80

    Querying Dates in Query view

    Hi all I have an access query that looks at a field called Date_Notice_Given and should return all records between a given date range. It picks up the dates from a form. I have added the Date_notice_Given field to the query and typed the following in the criteria: Between <<fieldname>> And...
  4. smada80

    Stopping access to design view

    Hi all I wish to stop access to the design view of all queries so that a user cannot see the SQL logic involved. I am aware that you can stop users viewing designs by restricting access to menus, but holding the shift key bypasses this so its not suitable. Also, I know that you can use the...
  5. smada80

    Running queries with parameters from VBA

    Hi all I am trying to run a query that has a parameter from VBA. I have a query that takes a date from a form as its parameter. When a field is updated, I want the query excecuted and to use the data from the recordset. The code I am using is: rsMyRs =...

Part and Inventory Search

Back
Top