Search results for query: *

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

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

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

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

I click the button tool on the form toolbar. Drag in the button to the worksheet to create the button. However, I'm not able to assign a macro to the button. Any suggestions on how to do that?

Is there anyway to import and load a microsoft work document to a database? I have three or four reports that would like to load to access to produce year-end reports. Suggestion, advise or how to will be appreciated. Luis

I need to search in three files (a1, b2, b3)for "rejected bans". I would like to retrieve the "rejected bans" string located in these three files, Is there a unix command that I can executed that can provide me this information. If someone know and let me know that would be great. Try ls...

What does the ! means in Access? For example, Me!Customer. Need to understand when to use the . or the ! when connecting objects. Could someone help me understand the difference? Please. 121854

Does anyone know how can I define a field in access to be able to paste and/or link a visio diagram. Looking forward to hearing from the experts. Luis

Need to get the director and SVP elements from table 2. The problem that I'm having is that my query is repeting the cost center due to the multiple occurences in Table 2. I would like cost center from table 1 and the director and SVP from table 2. Only one to one occurence. Any suggestions...

Does anyone knows how to turn off the messages in access? I have the following message "The text you enteredd isn't a item on your list" and would like to not display it. I have code to get around it. Is there anything that I could do to inactivate this message for a short time. Your...

Need to check a Hex value in a VBA expression. Does anyone know how to do that. For example, I have a string in a cell, ABC. When move this to a Text string I have values between A and B. Special character, how can I compare that value to hex so that I know how to parse the string. Any ideas.

Need to parse a column in excel that contain the following information. Could someone provide me some guidance so that I can parse this column using Excel or a macro or in VBA. The information that I need to parse is: Column A: "25209 375487 BroadBand (WEST)" Need to parse it like: Column D...