Recent content by Zandra

Hi, i want the user to be able to create different projects in Access and also would like the user to have the option to browse all the existing projects and select/edit or even delete any project he/she would like. Any idea or sample databases would be appreciated. thanks

any help will be appreciated.

Hi, Is there a way to do this: 1) when exporting the file, save the file with the same name as the items in the selected item list box and save all the files under C:\ for instance, if the "Beverage" is exported then i want to save the file as "Beverage.xls". If "Seafood" is exported then i want...

thanks Banana, at least you are giving a hint. i appreciate that.

You are just keep asking the same thing over and over. i came this forum to get help and clearly i am not an expert of coding or the techniques you are talking about

I have answered all your question, so can someone help me here? Or please tell me if what i am trying to accomplish is not possible. thanks

The user selects the following from a drop down box store name store location Revenue Year (the years are dynamic and they could be either be 2004, 2005, 2006, 2007.... and so on) The user always selects start date and end date for the revenue. Once the user makes his/her own selection, then...

the fields are dynamic and they are based on user selection. The user may select field1 and field2 today but tomorow he/she may select field9 and field10 so that is why i am not using a query. I would not know which fields will be in the table because different users select different fields...

thanks for the quick response. The new field will have the result of calculation. For instance, if the 2 fields found then i want to substract field1 minus field2. That is all what i need. I hope you can help me with this as i was trying to figure out the last 3 days. many thanks.

Hi, I have a table and i would like to check always 2 fields if they exist. If the 2 fields exist then i want to add a new field. How can i do this? here is the pseudocode: check if field1 and field2 exist in MyTable if field1 and field2 exist then add new field else exit

I am not the expert but i normalized now but i am not sure how to calculate it. For instance, 2006-2007 and 2007-2008 but please keep in mind the years are dynamic. Pls. see attached how i normalized. I really appreciate your help. thanks.

Banana, Thanks for your response. Just to clarify, i have a table that has several columns and in this table i could have the following columns : 2006, 2007, 2008, 2009 and etc. So the table is generated per user's selection meaning the user can select to include in the table the revenues for...

Can someone help me here? thanks

Hi There, I have a table that table contain few columns but i am looking for specific columns and if found those specific columns; i want to perform simple calculation. Here is the pseudocode for what i am trying to do: Check if column names exist first (in this case the spefic column are...

David, The years are dynamic meaning the MainTable may contain the years like 2009, 2010, 2011 etc. And i want always to calculate the year over year percentage like in this case (20010-2009)/2009 and so on. So this is my main problem; the years are not fixed years they can change and they...