Search results

  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

    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
  4. 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.
  5. 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?
  6. 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?
  7. 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...
  8. A

    writing queries to retrive data in particular combinatio

    I am a little new to writing queries. Could someone please tell me how should I write a query so as to display the data. The participant ID should be input by the user and then I want to lookup the records based on this participant ID. Second this I want to do is, I want the user to enter the...
  9. A

    Problem with Combo Box

    I have a combo box which looks up for its rows from a table. The entry in the table is integers with explicitly defined decimal places (0 in this case) However when the combo box shows up on the form it shows values with two decimals. I tried changing the properties to fixed and zero decimal...
  10. A

    How tp Compact a Database

    I am new to Databasing and I had embedded somepictures in the tables which made the database over 600 Megs. I then changed the embedding option and then just linked those images. Still the database is 600 Megs eventhough it doesnt contain the images now. Is there any way to bring it down...
  11. A

    Printing a Form

    What is the best way to print a form? I want it to print exactly the way it is displayed on the computer. Is there any way in which I can do it? Please help !
  12. A

    how to open windows 'file-open' dialog

    I have a form which holds the pictures of participants. The pictures are linked and not embedded so as to keep the database size controlable. Is there any way where I can make a button which when clicked will open a windows default file open dialog and let the user select the file (image file)...
  13. A

    Problem with Combo Box

    I have a form in which I have a combo box. This combo box looksup for its values from a table and then depending on this table it searches for the respective entries in the table. The values in the tables are plain numbers without any decimals. Also in the form, the decimal places of the combo...
  14. A

    VBA in Ms Access

    How can I make a button in a Form which when clicked opens a windows exlorer so as to select OLE objects (mainly jpg) and embed them in the required place
  15. A

    Using VBA with Forms

    I have a form in which I have some OLE objects which are mainly .jpgs I want to put a buton in the form which when clicked will open the windows explorer style box which will allow the selection of files. The selection will then result in embedding the object in the form. Could you please tell...
  16. A

    Using browser commands in VBA

    I have a form in which I need to put OLE objects mainly .jpgs I want to create a button which when clicked will open an browser window so that the necessary file can be selected then clicking ok will embed the object in the form how can I do this please help
Back
Top Bottom