Trying a simple function in Access

[eholtman]

and not able to get it to work. Attached is the form I want to give the group a easy way to paste circuit IDs from Excel into a subform that will tie to the ticket as listed above.

I have the releationship of ticket number assigned to the above ticket.

Problem.... When i paste the numbers in the field it limits it only 2 records or what is currently being viewed. I am sure there is a sample somewhere if any could help me find a input form that would be appreciated. I have searched an no luck..

 

[ghudson]

The user can only paste one subrecord at a time in the subform. They have to paste the new record into the new record line which has the astericks in the record selector [bottom blank record].

 

[eholtman]

Than if subform is not the best option what would you suggest. Because Simply put for 1 ticket there can be 150 records. I than have releationship that equal the Circuit ID gives me the address and additional information.

The data comes from a email. I thought the easiest way is to copy into Excel than to access.

Thanks for your direction.

 

[ghudson]

There is nothing wrong with your relationship with the form and subform. You just need to automate the process of extracting the data from the email and directly into Access. The data should arrive in a file that is formatted so that Access can import the data into your table. The process and formatting of the data will determine how easy or hard the task will be.

 

[eholtman]

thanks

Thanks I have been looking to export the outlook but it doesnt accept the body.. where all the data is..

So I will search for TransferSpreadsheet and see if this works

Thanks and happy holiday.