Recent content by adwaitjoshi

  1. A

    Absolute Path in Tables

    I want to store some pictures in my database but since the database will bloat once I start storing the pictures I figured out that I can store a path like "C:\abc.jpg" in the table as a string. Then when the form loads the code looks up for this and displays the picture. Now my problem is that...
  2. A

    Insert Into Problem

    I have a Insert Into Query which looks up its value in a table so it will look something like INSERT INTO Orders VALUES (3,(SELECT Product_ID FROM Product_Range WHERE [Name of The Product] = 'Bhujia'),0,1,0,0,0) But since the values need actual values and not queries how can I do this?
  3. A

    Exporting data to Excel

    Can I transfer the recordset object using the Transfer Spreadsheet command.I am only aware of Transfer Spreadsheet command transfering tables.
  4. A

    Exporting data to Excel

    I am generating a query on the fly.Then I use the recordSet object to get the "SELECT" query results. I want to export these results from VBA to Excel.Could someone please tell me how to do this. Thank you
  5. A

    Query on the Fly

    Thanks a lot it worked great !
  6. A

    Query on the Fly

    I have Access 2002 but still Dim db ad DAO.Database doesnt work you will need to check the Microsoft DAO 3.6 Object Library in References Where are these references? Where do I have to check this? Please help. Thanks.
  7. A

    Query on the Fly

    When i say Dim QD As QueryDef nothing happens QueryDef is not listed as an option there. Thats a part of DAO i know so is there anything extra that I need to use DAO ?? I cannot use Dim db As DAO.Database either. Please help
  8. A

    Query on the Fly

    I am generating a query on the fly depending upon the values of combo boxes on a specific form. When the user clicks "Fetch" button, the constructed select query should fetch the data from a table. Could someone please tell me how can I do this? I am new to MS Access. Thanks.
  9. A

    Excel Control in MS Access

    Can some one please tell me how can I use a Excel Control on a form through VBA ? I run a query and this query returns some results. Now the returned results are to be shown in a excel control object. Could some one tell me how to do this please?
  10. A

    Excel Control Through VBA

    Can some one please tell me how can I use a Excel Control on a form through VBA ? I run a query and this query returns some results. Now the returned results are to be shown in a excel control object. Could some one tell me how to do this please?
  11. A

    working with images on a form

    I think the way OLE Objects work is that they take only Bitmaps (this is what I read) they do not handle JPG's when you are trying to embed something there. i.e. your image is converted into a BMP and put there. One of the other problems is that it bloats the size of the database considerably...
  12. A

    Form does not open - instead displays Lookup message

    I think what is happening is that since you changed the property of the table/query its not having the reference to the fields in that table. What you might want to try is when it gives the error and asks you to select the table please type in the name of the table and corresponding field or if...
  13. A

    Writing a Sub Query help !!

    Thanx a lot This thing really worked :) and I will try not to use spaces inmy next assignment. As I am new to databasing I did not know this.
  14. A

    Writing a Sub Query help !!

    I want to write a query which will extract data from two tables. The tables has 5 fields in all and I have to pull out the data in a specific combination of the variables I know that I need to write a sub query I tried writing one by reading some help but it gives errors here is the query can...
  15. A

    Problem with Combo Box

    Ok got it working thanx a lot for your help guys I really am grateful to all of you :)
See more
Back
Top Bottom