Search results for query: *

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.

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

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

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.

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

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

I am trying to find an efficient way to update record in an Access table from a Tempory table created in Access. I wrote a sql statement in VB to append data to the permanent table in access from the temporary table created. I want to establish a query to compare both the temporary table for...

[b]I am trying to import Excel97 and Excel 2000 files into access but somehow it keeps going to the Error routine, when the DoCmd.TransferSpreadsheet is encounter. Below is the the method I am using. MCOWAdata is the name of the Access table Me.namedfile is the variable used to capture the...

I am looking for VBA code to run import interface. I want the user to select type type of data to import, filename and path from directory to import(enter in text or searchable by income that calls directory and drive). Please let me know if you have as I have to implement this right away...

I have a subform called payments and is connected directly to a table payments. within the form I have created a few calculated field values in order to add amounts from the payments table. The following is the calculated field values (stored as varibles in the subform.) [mths] = datediff([mth...

I have a two subforms within a form and am trying to calculate the a fields for each record in the two subform respectively. I want the totals of these fields to be displayed outside the subforms. For the first subform, I have the following [PaymentAmounts subform].Form![TotalsAB]. For the...

I am trying to allow user to enter date (MMDDYYYY) in a form but I want Access to automatically populate the last day of the month when the user enters the Month (MM) and Year (YYYY) e.g user enters 02/2003 and Access returns 02/28/2003. Can this be done through the input mask of the field, or...

I am trying to set up multiple primary keys to uniquely indentify record with three fields in the paymentlink table. Key fields for the paymentlink table are Contract member receipt date The enduser will interface with this table using a form to enter values in these fields. The Contract...