User Profile

Collapse

Profile Sidebar

Collapse
manojspromantr
manojspromantr
Last Activity: Apr 28 '09, 11:05 AM
Joined: Feb 9 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • manojspromantr
    replied to Problem with Appending Tables
    in Access
    I am not able to do this... Is there any other option to do this..


    Thanks
    Manoj Kumar
    See more | Go to post

      Leave a comment:

    • manojspromantr
      started a topic Problem with Appending Tables
      in Access

      Problem with Appending Tables

      I'm trying to append some data from one table to another table both the table structure are same. I have an attachments field in both tables but it seems that i cannot append the attachments from one table to the other.

      I get the following error when trying to just append the attachments field to the appropriate field:

      "An INSERT INTO query cannot contain a multi-valued field"
      I also get the following...
      See more | Go to post
      • manojspromantr
        replied to Problem with Open Dialog Box
        in Access
        Thanks for your reply.

        This works if i specify the file name. Is there a way to import any excel file with any name.

        Now i need to give a specific file name. What if i change the file name & fiels are same as per the Table. do i need to go each & every time & change the file name in the codes.


        Thanks
        Manoj Kumar
        See more | Go to post

          Leave a comment:

        • manojspromantr
          started a topic Problem with Open Dialog Box
          in Access

          Problem with Open Dialog Box

          Hi Friends

          I am trying to design a form where i need to browse a excel file using a open dialog box & append the same in a Table at the database.Any how i have taken care that the Table fields are in same order as the Excel file does.

          Please have a look at the below codes which i used to open a "Open Dialog Box" which is working fine.

          Now i want that when ever i select the File & click...
          See more | Go to post
          Last edited by NeoPa; Feb 12 '09, 02:13 PM. Reason: Please use the [CODE] tags provided
          No activity results to display
          Show More
          Working...