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!

Recent content by smada80

  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

    Excellent, thank you all.
  5. smada80

    Stopping access to design view

    Thankyou both for your help. Ann, I have studied the help file on AllowBypassKey property and must admit I am struggling to follow it!! Do you have an example? Thanks Matt
  6. 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...
  7. smada80

    Running queries with parameters from VBA

    Thanks to both of you. After I did both suggestions it worked fine. Much appreciated.
  8. smada80

    Running queries with parameters from VBA

    Thanks for that. I tried this first but for some reason it never returns any data, even if I use the same SQL as in the query. I thought this might be due to the way I am putting dates into the SQL string. The query is something like: &quot;SELECT period_name FROM tblPeriod WHERE...
  9. 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 =...
See more

Part and Inventory Search

Back
Top