Search results

Hi Pbaldy, You can find my database here so you can check what I´ve been trying to do and how everything is connected. http://www.mediafire.com/download/aauj0vgbv5r3pa7/ECM_Tool_Final_Version-Tasks_Play.zip I cannot attach it here because it exceeds the forum's limit. Regards, Mari

Hi pbaldy! Thanks for your reply. Where should I consider the mutiselect list box? I don't see how it can be fit here. Actually I have the common tasks and they have each their specific time, I would like for the clients to add the tasks with the specific time, not only the task itself.

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 GinaWhipp, Thanks for the reply. Note that the field "Time to perform the task" is a field on my task Table. And another field is "Task Name". Can anyone help me on my question? Thanks!

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 namliam, Thanks for your response! Could you please indicate me how do I add the debug to the code? Regards :) Thanks for your help!

Hi guys, Thanks for your reply. My table contains all the tasks that are done in my team and has the following fields: Task name, GU, Country, Category, Transactional Time, Constant Time. The form that contains the code has this fields to be completed, however on category I have a list that...

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. Can someone help me please? :( I have found several codes in the net and I found that that works but adds me one single line with several visas types. Can you tell me how to work this code for the same to add as many lines as visas are? Thanks! Private Sub cmdUpdate_Click() Dim...

Hi madEG, Thanks for your reply! Actually, I was trying to build it up myself and I would like to know if you can give me a hand with the code. I am attaching the database for your reference. I am not able to do it :( nothing works

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 pr2-eugin! Please find my database here and you will be able to see the annoying pop up that appears, in addition, the report with the same pop ups and with no data on the columns that refer to the sums in the query. The report is based on qry4 I want to know how can I do for the report to...

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 Rainlover, Thanks for your reply. Please note that I don't know what normalization is. Thanks in advance for all the help provided. Have a good day

Thanks Rainlover for your reply, I understand what Lagbolt said, it is true what he said: I have differents tasks that are performed depending on the type of travelers. This type of travelers vary from country to country. I can create the tables that lagbolt said, however I would need all this...

Lagbolt, thanks for your reply, however what you are mentioning - even if I don't fully understand it- I don't think fits what I am looking for since, you see, I have a list of different tasks, more than 500 that will be inserted in here and they will vary they won't be always the same. I could...

Thanks RainLover, Hope you can let me know what's wrong in here and how to solve this, I have to present this database on Friday and would be good to have it on time. Thanks again for everybody's help, you are awsome!