Recent content by 121854

Thank you. Any examples that I could check and/or study. That will be great. Thank you again for the guidance.

I have a pivot chart for a each record in a table, Is there a way that I can show these chart in a report. I want the report to print one record and their corresponding chart. There are 100 record so I will need to print 100 pivot chart. Can someone advice me through this opportunity? Or refer...

Can someone help me? I need to use the sorting/grouping dialog in MS Access to concatenate three fields. When I go to the dialog box I can set up one group but don't remember how to select a second field and concatenate field 1 and field 2. Can someone help me with the steps to accomplish...

Is there anyway to generate an outlook macro to parse an email message and create an excel workbook? I have being search the web but not able to find any guidance. Is there an SME that can provide me some guidance or tell me URL articles that could help me with the opportunity. Suggestions...

Is there anyway to generate XML files from access databases? Or do I need to built it myself using VBA. How can access generate XML files? Or How can access import XML files. Any articles, URL or suggestions will be appreciated. Luis

AlexIT - Thank you for the article and message. However, can you provide me the code to set the property IsAddin to True. Or an example, on how to set thisworkbook object addin to true. I have not being able to figure it out. Thank you again.

I have a template excel spreadsheet that would like to use it as a template to download a file from the internet. The macros in the template works correctly but when I download the file from the net and replace the template all the macros (module 1 for ThisWorkbook and the Personal macros xls)...

I have a template excel spreadsheet that would like to use it as a template to download a file from the internet. The macros in the template works correctly but when I download the file from the net and replace the template all the macros (module 1 for ThisWorkbook and the Personal macros xls)...

Skip - Thank you for the information. Going back to your question, the year is a column in the table. Thank you again. [thumbsup2]

Where can I find information regarding to changing parameters for a PIVOT chart? I have a Pivot chart that has year (2005, 2006) parameter and would like to change it depending on the year within VBA prior to displaying the Chart. Is there any books, articles and/or code examples that you can...

For example I would like to bypass or cancel the update to a record before the after update event. Or I would like to set up a before update event while I'm in the Enter or Focus event. Is there anyway that I can set those events in VBA if I'm in another event like set True After Update or...

Is there anyway that I can set "on" or "off" within access VBA? I would like to know if there a way to override events within VBA. Please help.

Could I dynamically, retrieve the Default Database Directory for a database. Ex. Tools | Options | General tab | Default Database Directory Can someone share the VBA code or refer me to an article that provide me the necessary detail information to for the coding. Than you.

I heard a lot of discussion between the microsoft strategy regarding DAO and ADO. My questions is very simple. With access 2000 and 2003, which object access is the best option. Or if you have to develop a new access system and/or platform which one should be used. Also, I heard that DAO will be...

Is it possible to create a macro in access to get an excel file and loaded automatically to specific table? I understand the I can use the export/import access wizard but would like to automate the process. Suggestions, examples or web links that I can search for this will be appreciated...