General :: Attachment Field Types

Apr 12, 2013

I have a database for recording jobs and invoices for our transport company. I was thinking of adding an "Attachment" type field to my invoice table to store pdf's of scanned copies of the delivery notes relating to the invoice. How this will affect the performance of the database? Will adding this field greatly increase the size of the database and slow the whole database down?

View Replies


ADVERTISEMENT

General :: Create A Spec File Or Set Field Data Types

Jan 26, 2014

Looking for a way to use transfertext to make a table and create a spec file from csv files I am importing. I want all fields in the table to be shorttext.

Otherwise I need another way to bring the files into a table.

I have a generic spec to use that brings in any data as text.

Created the spec from a delimited file with 255 text fields... Field001, Field002, etc.

However the field names need to be changed. My field names are in the first row of a table. I will need to read each fields data in the first row and rename the field.

View 1 Replies View Related

General :: Audit Trail Of Attachment Field?

Nov 27, 2013

I have been using Access for quite some time now and I am able to usually work around many of the issues that come with being a small timer, like me, taking his best shot at Access; however one issue I have had absolutely no luck with is auditing a new and/or change made to an "Attachment Field". I have successfully been able to audit every type of field with the exception of the "Attachment Field".

View 7 Replies View Related

General :: Attachment Field - Specify Location To Search

Jan 14, 2013

Using an attachment field - can we specify the location to search?

We have an Access 2007 DB and need to attach files from only 1 location - we hope to attach a copy of these files into the database efficiently.

I have a few sample DB's that use VB but I am hoping there is a quick and easy solution for this.

View 2 Replies View Related

General :: Reference For Attachment Field When Creating Query

Jun 28, 2015

I create a query in access 2010 to merge into a word template.

It all works fine but I can't seem to get the contents (a graphics image - signature) into the query file.

Not sure what to reference for the attachment field when I'm creating the query.

View 2 Replies View Related

General :: Collecting 2 Types Of Information From Combo Box

Mar 6, 2014

I have 2 tables

1. stocklist
2 product details

I created a form called " product details "

Using a combo box in the form "product details" I select a "part number " of which the part number and the associated description of the part comes into a fields called "part number " and "part description "

The part number selected then goes into a table called product details

Is it possible that when I select the part number , both the part number and the part description go into the table called product details.

View 1 Replies View Related

General :: Locking Record File Types?

Aug 21, 2014

I have inherited a number of 2007 Access databases that have a PDF (Adobe Acrobat Document) as the file type for the locking record.

These databases seem significantly slower, and have more frequent "Not Responding" periods on the network - especially when compared to those with a standard ldb file type locking record.

What determines the file type for a locking record?

Can the Adobe locking record be changed to a ldb? and How?

View 9 Replies View Related

Field Types

Sep 10, 2006

I am building a table where one of the fields is a yes/no field type. When the yes box is selected, I need to "jump" to a different set of field names than field names for selecting no. I have researched on internet and have done some reading but have found no information. Is it possible to do what I want to do in Access? My skill level is that I can build tables, create forms, create reports and run simple queries. Any help offered is appreciated.

View 8 Replies View Related

General :: Modules Not Appearing As Object Types In Navigation Pane

Apr 19, 2013

I am now working on this new database. I would like to make a calculation so that I could derive a value called eGFR from a patient's serum creatinine. This is a test of kidney function.I am having the following problems.

a. Modules are not appearing in the Navigation Pane of the Access 2007. When I press 'Object Types' in the Navigation Pane I get all object types such as tables, queries, forms, reports, macros but not modules. I know there are modules as I have written lots of vba code.

b. I have written the following code within this Function. The following is the code.

Public Function eGFR(creatinine, Gender, Age) As Single
If IsNull(Age) Or IsNull(creatinine) Then
eGFR = 0
Else

[code]....

This code is working fine in another database, however when I try to upload a query in the current database that has this function in one of the fields, I get an error saying the the function eGFR does not exit.

I have inserted the function into one of the modules that I have managed to enter.

Do I need to deposit the code elsewhere? How do I access Modules from the Navigation Pane?

View 2 Replies View Related

General :: Emailing PDF As Attachment With SendObject?

Jun 16, 2015

I often output reports as a PDF. I also use SendObject to send emails from my application. But is there a way to send a PDF as an attachment with SendObject? Perhaps not, as the PDF would not be within my application?

View 3 Replies View Related

Attaching Files Of Different Types To Table Field Thru VBA

Apr 23, 2007

Hi Everyone,

I have a PO table. Each PO has 3 documents of multiple types (one may be Word, other may be Excel, Acrobat). When I display the PO, the attachments should be shown as Icons, which when double-clicked, will open in its own Application.

I have a pop-up screen where I enter new PO details. In this screen, I have Attach/Detach buttons for each of the Documents.

