Search results

Thanks RainLover, I have changed to what you have mentioned. However, I have only one question, I need that in the column "Country" to appear USA not a number, is this possible? Because this will be column people will see regardless the country, and people will not understand numbers and they...

Hi RainLover! Thanks for your answer! Please find attached the database with the relationship created. Actually in my database made on 2007 I had the relationship created, it did not created when I changed it to 2000 version. I have another problem now, the form does not appears on datasheet...

Hi lagbolt, I am really sorry, I posted the same database. Here it goes again. Do you think it is possible to filter the data and also hide/show columns based on combo box option choosen?

Hi Rainlover and lagbolt, please find the access database in a previous version attached. Note that took me a bit to convert because a lot of things that I had with the 2007 version cannot be converted to 2000 so I had to erase a lot of stuffs, not sure if it works. In addition I forgot to...

Hi Paul, I have tried columhidden also and it did not work :S any word of advice? I have attached my database in my previous message.

Hi Paul! Based on your question I had tried to change to the number ID in "Case" and it is the same. Please find attached the database, I have also created a Query based on the table and it is still not working.... :(

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

Thanks JHB! You rock, that is exactly what I was looking for! Thanks!

Hi guys! I wanted to thank all of you for helping me. I have managed myself to keep on going without asking too much questions. However I couldn't :( I am sorry but I have an issue, based on the combobox I have on form "frm" I would like for the subform "qryUS" that is contained in the form...

Hi JHB, Thanks for your reply! Please find attached the database, the query in which I have the issue is "testquery". In addition I have added the excel that I have and that I trying to transpose to the access database. Please note that we are trying to do this in access because we have to do...

Thanks everybody for your help and support, it really helps! I have one final question. If I have this list for several countries and the calculation needs to be perform individually for each country, how would be the best way to do it? I am trying to create a single table, with a field named...

Thanks Foe for your answer! You are correct, I am actually wrong trying to pass something that is on excel to access, but I don't know otherwise. You see I have a spreadsheet in excel where I have a double entry table and I have several formulas, however, since the amount of data will be a lot...

Hi everybody, I am sorry I cannot provide this database that can be compatible with Access 2003 since it does not let me because it says that there are certain features that cannot be transposed into an earlier version. Thanks Foe for the fix that you made, it really worked. However, I was...

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

Thanks David! That's great, however what I was looking for is to send in one email ALL the information available for the person. With the code you had provided me, similar to the one I had, it sends one email per row of information. If "marina.silva" appears seven times, I don't want...

Thanks david! I am attaching a copy of the testing database I am creating, in this testing I did not included a linked table, but a table itself on access. However, the format of the table will be the same. I want to send an email with the information from those tables in the body of the email...

Hi David! Thanks for your reply! I understand what you say about normalize data, however the data that is being entered in the table is dinamic, meaning they come from an excel file which is linked to the access. The aim of this access database is to send an email to each person that appears on...

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 Pat, Thanks for your help and support. Actually I was looking to do a form, because I am going to need that several people can enter the specific data for each task, so I was looking for a entry data form. I thought that could be done. Maybe, like you have said I should leave the excel mind...

Hi everyone! All your answers have been great. Actually what I am trying to do it to create a data entry form that looks similar to a matrix. I could investigate that pivot tables in Access are possible, however, they are not editable. Basically what I am trying to achieve is a table similar to...