INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access 2010 Ctrl + apostrophe shortcut help

Access 2010 Ctrl + apostrophe shortcut help

(OP)
Good day and Happy Holidays!

I know about using the Ctrl + ' shortcut to copy from the field above.

So I am trying to use this shortcut in a field with an attachment data type to save me the trouble of attaching each letter separately when the same letter applies to several rows. The .pdf attachment in Row 1 opens great. But if I Ctrl + ' (or Ctrl + Shift + ') in the next row, I'm unable to open the .pdf attachment. I get an error message: Acrobat could not Open 'January 14, 2011.pdf' because it is either not a supported file type or because the file has been damaged....."

Is there a keyboard shortcut that will allow for the .pdf file to be copied from row to row without having to go through the attachment process each time? There are thousands of rows....

Thanks in advance for any help,
BH

Best,
Blue Horizon 2thumbsup

RE: Access 2010 Ctrl + apostrophe shortcut help

Are there thousands of rows that get the same attachment? If that is the case that does not seem normalized. I would save the attachment once in a record in another table and link to that record. If each gets a unique version of the same record, could load the attachment through code? Even if only a button click, I sure would rather load them all by code.

RE: Access 2010 Ctrl + apostrophe shortcut help

(OP)
Thank you MajP. Dozens of records get the same attachment - they don't all get the same one. So every 30-40 records have the same attached letter, then it changes for another 30-40 records. I'm afraid I'm code-ignorant and wouldn't know what to write or where to put it. I was hoping there was a different keyboard workaround.

I may be out of luck...

Best,
Blue Horizon 2thumbsup

RE: Access 2010 Ctrl + apostrophe shortcut help

I have not played with copying the attachments with short cut keys, so I cannot answer. You still may consider normalize this, by putting your attachment into a table once. Then every record would link to the correct field in the attachment table. Although attachments are efficient, it is still going to take much more memory saving 1000s of attachments instead of 10s/100s. Then instead of copying you would just save the attachment ID for each record.

RE: Access 2010 Ctrl + apostrophe shortcut help

(OP)
Is there then a way to view the document that is saved in the Attachments table on the table that it is linked to?

Best,
Blue Horizon 2thumbsup

RE: Access 2010 Ctrl + apostrophe shortcut help

Yes, but only through a sub datasheet. Normally we use forms for entering and viewing data. So if I had a continous form then I would have a button or a means to add an attachment to my attachment's table. Then in my mainform I would have a combobox to allow me to select an attachment ID. My mainform query would also be joined to the attachment table so that if I select an attachment ID you would have the attachment on the main form.

RE: Access 2010 Ctrl + apostrophe shortcut help

(OP)
Thank you - from your suggestions, the lights went on. What will work is a form/subform to both tables.

Happy Holidays!

Best,
Blue Horizon 2thumbsup

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close