Answer Questions

• Rahulkumar Patil Access

  I've been trying to use visual basic to format a table in access. I have a horrible mess of a table, which has multiple rows of information, in which i have to pulled different information from depending on what is in the first column of the row. I figured on using if statements and variables to determine the contents and what i need to pull out, however, i cannot figure out the way to actually denote the cell in the function. Like if i want to ...Show All

• msctech cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. I have the same problem. i have'nt had yet the solution!! Per our support engineer: Thanks for using ISV Community Forum. According to your proble ...Show All

• MikeB123 Control of graphs and organization charts

  Greetings to all! How can one control properties and methods of graphs and organizations charts For example, I am trying to change the background colour of  a graph in a Powerpoint slide through a Macro command, or modify any kind of object in an organization chart. I am guessing I need to create a reference to the graph object and then access its properties through it, but have been unable to do so. Thanks in advance for any help or s ...Show All

• Rene Rijpstra Linking Outlook to Excel

  I would like to send an email via Outlook by clicking on a button in a Excel spreadsheet. The mail would contain some of the values in the spreadsheet. I think I know how to send with VBE an email given the server name but it does not go through Outlook. Thanks, Antonio From an earlier post, the following standalone console module works, but I cannot make it work as an Excel Macro, I gu ...Show All

• Joe Lynn How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Hi, You can use Unicode Character Classes with regular expressions to check for alphabetic characters. The characters represented in Unicode are classed into different categories like, letters, numbers, currency symbols, mathmatical symbols etc. You can check whether a character belongs to certain ...Show All

• Norbert Eder Access

  I've been trying to use visual basic to format a table in access. I have a horrible mess of a table, which has multiple rows of information, in which i have to pulled different information from depending on what is in the first column of the row. I figured on using if statements and variables to determine the contents and what i need to pull out, however, i cannot figure out the way to actually denote the cell in the function. Like if i want to ...Show All

• Dima Kherson Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   ...Show All

• nirmal_babu Extracting Text from body of Outlook email into excel

  Can anyone help me to finish off this code I am extracting text from the body of email messages in Outlook into Excel. The email messages are standard format and look like this: Questions answered by: joy smith ID #:25555 Total number of questions answered: 20 Total number of incorrect answers: 3 Grade as percentage: 85 % List of question(s) with incorrect answers. The incorrect choice is in brac ...Show All

• Michael Koster Controlbutton settings

  Hi, I have a little big problem. (I am a beginner) So : I made in access a form wich contains several control buttons, which are linked to a table. each button has the name (original) Command + number there are 4 main buttons, which charge a specific table when you click on them. so far so good. these tables are a listing of types. each type has a name and a code I search a value with Dmax Now I need : 1) a series of invisible ...Show All

• dtorg1955 Business Scorecard 2005 Installed - Just cannot connect to Analysis Services database

  Followed the readme for installation step by step. Installed the Server and the Builder on the same machine - db is SQL Server 2005 April CTP.  - Will the Business Scorecard work with the April CTP  - Launched the BS Builder and when trying to connect to a ADOMD.NET datasource, in server specified the <Servername>, the database dropdown always comes blank.....error "could not connect to data source" (Analysis Services is run ...Show All

• Murali T N Excel memory issues

  Hello everyone, I have been involved in the development in a graphical user interface which is used to sort large amounts of data, (thousands of rows, 30 columns). After sorting the data according to required ranges on column data, the columns can be plotted with any column against any other column. The number of plots can reach the hundreds and are displayed in a half-sqaure fashion. Anyway, I originally needed only 10,000 or so rows of ...Show All

• CoolCasimir Windows media files have changes to Nero

  Hi just wondering how I change my music files back to windows media player, they changed to nero flies last week after burning a CD. Hate the nero player, but love windows media player. Hope someone can help me Thanks Shihad P.S check out Shihad single    ALIVE   great! I've passed on your praises to the WMP folks who provided the answer. here's one more note that was provided by the team: Also if they chang ...Show All

• MattH6 DataGridView and ComboBox Column Problem

  Hiii all I have a problem in DataGridView, and i need help. I use DataGridView has column its "column type property" is ComboBox ok..., i want to add items into every cell of type comboBox, i want to add items in a cell of type comboBox different from items in another cell. this line adds items in all cells of type ComboBox Column1.Items.Add( "value" ) please help me Thnx I dont understand what do u ...Show All

• jettman Linking Infopath Toolbar Buttons to VBScripts embedded in Template

  I've been looking at the MS examples of creating custom Toolbar buttons, however they do not show how to link them to actual scripts embedded in the Form.  I've been able to create the buttons themselves, I just need to link them to the proper VBScript functions I've created.  Does someone have an example for me to look at thanks in Advance, Hi Glen, If you add a "test" button in your manifest ...Show All

• Jeremy Newman My buddy experience so far

  Started by timm at 03-24-2005 7:33 AM. Topic has 0 replies. 03-24-2005, 7:33 AM timm Joined on 03-24-2005 Posts 2 My buddy experience so far I joined the buddy program last year and have been very happy.  Although my buddy seems to have gone away and I am in-process for getting a new one, the support I received has been pretty good. Responses are not immediate.  It might take 2-4 ...Show All