General :: Access 2010 / Adding Reports To Records As Attachments?

Apr 12, 2013

I have an Access 2010 database connected to several SharePoint lists. I'd like to be able to print a report (based on a query) and add that report as a .pdf attachment to the record I was looking at when I generated the report.

At the moment I can save the report as a .pdf to a local file store, then upload it as an attachment, but is there any way to skip that step and add it to the correct record automatically?

View Replies


ADVERTISEMENT

Access 2010 / Extract Attachments To A Folder And Link Them Back To DB?

Mar 21, 2013

using Access 2010, I have reached the 2GB limit. It's not the data, it's the PDF files I scanned in for each customer that has stretched the db to its limits. The db is also currently split.

I didn't realize Office had a 2GB limit; I assumed if you had a 64 bit computer and a NTFS partition, there would be no 2GB limit.

Using a template database in Access 2010, I need to extract the attachments to a folder and thus link them back to the database using hyperlinks. I can handle this task, but I'm not confident how to extract the attachments from each record (around 900) to a folder and have it do it automatically for all records. I can do it record by record, but that is not feasible with this many records.

how to extract all the attachments for each record, and have them saved in folders by their name or other ID, so I can link them back to the db via a hyperlink?

View 13 Replies View Related

General :: Access 2010 - Email Records In Body From Table

Oct 1, 2013

I've set up a piece of VBA code to loop through and email various recipients data, in the form of records within the email body. This works fine, but occasionally produces an error whereby the email output body lines are duplicated spuriously. This only seems to happen when running a large number of email loops.

The data source for the email body content is a table, which for each 'loop' is refreshed with new data by 1) deleting records from that table, and then 2) appending data to the table.

The portion of code for the loop & email:

Do
'Build outputbodytext
DoCmd.OpenQuery ("EmailQ2")
DoCmd.OpenQuery ("EmailQ1")
'set up email
Set rec2 = CurrentDb.OpenRecordset("outputbodytext")
strSendTo = rec2("Email")

[Code] .....

View 3 Replies View Related

General :: Create Multi-select List Box For All Records In Access 2010 Form?

Jun 3, 2013

I would like to create a multi-select list box for all the records in an access 2010 form.

View 2 Replies View Related

General :: How To Use Automation To Run Word 2010 Mail Merge From Access 2010

Nov 26, 2013

I have a MS Access 2010 application when the User opens form CONTACTS Form

◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx

View 10 Replies View Related

General :: Possible To Have Value In Excel 2010 Cell Used To Update Access 2010 Database

Apr 4, 2013

Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?

For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.

View 1 Replies View Related

General :: Calendar Synchronization - Access 2010 To Outlook 2010

Mar 23, 2015

I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?

Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.

View 2 Replies View Related

General :: Access Email Attachments File Name

Aug 26, 2012

Attachment File Name as it appears in email attachment box

{F54EBDF9-B9B6-4EA1-B56D35DEC50D0F69}.dat (257KB)

When you select open it does retreive the file in PDF.However, our customers are not very likely to open it because of its File Name.I do send the document to PDF file 1st.I am a carpenter by trade just trying to make my business more easier to run from the office and keeping up with the times.I receive emails from Vendors all the time,I am an avid user of Access since 2000, I barely understand VBA code and often copy from samples and/or researched code.

Here is my Code:
Private Sub Command198_Click()
Dim strToEmailAddress As String

[code]...

View 1 Replies View Related

Modules & VBA :: Adding New Record In Access 2010

May 16, 2015

I want to enable a few fields when i click on the Add button on my form.I have change the onclick to Event Procedure to be able to add the following code

Code:
Category_Desc.Enabled = True

My Category_Desc field get enable as expected but the Add button no long work

Code:
Private Sub add_Click()
Category_Desc.Enabled = True
Me.Refresh
End Sub

View 1 Replies View Related

Modules & VBA :: Adding Y Or N To A Field If It Is Not Null In Access 2010

Dec 18, 2014

how to make this two fields in my form to say Y or N if the field is Not Null. Like if the field is not null = Y Else = N for the two fields. I have a picture to show what i'm talking about.

View 2 Replies View Related

Adding Attachments Without Bypassing Database Startup

Dec 12, 2013

I have a split database, using Access 2010, Sharepoint is 2007 I believe. I have a form where I can enter requests onto a log and I've set it up to allow attachments. However, I get an error of "Cannot update. Database or object is read-only." if I try to add/remove attachments on a record. I have no issues adding and updating the data other than the attachments.

I've also found that if I bypass the start-up options (using shift) then the attachments work fine. Unfortunately, through trial and error, I haven't been able to find a database option which I can enable and fix the problem.

