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 derfloh 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. Malaviya

    Extracting pictures from Access 2000 table

    I have a huge database of photographs with related info. in a table. Now it is expected to grow beyond 1 GB. I'm not able to extract the photograps from the table into normal picture files so that the database size can be reduced. Can anybody help ? If sombody has written code in VB / Access to...
  2. Malaviya

    Embedded OLE Objects - How do I Export them as a File

    I have a large ACCESS-97 database table of scanned photograps ( as OLE Field) and their names. All the photograps are embedded in the database field, resulting in a very slow response time. Now I want all these photograps back as disk files to store them as linked files. Can any one help ...
  3. Malaviya

    passing values using SQL INSERT statement in VB

    Try following: pstrSQL = "INSERT INTO tblRecipes(fldName, fldFoodType, fldCookIn, fldTime, fldIngredients, fldInstructions) " & _ "VALUES("'" & txtName.Text & "', '" & cboFoodType.Text & "', '" & cboCookIn.Text & "', '" &...
  4. Malaviya

    Selecting ALL persons in my combobox for query criteria

    Hi A new Idea came to my mind. Since U'r facing problems with Null in Paul's case, instead of using IsNull try using NZ function. NZ is a function using which U can assign a default value to your expression in case it evaluates to null. I hope this will solve the problem. best of luck.
  5. Malaviya

    Load all txt files in a folder into adatabase

    Hi U can use the Scripting object in VB to do the file handling as well as opening them to read line by line. The Scripting object supports all types of file handling methods. U can go through the documentation about the Scripting object in MSDN and find out a solution to your self.
  6. Malaviya

    Selecting ALL persons in my combobox for query criteria

    You can do the following 1. Cange the combobox property - Limit to listed vales = False 2. in the query criterian use the 'Like' operator. 3. Type '*' in the combo box to print the report for all employees. U can even use a wield card combination to select a group of employees also.
  7. Malaviya

    Linking Tables from a Database on CD-ROM - It is not happening, HELP!!

    I had created an encrypted database in Access-97. This database has a utility in it to import data from large text files of ~ 60 MB in the database. Initially database is not populated. The constraint is that large text files and CD-WRITER is on a standalone machine. On this machine Access-2000...

Part and Inventory Search

Back
Top