Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lmcate2
  • Content: Threads
  • Order by date
  1. lmcate2

    --- Newbie --- Removing character in a field in SQL

    Create a record in access 97 and saving it via SQL server the server is adding a chr(0)to the end of a text field. for Example Milk = charcters and read it back fomr SQL SERVER the lenght is 5 character which one is hidden. Does anyone knows how to remove it.
  2. lmcate2

    MS Access 2000 to email Word document from Customers

    I have a list of 500 customers with 150 fields for each of the records. I want to send an e-mail with all the 150 fields with their data to each customer for them to update, Perhaps in Excel format. Then I will received an e-mail back wit the updated Excel file, and I will update my db...
  3. lmcate2

    Find a Replace the ?(Alt Enter) to nothing

    I have a data file that has the ?(Alt Enter)when I am in the cell it displays a box. I want to remove this character. My import does choke when it finds this chacter
  4. lmcate2

    sorting columns horizontal in excel and create a vertical output

    I have the following excel layout JOHN TED JOHN TED TED JOHN TED JOHN TED 8.5 4 8 11 12 48 84 8 4 I want to sorted in alpha and results are below: John 8 JOhn 8.5 john 48 John 8 Ted 4 Ted 12 Ted 84 Thanks again, Sam
  5. lmcate2

    help printing to a file

    I have a task that I need to figure out. I am trying to save many trese and have the ability to print emails directly to a PDF automatically. Can do this in the backgrounnd from the e-mail propgram and from a web application. Thanks, Sam
  6. lmcate2

    recall email in 2000

    Can anyone help on recalling an e-mail in 2000. I have search the web can't find the opt of reall this message. Thanks, SAm
  7. lmcate2

    EXCELL --- DISPLAY HOURS MINUTES - QUESTION

    Would someone tell me how I can type the value of 109 that will represent 1:49
  8. lmcate2

    Excel Pivot Table Web Access

    I have create a Excel Pivot table component. I can only run this in my local computer and I will like to know How to run this remotely. Thanks, SAm
  9. lmcate2

    Pivot Table using excel component for Web

    I have created an online pivot table and I need to put it remotely. It will only run on my local computer.. Help help! Thanks, Sam
  10. lmcate2

    Basic Perl Question -- Combining arrays values into a string

    I have below my code that has the array and I want to be able to maka a variable to combine all string below. STRING &AgencyID=101000057&AgencyName=Test%20Ccra&AgentID=10014&AgentName=jeff%20kirk&AgentEmail=jkirk@me.com CODE #print "\n"; #print "<hr>\n"; foreach $namevalue...
  11. lmcate2

    How to pass the e-mail address in .net

    I have a perl script and I need to know how to pass the e-mail "@" to .net thanks
  12. lmcate2

    Access - unique phone numbers

    I have a single table in Access that contains customer information. Some of the contact contain multiple numbers, for example: Joe Smith 555-555-55555 Joe Smith 555-555-55555 Joe Smith 555-555-55555 Joe Smith 555-555-55555 Lin Smith 444-444-44444 Joe Smith 555-555-55555 Joe Smith...
  13. lmcate2

    Make a Bingo Table -- Array Problem.

    I have a bingo card card 5 x 5 = 25 cells. The formula below works great. Can you please let me know how can I get 25 unique numbers. If I do it now I will get 2 or 3 repeat numbers. =INDEX($A$2:$B$37,INT(RAND()*26),2) 3 5 2 23 4 3 17 22 0 18 16 1 8 24 0 24 14 19 5 24 23 10 4 8 6 Duplicate...
  14. lmcate2

    help please --- triming zero on text field

    I am new to Perl. I have an Access DB that has a text field called AgencyID and when I use the insert command it trims the 00 and I need to have the leading zero to the left. Like 00343478 not 343478 $db2->Sql("Insert Into TempAgencyOpenClosedPortal (TransRecordID, CCRANumber, AgencyName...
  15. lmcate2

    Make a button in Outlook - Click Here

    I have an Access application that has a very lengthy hyperlink is there a way with SendObject to display Click Here for the hyperlink http://www.abcdeff.com/documents/ht???=233/zzzz.htm I want to display "Click Here" Thanks
  16. lmcate2

    Create a button Click Here in Outlook from Access

    Can anyone knows how to create a click here button in outlook from Access. Currently, I have the e-mail to and subject but in the body of the e-mail I want the following http://www.xxxxxxxxx.com/program/id=32?/23.htm and I want just to show only "Click Here" button. Thanks, sAm
  17. lmcate2

    Make multiple list from a Master Excel File

    I have a Master Excel File that has many columns see below for layout that I received. I want to create indpendent excel files for each of the companies. For Example Hilton HOtels may have 10 lines and I want to create an Excel file with the 10 lines w/all the fields from he master file, and...
  18. lmcate2

    Make a macro to create multiple Excel Files

    I have an Excel File that has many columns see below for layout. I want to create an excel files for each of the companies. For Example Hilton HOtels may have 10 lines and I want to create an Excel file containing all the fields from he master file. Hotel Name Code Address...
  19. lmcate2

    Excel - Sorting with muliple line

    I have a report in Excel I need to sort by Company Name each of the components is 5 lines. Is there an easy way to sort them. Thanks, Column A Column B Column C 1 Company Name 2 blank line 3 total orders 34 1 4 Total rev $500.00 2 5...
  20. lmcate2

    --Tally records--- in one line

    i am new to reports... I have a database report that I will like to show the following: 1 - 14 A RECORDS 15 - 27 B RECORDS 28 - 40 C RECORDS 41 - 50 D RECORDS Thanks, SM

Part and Inventory Search

Back
Top