Ok. So I have learned my lesson on saving images into an Access DB. Now I'm using VBA (another good learning experince) to save the images back to a folder. I have a code working that will save the images but I need it to also rename the images after saving.
The section "MyFile = OldFile" needs to reference the rsChild Attachment file name...
Quote:
Private Sub Command859_Click()
Dim db As DAO.Database
Dim rsParent As DAO.Recordset2
Dim rsChild As DAO.Recordset2
I am using Access to save an Excel file in a particular directory. The code was created about 10 years ago and hence saves the file with .xls extension and I would like to save with a .xlsm extension. If I just change the .xls to .xlsm, in the code below, the file is saved but the Compatibility Checker comes up (I would like to stop this) and when the file is reopened I get an error message stating there is a file extension problem and the file won't open.
I need to save a single record (preferably the current record) as a PDF. I have created a form for my boss to calculate bids. He wants to save each record individually as a PDF to upload into our service software program to attach to client files. I can save a selected record as a PDF if I print the selected record first. We need to eliminate having to print it first as it is just a waste of paper and an unnecessary step. I am kind of thinking that VBA and attaching that to a control button on the form is the way to go, but I am new to writing code and I am completely confused!
I was curious if there is a way to embed images into a database, so that if I emailed it to someone, the images would still be able to open. I tried using a table and adding attachments, but that doesn't seem to work very well.
I'm new to vba programming and I've written a code which will insert a table in the current slide now i want to insert pictures in the cells of the table how can i do that?
This is my code:
Sub NativeTable() Dim pptSlide As Slide Dim pptShape As Shape ' code from google to create a table Dim pptPres As presentation Dim iRow As Integer Dim iColumn As Integer
I have photos stored in a folder on a drive. I have referenced them before in a simple picture viewer I created in a form. I create the file name by referencing the values of a list box on the field.
Example:
The list box has piid.2005.001 and image name is 2
Each piid has it's own set of photos in their own folder
Now. I want to be able to print out all the files in a report/form. The piid and image name are stored in a table called tblPhotos so I could reference there.
I want to have a button I click that generates a report/form that spits out all the photos in that folder. Next to a button would be a text box (txtWhichPiid) where you enter in the piid and that's how you know which piid's photos to use.
I need to replace the embedded image on a large number of reports and forms. I'm looking for a way to loop through all of the controls in my forms and reports and if the control is an image, replace the embedded image with a new one. Can this be done using vba?
Is it possible to efficiently store images in an Access database without having to install custom COM files and the like on your server?
I know it's possible to store them using OLE objects but I've heard this adds a significant amount of data to the image when storing. Is this correct?
Does anyone know how I could get around this? I'm interfacing the DB via the web, unfortunately I have to use an access DB for the task and can't tinker with the server.
I'm trying to make a field specific image on a tabular subform, so a different image appears on every row depending on the field information.
Currently my code displays the same image on every row depending on which subform row is selected:
Code: Private Sub Form_Current() Dim imagepath As String imagepath = GetImagePath & Me.Exercise & ".jpg" If Len([Exercise]) > 0 And Len(Dir(imagepath)) > 0 Then Image26.Picture = imagepath
Which is a more robust approach when designing an Access database in regards to storing images, such as TIFFs. Is it better to store the images in each data record as necessary or is it better to just store a path in the database that points to a location of where the image resides (on a hard drive somewhere for instance.)
I've read that Access 2003 does not support Tiff images anymore. I need to see a document or Website that indicates this so I can back up an arguement. I've seen a little regarding this matter but nothing solid. Can anyone help?
I am building a database for my job. I am trying to find a way that I can mail merge an Image that store in Access to a Word document. I tried doing it by creating a field in Access for the picture and its field type was set to OLE Object and I placed the merge field in its appropriate area in Word. When I go to merge it, its comes up with a message that says "Long Integer or Binary Number". If anyone has an idea as to how I can make this happen....please let me know, your help would be greatly appreciated.
There are those builtin bmp images in access e.g. delete, edit, select, filter, etc etc. I am trying to access the location of these small bitmap images and use them for a web application i am creating. Do you know where they are located? I am searched with no luck.
Someone also sent me an access db, i'd like to reuse the buttons (same bitmap images: edit, delete) from this access db. Where do i go to extract the images?
I have an application in MS Access that contains some forms and reports. I want to be able to show pictures on the forms. So I am saving images on file system and storing links to those images in MS Access tables so that they can be retrieved and be shown on the forms. Can someone throw light on the effects of this approach on performance of the application (especially vis-a-vis the approach of storing images in the Access tables as OLE objects)?
Would appreciate if responses can be directed to my email-id Satya_Nadiminti@infosys.com
Having trouble using .JPG images in Access 2013 reports? I inserted some images (of arrows) onto a label report. Since then, I've had problems with my DB becoming corrupted or "unstable". I can give more detail if wanted, but my main question is do y'all recommend using images in reports and forms. If so, what format?
I am setting up a database with an image linked to each record. I have installed Photo Editor as required to display jpeg files. However, when I try to insert object in the table field, Photo Editor does not appear as an option under 'Object Type'. How can I use Photo Editor as my OLE server to display jpegs? Or, can someone suggest a better way to display images on forms? I'm a newbie, so although I'll try more advanced programming if required, I will need quite detailed step-by-step instructions :)
It may seem a really silly question but is there any restrictions as to the file types that can be stored in an Access DB.
I havent used Access in a while, but have been asked by a friend to create a simple DB holding info about cars he is selling, he only wants to hold thumbnail images of the cars so I can either link or embed the pics! However if I try to link or embed a jpeg image nothing appears in the bound object frame except for the image title i.e. bmw325i.jpg if I do exactly the same with a bitmap image the pic is displayed???
The only other difference I have noticed is that in table view of the relevant table a bitmap appears as Bitmap Image whereas a JPEG appears as Package????
come up with the below code to create PDF documents based on a query. It has been working great but I have a change that I need to make and can't figure it out. The code below creates all the documents in one folder "serverD$DocumentsInvoices" but I need it to create a separate folder for each PDF so that the file (Invoice1234.pdf) will be in the folder (serverD$DocumentsInvoicesInvoice1234Invoic e1234.pdf). That folder does not exist, so I need to create it and then save the PDF into it.
Code:
Dim db As DAO.Database Dim rst As DAO.Recordset Dim qdf As QueryDef Set db = CurrentDb Set qdf = db.QueryDefs("Invoice_Report") Set rst = qdf.OpenRecordset
I am trying to find out what VBA Code I should use for a way to save a main table name: Master_Template on a certain day of the week (weekly) to happen automatically on close of the database - of course on that certain day of the week.
1. open outlook mail; 2. copy the email details into the database; 3. save the attachment into a E: drive location; 4. move the email to another folder.
1,2 and 4 were working fine until I tries to save the attachment and got stuck on the SaveAs line.
Dim Ola As Outlook.Application Dim Nsp As Outlook.NameSpace Dim pf, Inbox, ib, newdest As Outlook.MAPIFolder Dim msg As Outlook.MailItem Dim Atts As Outlook.Attachments
Having problem with loops. The inner loop updates a table. The outer loop pulls the record number from the "tblChangeOrderTable_Edit_Count" and is assigned to strRecordID . The inner loop uses strRecordID to find the right record. I keep getting errors like (Object variable or With Block variable not set.)
Code: Private Sub btnClose_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim db As Database, rs As Recordset, rs1 As Recordset2 Dim Criteria As String Dim strAns1 As String Dim strAns2 As String Dim strCount1 As String Dim strAns3 As String
I'm trying to figure out why I can email a report as a PDF, but not save it as a PDF using the code below? When I save, I get the dreaded error 2501.
The searching I did for this said to uninstall and reinstall printers (I've done that - seems to have no effect), or took issue with filtering the report with a where clause (but if that was an issue, why does it email a PDF just fine?).I'd just like to be able to save a report as a PDF to a specified location.
CB Developing in: Access 2010; Win7 For use in a mixed 2007/2010 XP/7 environment
Code:
Private Sub EmailDietCardBtn_Click() On Error GoTo MyErrorHandler Me.Refresh Dim stReport As String Dim stWhere As String Dim stSubject As String Dim stEmailMessage As String Dim stCaption As String Dim myPath As String
