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 SkipVought 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: young
  • Order by date
  1. young

    Listbox help

    Download 101 samples of VB.NET from microsoft.com.
  2. young

    can i run vb.net applications in win 98?

    No! I try it before.
  3. young

    Book Rec

    http://www.wrox.com/books/0764543830.shtml You will learn a lot VBA from this book
  4. young

    SQL select from....using variable question

    SQL String should be: "select * from tblStock WHERE [fkManufacturer ID]= '" & manufactName & "'"
  5. young

    INSERT INTO problem: Syntax for multiple fields??

    use Access append query to create a query and then open view, SQL to see the SQL statement
  6. young

    Where have my forms gone?

    try use Ctrl+G to open code windows and Debug --> compile, you will call error message and to fix them.
  7. young

    Where have my forms gone?

    Check your size of MDB file. Or, try run compact and fix.
  8. young

    2 tables, how do I find records unique to 1

    use "find unmatched query wizard". Do it twice and change table each time.
  9. young

    100000 records in txt file, need fast way to upload to database

    In Access, I use: DoCmd.TransferText acImportDelim, "My Import Specification", "my_destination_table", "textfile.txt", False, ""
  10. young

    Output a query to a text file

    try it: DoCmd.OutputTo acQuery, "my query name", "MS-DOSText(*.txt)", "my text file name", False, ""
  11. young

    Accessing SQL 2000 Stored Procedures from Access 2k

    Book "Access cookbook" page 647 teach you this topic. ISBN:0596000847
  12. young

    Connect to SQL Server 2000 during Form Load

    The book "Access cookbook" by Ken Getz in chapter 14 tell you everything.
  13. young

    Run an SQL server Stored Procedure from an Access Form

    I reseach this topic for many year now I got the right answer from the book "Access cookbook" by Ken Getz.
  14. young

    Auto login to SQL

    Book "Access Cookbook" ISBN#:0596000847, page 633 tell you everything you need.
  15. young

    Print ACCESS reports thru MS Word

    Yes, you can. From report preview, export, select rtf format.
  16. young

    Why "Not Enough Space on temporary disk"?

    check size of mdb file. The max size for Access 97 only 1G, for Access 2000 only 2G
  17. young

    inserting data automatically into a form based on other data

    You can use SQL select statement to select the record which match "spec Number" (=me.MBR_ID)and use recordset to auto fill the rest control in the form. Bellow is partial code. strSQL = "select * from [dbo_MEMBER] where [MBR_ID] = '" & Me.MBR_ID & "'" Set...
  18. young

    Next line in message box

    vbNewline also works well.
  19. young

    How can I stop the Yes/No/Cancel Buttons when saving an Excel Doc in A

    If you use code, add it: doCmd.setworning false.
  20. young

    Looking for the lowest value in fields from a table row

    You did not do the same project but I think that you need multiple loop and compare function to compare one by one.

Part and Inventory Search

Back
Top