I have a form for adding new records. They are for people and I add in a bmp image of them. I want to create an automation. Where you press a button to add a photo. Find a jpeg you want. Then it is resized, converted to bmp and saved in the database. Is this easy enough to achieve? (size 256x188px)
View RepliesI have a form on access which allows users to upload csv files.
The files can be in any layout, so the field names and the number fields will always be different each time.
This can cause issues on data types, as access assumes a certain data type for a field, but the data may not always reflect that.
For example telephone numbers, access assumes this is a numeric field, however sometimes there will be symbols in this field such as +44. Which then causes import errors.
Is there any way to import these files without getting these sort of errors?
Currently the import process uses a simple TransferText method
DoCmd.TransferText acImportDelim, , "Original Data", Me.filelist.RowSource, True
This imports the data into a new table called 'Original Data'.
I had the idea of saving the table structure of the csv being imported (Importing the data with errors, then deleting all the records to just leave the structure) However I can't find a code to change the data types of that table to TEXT format, when I can't tell what the field names will be.
This whole thing is an automated process, which why there are loads barriers btw.
I'm using Access 2013. I have a directory on my hard drive that contains hundreds of image files. The name of the image file matches a field in the Access table, which are unique. I would like to match those files to the unique number in the table and create a link in a field. How would I go about this.
View 12 Replies View RelatedI am running Access 2013. I have created a report where the tables are linked to a SQL DB
I am trying to run a sales report that includes an stored image.
I am adding an Image and then using the control source to look up the 'filepath' stored in the DB. When I run the report on screen all the images are showing but when I try to print it (including exporting to PDF or XPS) and Print Preview only 2 of the 9 images print per page. The images are around 2-4 Mb.
I'm guessing its to do with the files sizes but cannot do anything about the size.
Hello
I have created an DB which we report the errors on a system we use. We would like to add images into the table where we record the problem so the programmers can see whats going wrong.
I have created a field within the table called images with a OLE Object selected. When i go to add an image i get an error message "OLE Server was lost, or the OLE server encountered an error"
Is this a problem with Access or would this be a problem with our network?
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.
I have in a form this code but i need to add image path for HTML to export the FinalTable to Web "HTML" format
Specially my point in
Code:
rstInsert(RTrim(rst![Attacking])) = "<img src=Attack.png>"
The full code is :-
Code:
Option Compare Database
Private Sub CreateCrosstab_Click()
Dim dbs As dao.Database, rst As Recordset, rstInsert As dao.Recordset
Set dbs = CurrentDb
Call DeleteTable("FinalTable")
[Code] .....
I would like to add image to list box but i read somewhere i have to use continuous sub form instead.
Now i like to know in sub form also we can select multi items and it shows highlighted entire of each row and easily getting value if selected items.
Hi there,
I am just contimplating the best way to add word files into my database. I know you can add them as objects, however when they appear on the form they seem a bit 'messy'.
Does anyone have anytips how to make this look more professional, perhaps the use of links, or buttons?
Many thanks in advance, Ross
Hi there, really simple question
I just wanted to know if I could edit the access interface so that the access help options would not be displayed, but I can add a link to my own created HTML help files for the system I have created. Is it possible?
I have a code to add links to files into a field, I recently migrated from Windows 7 to 8 and the name of the folders in 8 are different; therefore the database I have does not find the linked file anylonger.
To avoid this happening in future, I would like to have the option for the user to set the folder path through maybe a table and then the link will refer to the settings in the table.
Currently I am using the following code:
Private Sub AddLinkDoc_Click()
Dim strFilter As String
Dim strInputFileName As String
Dim varDirectory As String
varDirectory = "C:UsersMarco TagliaferriDocumentsBA CityflyerCrew SchedulerDocumentationDocs"
[Code] ......
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
From what I understand an OLE field would be able to hold a picture instead of text, correct?
Can I use an image in an OLE field as the image in a report? Here's my situation:
I have a report that we use to print an invoice that we send to clients. I want to include a scanned copy of a staff member's signature on the invoice but there are multiple staff members who would use this.
If I create a table with a Staff_Name field and an OLE field of Staff_Signature, which would hold the scanned signature image, could I use controls in a form to select which signature is included on the invoice report?
I'm not necessarily looking for how to do this right now, just if it is possible. I doubt I have time to really work on this in the immediate future, I'm just wondering if it is something I should look into.
I already have a function with multiple copies of the invoice report, each one with a different staff member's scanned signature. But that's bulky and it means that the reports and command buttons need to be changed with any staff changes. I would like to streamline this process.
I want to make a form or report that acts similar to a "bookshelf" view showing around 4 or so images in each row. When an image is clicked on it takes you to that record. I know a report can be used to make rows but how do I get the images to display? They are stored in a folder and not actually embedded into the database. I have a VB code that displays the image on my forms but this doesn't work when it's a continuous form or report. It shows the same image until I click on that record then the image changes.
View 14 Replies View RelatedI need to be able to browse to and open a folder from a form, and import images from within that folder to (i guess?) another form?
I then need to print each image on 3 different reports, but in order as below...
Image 1 - report 1
Image 1 - report 2
Image 1 - report 3
Image 2 - report 1
Image 2 - report 2
Image 2 - report 3
etc
Once images / reports are printed they can be removed.
Should I have a page that shows maybe 40 images and a big print button? or 40 images with a selection box by each one and a big print button? or 40 images and 40 print buttons? etc
The reports will need to change in the future, so a option to select any or all of the reports would be a really good idea.
I have access 2013 but I much prefer 2003 as I know where all the buttons are!
I am new to VBA for access. I am working on a form as a user interface. I have added an picture to the form. It looks small, and not clear because of the size, and each image has different size. I would like to know if there is a VBA code that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes. I attempted like this:
Code:
DoCmd.OpenForm "Prova", , , "Campo1=" & Campo1
but don't work
Prova is another form and Campo1 is the field with the picture.
I also need to save about 120,000 images. I wonder if the best solution is to use the attachment for the field type or another. What format should I Whereas in the mask I preview. And if Access internally saves the images or not.
I have the following xml script in my table and I want to make the 3rd button be a image that is saved in my c drive.
Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad1">
<ribbon startFromScratch="true" >
<tabs>
[code]....
I found the following getimage script but am not sure how to apply it to my button, I have seem various examples on sites but just can't get it to work.
Can I somehow set the icon path like C:Image1.png
Code:
Public Sub getImages(control As IRibbonControl, _
ByRef image)
Set Image = LoadPicture(getAppPath & control.Tag)
' Maybe something like
' Set Image = LoadPicture(c:image1.png)
End Sub
I have a database in which i have a table imagemaster including fields as id,name,image(attachment)
Now I have a form on which image name is there on label
I have an imagecontrol on the form with no picture at start
I use dlookup function on formload event which pull image from the imagemaster table.
When my form is loaded it show ( can't open the file 1.png ) which is exactly the file from the table that i want to open. It means it goes right there to the source but cannot open that or embed that into my image control.
random image selection from a form on a buton click event.To be more explicit: i have 7 images on form, when i push one buton i want to see how each image take focus (when take focus .BorderColor =vbRed after lose focus .BorderColor =vbWhite) and after lets say 20s focus stop random on one image and keep that image with .BorderColor =vbRed.
View 14 Replies View RelatedI have a form that have 9 subforms. every subform show pivotchart.
i was trying to export these chart using this code
Code:
Form_qCFA_Counter_RRC_Rei_IuB_Base.ChartSpace.exportpicture "D:iubbase.jpg", "JPG"
Form_qCFA_Counter_RRC_Rei_Power_Base.ChartSpace.exportpicture "D:Power.jpg", "JPG"
Form_qCFA_Counter_RRC_REJ_Code_Base.ChartSpace.exportpicture "D:code.jpg", "JPG"
Form_qCFA_Counter_RRC_Rej_Other.ChartSpace.exportpicture "D:other.jpg", "JPG"
Form_qCFA_Counter_Fail_CSPS_Code_Cong.ChartSpace.exportpicture "D:codecong.jpg", "JPG"
Form_qCFA_Counter_due_to_ce_cong.ChartSpace.exportpicture "D:cecong.jpg", "JPG"
It work but the image only show only 2 or 3 images, other chart only show nothing. is there something that i missed ? How to export all these chart (9 chart) as image without corrupting ?
I have an intermediate level experience in access.I am a private investigator and have created a beautiful access database to manage my case intakes, case progress, investigators, clients 8nvoices, expenses and a whole much more for my business.
I have integrated word merge in my database to generate final reports etc.
how can i merge an image that is attached to a record to word?
Basically i create a new case and input all pertinate information for that specific case and in that case I add an image of the subject, google maps for the residence and other images such as facebook screenshots etc.. and what i want to do is when I merge the case with word to also have a page in word to include this images.
I have the need to put a separate image per ID on my table/form or a separate link to an image I can put an image on my form but its does not change when I change my clients its the sam e all the time, I have tried linking to an excel book but for some reason it will only show 10 fields, (and it is linked).
I don't mind creating a standard windows folder with my images in but would need to be able to link to each one from my form.
I have a form with an image embedded in it. I want to be able to click on the image and leave a "dot" or "mark" where i have clicked, allowing me to click in multiple places on the image and leave multiple "dots"
I am assuming i need to crate a new shape each time i click, how is this done?
I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws.
Code:
Private Sub Form_Current()
LoadDefaultPicture
End Sub
Sub LoadDefaultPicture()
Dim db As DAO.Database
[Code] ....
This is working. However, when I change the record the picture flashes the current picture once and then loads the new picture. It is like it reloads the current picture then loads the new one. I'm hoping there is a way to get rid of the flash.
Also, the code fails here:
strDefaultPictureName = rs.Fields("AttachmentName")
When the query does not return a record. I can definitely fix this by adding an if statement to check for a record, but I'm kind of perplexed at why it is failing at that line. I would expect it to assign an empty string to that variable name and then fail on the next command where I try and set the ".Picture" property of the image.
I am trying to create a image based off a drop down result. I have had no problem with setting up a image based off a static number. e.g 0456432 in the student id field will bring up students photo in the network share.
What I am having an issue with is the control source will look for a number instead of the name that the drop box displays. this is due to a separate table for the drop box.
what is the expression i need to make in order for the name to appear from the dropbox rather than the source id number?
pretty Excel sheet full of conditional formatting that is used as a vehicle assignment board where I work. I know I can embed the file into an Access form using an unbound object, and therefore "integrate" it into Access, however this creates a copy of the file, and therefore when people change the sheet, the original Excel file is not updated. Is there any way to embed the excel file in such a way that the Excel document itself is also updated? Basically some sort of an active, two-way link rather than what amounts to just importing a copy of it? I need to be able to pull data from various cells in that Excel file so it needs to be kept up-to-date.
View 6 Replies View Related