Search results

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...

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 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...

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 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...

Hi everybody, as usual. I have this database with the purpose to storage all the tasks that are done in my team. I have a table named Tasks with all their fields. Now, I would like to set a more user friendly way for clients to update this table. I have created another table with a list of most...

Hi everyone, Hope you are OK. I have a database with two tables: taskTable and volumeTable. On the task table I have the list of task performed in my team and the time it takes to perform the task related to a category, and on the volume tasks I have the volumes of workload based on the...

Hi everyone, Hope you are right. I have an issue with a code that I have in a form which adds rows in a table as many times as categories chosen from a list. However, the code is not working correctly: it adds the information and creates a row with a category in blank, in addition to the rest...

Hi everyone, Hope you are good. I have a question regarding reports. I have a database that contains a table with volumes. This table has the following fields: Country, Volume, Month, Year. The field Month comes from another table which is has MonthID and Month. Then I have a query based on...

Hi everyone, Hope you are all great. I have a question. I have a table with the following columns: Task, Visa type, time it takes to perform the task. There are several taks that are performed for all visa types. I want to create a form to enter data to the table in which for the field visa...

Hi everyone, I have a question. I have a database and I had created a query that sums records and performs an Iif. When I create a report based on the query, the report brings the data for the column with the "If" properly, however the information of the Sums is not available. The column is...

Hi everyone, Hope you are great. I am contacting you because I have an issue. I have a table with the list of tasks we perform in our team. I have a column named "Visa Type" in which I have to insert the type of visa for which we perform the task and then I have another column named...

Dear Team, Hope you are great. I am contacting you because I have an issue: I have a webpage of my team which serves a database and provides reports. I know that we can with vba from access go to a link. I have managed to indicate to the code to go the link and it works, however, from this web...

Hi everyone, I would like to know if the following is possible: I have a table, I have a form based on that table (datasheet view) and I would like for certain columns to visible or not based on the input on a Combobox (list of countries) that is based on another form. I have searched on the...

Hi everybody, Hope you are great. I have an issue with a database I am trying to build. Basically this database contains all the tasks that are performed in my team with the time that takes to perform that task. What I want for the same to do is when a task is ticked, the number that number...

Hi everybody, Hope you are great! I just wanted to let you know that I have searched into the net for the solution to this and on the forum but found no answer. I wanted to know if it is possible to do the following: I have a table that contains the name of the person, the numbers of days...

Hi everyone, hope you are great. I was looking for some advice. It turns out that I have a pretty good "tool" in excel that basically whats it does, you enter information in the cells and returns you a number based on a calculation. This formula contains a simple "IF", if there is an "X" written...