Stack Overflow
Stack Overflow

Questions tagged [attachment-field]

Microsoft Office Access 2007 has attachment field type that supports attaching files and graphics to the records in your database.

14 questions
3
votes
1 answer

Handling fields of Attachment type in MS Access using ADO

I have some fields in my database that will need to store images ( bitmap, JPG or PNG ) and PDF ( or Excel/RTF/TXT ) files. Browsing through Internet, I have learned that MS Access 2007 ( and newer versions ) have a field of type Attachment that can…
AlwaysLearningNewStuff
  • 2,939
  • 3
  • 31
  • 84
2
votes
1 answer

Assign Attachment Field To Variable in Access 2010

I'm trying to understand how to work with the new Attachment field that is available in Access 2010. I would like to assign the value from the table directly into a variable. I know that I can do this if I use an intermediary form, but this seems…
Madison Knight
  • 364
  • 3
  • 18
2
votes
1 answer

Using Attachment field with Classic ASP

I am trying to use attachment datatype in Microsoft access and classical asp to access the database. I am trying to insert attachement from a classical asp form. I got an error "Cannot insert multiple values". I tried a lot online but i cannot find…
Satya Vamsi
  • 217
  • 3
  • 6
  • 13
1
vote
1 answer

How can I hide an attachment (image) object on a report if there are zero attachments?

I am building a report for an MS Access database. The report contains a subform that lists information about items, including an attachment field that holds images. If there is no attachment, the row space is still used by the object, resulting…
jsatwm
  • 11
  • 1
1
vote
1 answer

VBA Attachment: Item Not found in Collection

All, I'm trying to save a record for 1 record to a drive. I've spent about a day searching for a solution so this is a last ditch effort for some help. I am not a developer by any stretch of the imagination so please, go easy. Code is below. Table…
jmcginley
  • 13
  • 2
1
vote
0 answers

clone a recordset which has some attachments

I wanted to copy a recordset to an another. I found this code: Do While Not rs(1).EOF ' You can place if condition here rs(2).AddNew For i = 0 To rs(1).Fields.Count - 1 rs(2).Fields(rs(1).Fields(i).name) = rs(1).Fields(i).Value …
killo watt
  • 11
  • 2
1
vote
1 answer

Referring to the filename of an attached file in Access 2013 with VBA

If I have Files in Attachments fields, how can I get a filename as a string using VBA? They're excel files so I want to do something like this: xlApp.Workbooks.Open("M:\strFilename.xlsx")
user2521720
  • 59
  • 1
  • 3
  • 7
0
votes
0 answers

How to change attachment field when item in list box is clicked

I have a form set up as follows: A combobox called "categories" A listbox called "moldnames" An attachment field called "moldpic" They all pull from a table called "Outside Master List" which contains the following columns: ID, MoldName, Category,…
Frederic Raffler
  • 1
  • 1
0
votes
1 answer

Having issues migrating data with attachments in Access

All, I have an MS Access database that has some file attachments that I need to programmatically copy to another MS Access table (both tables are linked tables to a SharePoint 2007 list). I have the following code. Private Sub…
William
  • 551
  • 2
  • 10
  • 24
0
votes
1 answer

Determine if Attachment field is empty

How can you determine if in Attachment field in Access does not contain an attachment using VBA? I tried If IsNull(rstMassBalance.Fields("FileName")) and If rstMassBalance.Fields("FileName") = Null but neither of these work. It either does…
user2521720
  • 59
  • 1
  • 3
  • 7
0
votes
1 answer

check if attachment field is empty vba access

I have a form with a combo box for a user to select from a range of dates. The form is based of a table where each date is a record. Each date has up to 6 attachments, each in a separate field. How can I check if an attachment field is empty when a…
user2521720
  • 59
  • 1
  • 3
  • 7
0
votes
2 answers

NHibernate 2 + NHibernate.JetDriver + MS Access: how to access 'attachment' field of table

This is my first question on StackOverflow! I am using NHibernate 2 in my vb.net project I also use NHibernate.JetDriver to access a MS Access database I have a table named tblPeople and it has a field named 'PersonImage' witch it is of the…
Angelos
  • 29
  • 3
0
votes
2 answers

C# Attachment field update on existing Access DB

I have an Access table that I recently added an attachment field to. The table is a listing of computers and information about each computer. The users of it, software installed, and so on. The Attachment field will contain a simple text…
Enonra
  • 1
  • 4
-1
votes
1 answer

VBA to create a form and load an attached image to it

Client has asked me to create a self contained tool in MS Access, versions 2007 and 2016. It needs to be self contained because it will be copied to and from various laptops at various times. The tool may not create, delete, or modify any file…
CWilson
  • 425
  • 10
  • 28