My Requirement:
When I press 'ATTACH' of Doc1, the File Selection screen should be displayed from where the user will select the file to be attached. This file should be updated into the table field "doc1".

When I press 'DETACH' of Doc1, the file in table field "doc1" must be cleared.

How can I achieve this???:mad:

View 1 Replies View Related

How To Display Field Types Of Access Tables In Vba?

Apr 5, 2005

How to display field types of access tables in vba?
can any one show me how i can display display field types(like : phone integer ....) of
access tables in a text box using vba? I have no idea how i
can obtain that information using vba. Looking forward to your
replys.Thanks

View 1 Replies View Related

Modules & VBA :: How To Get ForeignTable Field And Relationship Types Using It

Jul 25, 2014

For reasons I need not get into as it generally proves to be a distraction, I need to document the relationships in databases.

I've been playing around with .Relations with some success.

I can easily get the relationship's name, Table Name, Table Field, and ForeignTable.

Code:
For i = 0 To objDestDB.Relations.Count - 1
With rsMigrateRels
.AddNew
!RelNumber = i
!RelAttributes = objDestDB.Relations(i).Attributes
!RelFields = objDestDB.Relations(i).Fields.Count
!RelFieldsName = objDestDB.Relations(i).Fields(0).Name
!RelForeignTable = objDestDB.Relations(i).ForeignTable
!RelName = objDestDB.Relations(i).Name
!RelPartialReplica = objDestDB.Relations(i).PartialReplica
!RelProperties = objDestDB.Relations(i).Properties.Count
!RelTable = objDestDB.Relations(i).Table
.Update
End With
Next i

However, despite lots of digging into the other properties and attributes associated here, I cannot yet figure out how or where to get the:

ForeignTable field
The type of relationship (1:1,1:many,many:many)

View 14 Replies View Related

Link Two Tables - Changing Field Types

Jun 11, 2012

I am needing to link two tables but one field is in a "May 2012" format while the other table is in a "053112" format.. Is there a way beyond creating a formula to change "053112" into "May 2012"??

View 2 Replies View Related

Summarization In Report Footer With Two Types Of Output From Same Field

Mar 22, 2007

Hello everyone

I am in need of assistance with Microsoft Access. In the reporting function of Access I am trying to have a summarization total of indirect time and direct time based off a Auditor Timesheet form developed. On the report I am able to see both the direct time and the indirect time hours seperate per auditor based on the query that is run to seperate direct and indirect hours and each individual auditor stats.

but the problem I am having is trying to summarize on the report the total direct and indirect hours as a whole.

Please let me know if this a simple solution by building an expression in the field for the report or some type of VBA code input which would suffice?

Thank you

View 2 Replies View Related

General :: How To Copy Picture On Attachment And Send It To MS Word

Jul 11, 2012

I want to copy the file stored on a attachment field (.jpg), so i can use it on a Word document as a picture.

I've tried it with bookmarks but no success:

' 'Paste the photo.
.ActiveDocument.Bookmarks("EidPhoto").Select
.Selection.Text = GetPath & "RE EIDPicture" & OwnerFullName & "_eid.jpg"

Then I only get the path of the file, Is there a control that i have to use?

View 1 Replies View Related

General :: Create Email With PDF Attachment Using Lotus Notes

Jan 23, 2013

I need to create an email with an Access report attached as a PDF. I am using Access 2007 and Lotus Notes.If I use SendObject with acSendReport and acFormatPDF, it opens an email just fine but the attachment is created with some random letters and numbers and .tmp as the file name.

If I use Adobe Reader to open the attachment it displays correctly as a PDF, but I need the attachment name to be .pdf so it will automatically open with Adobe for the users.Is there a way to accomplish this with Lotus Notes? I have searched this forum and found some options for Outlook users, but not for Lotus Notes.

View 2 Replies View Related

General :: Use Buttons To Navigate And Open Current Attachment

Apr 3, 2013

Is it possible to use buttons to navigate/open attachment? I have two tables (itemTbl and ItemcomponentTbl) and a form.

Inside formare itemtbl field names (w/c include the attachment) and a componenttbl subform.

Here is my DB.

View 2 Replies View Related

Access Field Types Change When Relinking Data From Sql Server?

Jan 25, 2014

We have been using an Access (Access 2013) program where we link the program to dataviews created in sql server.

Recently we had to re-link the data views because a change had been made to them. When we relinked the data we noticed that the field type for the field used as the primary key changed from "Short Text" to "Long Text". The programmer who created the dataview from sql server said that nothing was done at that end that would have caused the change

I know how to prevent the problem from recurring. We are changing the sql server spec from VARCHAR(8000) to CHAR(20).

View 1 Replies View Related

General :: Send Email Attachment Using Form Data Using Automation

Jun 20, 2013

