Search results for query: *

Thanks strongm, Some of the Alt Text do not pull such as in line text within bar charts. If the Alt Text is within the chart, how to handle the pull of these

Hi, I am trying to extract the values or data within the ALT Text field in PowerPoint. Does anyone know how to code this in VBA? This include pulling information from the Chart ALT Text fields as well.

Thank for all and quick response. Sorry to bother, should have known better to use replace.

I am trying to remove Hyphen and only report the number from field, how best to do so? Example Loinc_Cd Result needed 4548-4 45484 13457-7 134577 718-7 7187 2857-1 28571 2514-8 25148 Thanks in advance for you help.

I am trying to get Supply Field in the Select Statement to read as Logical Field, so that it can get into the Sample.dbo.2009_PharmacyData Getting this message Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'N' to data type bit. INSERT...

I am trying to tied two table to a third table to share retrieve certain information into a report. Table #1 has the payer id and payor name which consist of multiple payers forming a many relationship of payer id. Table #2 has item id and item name which consist of multiple items forming a...

Thanks LB, It seem to be working fine. One additional question. The report created also shows a matrix based on columns as follows: Acct# FamGrp Fam1 Fam2 Fam3 Fam4 Fam5 Fam6 Fam7 Tot xxx000 Fam5 0 0 0 0 0 1 0 xxx000 Fam5 0 0 0 0 0...

Thanks, I'll give a try tomorrow and let you know. Thanks again for responding quickly.

Each of the FamGRP have a set of code to define the FamGRP For example FamGrp FAM5 consist of a group of items 77738, 77393, 77499. We are not trying to identify the items within a group, they are summarized on the FamGRP formula What we are trying to identify is accounts that have multiple...

I am doing an assignment that is to evaluate each customer account number and evaluate if their service fall into one of eight families. If the account # has two or more of the same FamGrp then, I would like these account set aside. For example in account # xxx000, I want to isolated or tag...

Version 9

I am new to Crosstabs. I've created a crosstab the show the revenue for 2005 and 2006. I want to create another column in the crosstab to calculate the percent increase in revenue for each of these two years. Can someone direct me as to how to go about doing this? Thanks, Juan.

Thanks, I got it to work. One final question, just so I can understand. The (Response = acDataErrAdded) and (Response = acDataErrContinue) what exactly is it doing in the program logic. Is acDataErrAdded variable you assigned or are they builtin and part of the msgbox function? I am still...

I have created a combo box field to allow user to browse records from a table. The form consisting of the combo box field has also a command button to allow the user to bring up a pop-up form to create a new record. Once the user adds a record, it returns control to the combo box field and...

I am new to Crystal reports. Does anyone know where can I get information to learn about Crystal Reports. I am gonna take an online course this week on the subject and would like to know where to purchase and what edition is most use out there. What is the average price for a starter version...

Thanks Duane, I have re-did the string again and date format. Thanks alot for your help. The string is working fine.

[b] Thanks Duane, I will give it a try when I get to work. I think it is a matter of where the quotations need to be placed. As far as the date stuff it is working fine. The Date() function does not put a zero in front of the date it generates when the month or day is less than 10, so I did an...

[b] Before explaining the subject at hand, I would first like to thank those who have provided me with support in Tek-Tips forums. I venture into learning MS Access a few month back and took a greater interest in coding again. WIthout your support I would have found it harder to understand, as...

[b] The naming of the file may vary in length but the file will have a contract starting with "C". The last part of the file will be fixed in length e.g., "C3453.xls" How can I trim the ".xls" extension and have the final outcome just be "c3453"? I want...

[b]I've created a system cap collect data from excel files. The system currently load data into Access from the Excel file. I want the system to be able to read the contract number put in the file name. For example, all contract start with a "C". It there a easy way to read the file...