How to have this functionality enabled without bypassing startup (I've only intended to do basic things like hide the nav pane).

View 8 Replies View Related

Reports :: Change Plot Order For Graph In Access 2010?

Nov 28, 2014

I have a column graph I created for a report.

The Y axis has number of days.

The X axis has Member ID.

When I make the column graph the data seems to not be in any order. The report is in order by the number of days in ascending order.

How can I have the columns with the largest number show up first and the columns get smaller. I would like the largest column all the way to the left, proceeding the next one in size so it goes from largest to smallest.

View 5 Replies View Related

Reports :: How To Customize Right Click Shortcut Menu In Access 2010

Mar 29, 2015

how to customize my right click "Short-cut" menu in Access 2010. I need a right click menu with ONLY the "Print" and "Print Preview" options for my reports and I would like to disable right click in all other objects.

View 3 Replies View Related

Access 2010 - Send Reports In PDF Straight To A Folder In Drop Box

Jan 22, 2014

I would like to be able to send reports in PDF straight to a folder in Drop box with the click of a button.

View 1 Replies View Related

General :: Access 2010 And Access 2003 On Same Desktop?

Mar 5, 2013

is there a way to have both Access 2010 and 2003 exist peacefully on the same desktop. My company uses Office 2010, but my department has an Access 2003 application. As a result, I have to have A2003 on my desktop and use it quite frequently for this one application.

I have some small databases that I really want to move onto A2010 so we can take advantage of SharePoint functions, etc. Is there anytning I can do to be sure that the .mdb and .mde open in A2003 and the new .accdb opens in A2010, without getting errors and the Windows installer going through the Office installation process for the respective version? I've gone to the file locations and set the "Open with" setting to the respective version.

View 4 Replies View Related

Reports :: Option Button To Filter Report With Dates In Access 2010

Jun 9, 2014

I have a retort that I want to use an option button to filter the report is a specific date is 48 hours before the current time. I'm not having any luck. Below is the code I have been playing with, but no go.

Private Sub NoMove_Click()
Select Case Me.NoMove.VALUE
Case 1
Me.Filter = "CLM = 'Now() - 48'"
Me.FilterOn = True
End Select
If Me.Filter = "" Then
MsgBox "The filter returned Null"
Else
End If
End Sub

View 14 Replies View Related

Reports :: Dynamically Linking MS Word Document To A Report In Access 2010

Apr 18, 2013

I have developed a database using Access 2010. This is split into a Front End and a Back End.

In the same folder as the Back End I store a number of user modifiable files in either bitmap (.bmp) or MS Word (.doc to retain compatibility with older versions).

Unfortunately, the drive letter where the back end resides will change from location to location and I can't do anything about that.

I have set up a function that returns the location of the folder where the docs reside irrespective of the back end drive location, and this works perfectly with OLE linked pictures but not with OLE linked Word documents. User changes show correctly in Word document changes at locations with the original drive assignment but other locations show only the original doc contents even though they have been changed on the local back end location. - even if I delete the Source Item info on the report!!

An example of the code I am using for the Source Item is <GetBackEndPath() & "Footer.doc"> without the angled brackets of course, where GetBackEndPath() is a global variable storing the location of the documents folder ending with a back slash.

I have tried the above in the reports Source Doc property but Access won't accept this and says it isn't valid for this property.

View 2 Replies View Related

Reports :: MS Access 2010 Report - Exporting To Excel Produces Blank Xls File?

Jun 27, 2014

My report (rptBilling_STS_Summary) has three subreports (rptBilling_STS_Summary_Install, rptBilling_STS_Summary_Rental, rptBilling_STS_Summary_LDRate) that return values that are grouped by customer and calculates a total for each customer.

I need the report to export to excel for our client but every attempt has produced a blank XLS file. I have tried every export method I can think of. This is what I have tried:

Export button from external data ribbon
Export from print preview
Export via macro
Export via VBA (DoCmd.OutputTo acOutputReport, "rptBilling_STS_Summary", acFormatXLS, , False, , , acExportQualityPrint)

All this has produced the same blank excel file... Very frustrating...

I have searched and found a lot of information on 2007 and it requiring sp2 but all I can find on 2010 is instructional information.

Update: I copied the database to my local PC and when I export the XLS file it opens in protected view.

View 5 Replies View Related

General :: Access 2010 - Status Bar Not Visible?

Aug 15, 2014

I am using Access 2010. I Have the 'Display Status Bar' box ticked in Application Options but the Status Bar is not being displayed.

View 8 Replies View Related

General :: Editing MDB File With Access 2010

Nov 15, 2012

Any issues with using Access 2010 to edit an mdb file..I know there are backward incompatibility issues with 2007 and 2010, but these are both accdb formats.

View 1 Replies View Related

General :: Get Rid Of Dialog Box When Closing Access 2010

Oct 21, 2013

I have a Access 2010 DB. The mainform have a subform with one table alone.

I have a button who close Access when the user are finish on the mainform. Still I have the upper right corner X-button who also closing the app.

My problem is that when the user use the X-button then a dialog box appear and ask for saving the changes for the table in the subform on the main form. The user must then do the choise 'yes' , 'no' , 'Cancel'.

There is no need for this dialog box, (I take care if it's necessary earlier) but I can't get rid of it.

View 12 Replies View Related

General :: MS Access 2010 Cannot Remove Password

Apr 23, 2014

I have MS Access 2010. I cant remove password because when I open in exclusive mode, file, info, there is no decrypt password option.

View 1 Replies View Related

General :: Hide File Tab In Access 2010

Jan 25, 2013

I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?

View 8 Replies View Related

General :: Access 2010 - Database Only Working In PC?

Aug 27, 2014

I am Using Access 2010 Version. I have created a Database which consists of Linked Tables (from remote Server), Queries and a Form.

I am using Form to search the required Data. Every thing is working in My PC. But, when the Database file is trying to open from my colleague PC. It is not working. I mean, The Form is opening but when I click the Button nothing is happening. My Colleague is using 2007 Version of MS Access.

View 5 Replies View Related

General :: Assign Stock To Customers In Access 2010

Jul 28, 2014

In MS Access i want to be able log jobs and be able to assign my stock to the jobs i have logged is this possible ? how to create a database to log jobs but how can i make it so when i add stock to the job it will remove it from my stock pool and assign it to the customer thus taking it out of stock.

View 3 Replies View Related

General :: Spell Check In MS Access 2010 Runtime

Sep 16, 2013

When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker?I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get an intelligible report.

View 1 Replies View Related







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