I am currently using SendObj method to send an Outlook email and selected report as an attachment using the current form's data. This is triggered by a button click.

This is working well apart from having to use 'ClickYes' to outwit the Outlook 2012 security system.

However I now need to selectively send an extra pdf file with some of the emails based on a Yes/No field on the form. This is a fixed file on my local C drive.

I think I have to use automation to do that but I can't find a method of specifying the report I currently use in the SendObj method in the .Add.Attachment line.

Do I need to run the report and then save it so that I can specify the path and name in the .Add.attachment line followed by code which will delete the file? or is there a means of combining the code I currently use in SendObj to create the pdf object with automation option?

I have working code for both attachments at present but they send separate emails and I would prefer to combine them if possible.

View 3 Replies View Related

General :: Using Access 2010 To Send Bulk Email Each With A Unique PDF Attachment?

Feb 12, 2013

I would like to automate the current process of sending an e-mail with a PDF attachment that is unique to each recipient; it is their test results. I'm sending an e-mail one at a time (which was fine when the number of folks being tested was small, but now I'm up to approximately 200 e-mails and growing each year)

System Environment:

Windows 7 SP1 (64 bit)
Office 2010 Professional

Access environment and Process:

1. A qry object/letter is built based on 4 tables (test results, result averages, a global employee list and location)

2. The Report has both static and dynamic text. Examples include: "Dear" [qry-Letter. F_name] and Address Information

a. =[qry-Letters.F_Name] & " " & [qry-Letters.L_Name]
b. =[qry-Letters.Position]
c. ="Dept " & Right([qry-Letters.Dept],3) & ", " & [qry-Letters.City]

3. The report also includes the employee's results, the session averages (testing is conducted at multiple locations each occurrence is a session) and companywide averages.

4. Report Process: Run the report, entering primary key Emp_ID, report is populated saved (overwritten with the next Emp_ID and printed as a saved PDF.

5. MS Outlook: create a new e-mail, text body is common to all e-mails e.g. "attached are your test results" the PDF is attached and the e-mail sent to the recipient (the e-mail address follows the corporate standard, =Trim([qry-Letters.F_Name] & "." & [qry-Letters.L_Name] & "@abc.com")

View 3 Replies View Related

General :: Pull Images From Shared Folder On Network With Links - Email Attachment

Jul 9, 2014

I have a database that pulls images from a shared folder on our network with links. Is it possible to create a button to email the current record on a form and attach the file it references in the link?

The attachment is a pdf signature. I didn't want to include the files in the database for space issues.

I am using Access 2007. We out outlook as our email client.

View 1 Replies View Related

Tables :: Attachment Field With No Subfields

Feb 11, 2015

I wanted to add a field of " Attachment" to an existing table an as usual, I entered field name " Attach" and the Data Type , I chose "Attachment". Then saved.

Checked with the Datasheet view, there it is, tried to click on the field , the dialog box appeared. cool

The strange part is when I want to put an attachment field in a form , there were no sub fields only one word "Attachment", there is no + or - .

I tried to add the field to the form so I can add attachments, but it stayed there like a normal field.

why my attachment field do not carry the sub fields of attachment like attachment-FileData, attachment-FileType and attachment -File Name.

View 1 Replies View Related

Download All Files From Attachment Field

Jan 16, 2014

I had the bright idea of creating an Attachment field for each record in my database so that the source material for the record (usually a PDF) could be opened and reviewed easily. A few people have asked me not only for the data but copies of the source files as well - is there a way to export attachments from every field into a directory instead of going one-by-one?

View 4 Replies View Related

Query Based On Attachment Field

Jan 24, 2015

I would like to know what criteria is used to return records based on a field with data type attachment.

I am using "IsNull" and "IsEmpty" but neither of these work.

View 8 Replies View Related

Append Tables With Attachment Field

Sep 21, 2013

I have two databases that I need to merge into one. The structure of each DB is identical, however the data is different. My original thought was to import all the tables into one DB, then use Append queries to merge the similar tables. The problem is that the main table in each DB has an Attachment field (using the Attachment data-type). After doing some research, it seems that you cannot use an Append query that references a table that contains a multivalued field (such as the Attachment data-type).

Every record has at least one attachment stored in this field, so removing the Attachment field is not possible. So my question is, if I have two identical tables, each with an Attachment field, how can I combine them into one table?

The only idea I had was to write a VBA procedure that would loop through all the records in the main table and save each attachment in a folder outside the DB, then delete the attachments. I could then merge the two tables using an Append query. Finally, I would run another VBA procedure that would load each saved file back to the appropriate record in the DB. The procedure that saves the attachments would have to write the primary key for the record they were attached to in the filename (or create a new sub-folder that is named with the primary key value), then the procedure that loads the files could read that value from the file or folder name and know which record to attach the file to.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved