Search results

You guys rock! Thank you very much, this is solved and it worked with the suggestion made by June7. Have a good day!

Hi June7, No, it doesn't appear anything :banghead: On my email what appears is: the text "< a href='http://www.nothing.com" then the image and then text again "< /a>". When I hoover the mouse nothing appears,like the link has not been added. Do you know why that can happen? Thanks!

Hi June7, Please find below the code that I have. It currently sends the image, but it does not return the hyperlink. I would like that when you click on the image redirects you to a link. Is it possible this on access? Thanks! Private Sub Command23_Click() Dim oApp As Outlook.Application...

Hi all, Hope you are good. Please note that I would like to know if you can guide me with my below inquiry. I have a database that sends emails to a group of people. Is on Html. I would like to know if it is possible to add a picture to this email and also when the people click on the image go...

ridders, You rock! This is issue is solved! Thank you very much for your help and support on this matter!:)

Hi ridders! You rock! It worked perfectly after I have set the field "SSN" as Primary Key on my main table and works just fine. Two last questions: 1) the form which I am changing comes from a query which I have made to be filtered based on a criteria. When people access it they have to insert...

Hi ridders! Thanks again for your help! Please note that I have done what you have suggested and it worked, however, I have updated data on a field of one of the records (I have 62 records on my form) and it updates the user and date and ALL the records. I would like only this information (Last...

Hi ridders! Hope you are good! Thank you for your help, I've done everything you have said and does not work. The form in which I am working is a "Split Form" and I am reviewing the data as a table and not each record as a regular form. Do you have any idea why this may be occurring? The...

Hi, Hope everyone is fine. Please note that I would like to add a field on my table that contains the last updated by and the last updated date. As per the internet research that I did, I had added to my table the fields [Last updated Date] and [Last updated by]. Then on the form that I have...

Hi Ranman256! Please note that the field is not autonumber. In both tables the field ID is number. The two tables are related by this field. Thanks!

Hi all, Hope you are good. Please note that I have a database that has two tables with the same field, however, in one table I have the information being worked at the moment and on other table the information worked on the past months. There are cases that are being worked now that commenced...

Hi All, Hope you are all good. Please note that I have an access database with a report that comes from a list with a lot columns of information, they are all needed. When I want to print the report on PDF I would like all the columns to enter in one page. I have set the page layout to...

Hi! Hope you are good and having a good 2017. I would like to obtain your help on the following: I have a table with information that everyday gets updated. I have an access database that has the same table. I have a vba code that brings the data from that excel file and it works just fine...

Thanks Ranman256! Please note that the issues is not that it pastes my information on the spreadsheet in addition to rows in blanks, it does not paste the info instead creates 6,0000 in blank. Do you know why this might happen? Thanks!

Hi everyone, Hope you are good. Hope you can help me out on this. I've been trying to make a database and to import info from an excel spreadsheet to an access table. I have used a code I found on the web and the same does not returns errors, however, when I go to the table in acess that should...

Hi guys, Hope you are good. I would like to obtain your help on something I thought it was going to be easy but it turned out that it was not. First of all please note that I have searched throughout the forum and on internet and I could not find an answer to my question: is it possible to make...

Hi, thanks all for your quick replies! I will try to answer each one of them: 1) does your excel file have the same structure (header against table field) as with your table? - Yes, it does. Actually what I did is to import the format of the table of excel as to make sure it has the same...

Hi everybody, hope you are all good. I am having an issue with the TransferSpreadsheet method. Currently I have an access database with a table named "PymtElc" and would like to import data to this table from a spreadsheet named the same way. I am using a code I found on the internet and made...

Thanks Pblady for your help! I honestly do not know how to do it, I've tried but had no luck :( No worries, I have one last and final question and I do not know if I should create a new thread for this or not. Since each item comes from the table, when I select one the options on the fields...

Hi Pbaldy! I appreciate your response. Honestly I am not that advanced and I am not sure how to make what you have mentioned, so I guess I'll keep looking around to make this work better.