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 TouchToneTommy 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: SpeedStick
  • Content: Threads
  • Order by date
  1. SpeedStick

    Separating UTF-8 from Non UTF-8 Words

    I need to identify characters/words that are UTF-8. I am just trying to either highlight a cell, a word or a letter that indicates it is UTF-8. I currently have the data stored in Microsoft Access and I will export it Microsoft Excel. The ultimate goal would be to try to separate UTF-8 words...
  2. SpeedStick

    Finding UTF-8 characters in Excel or Access

    I need to identify characters/words that are UTF-8. I am just trying to either highlight a cell, a word or a letter that indicates it is UTF-8. I currently have the data stored in Microsoft Access and I will export it Microsoft Excel. The ultimate goal would be to try to separate UTF-8 words...
  3. SpeedStick

    Access 2007 - Percentages in a Report

    I am trying to display percentage results in a text box. However, the results are coming out in this form 1.27693385503062E-05. How do I get these results to be displayed as regular percentage results? The equation I am using to calculate my results is: sum([Total])/19578148).
  4. SpeedStick

    Forms and Division

    I have form that I trying to complete. I have 1 text box that I used this function (=Sum([CountOfPT])) to total the number of records for a field. I need to take this field and divide by this: Table Name:Total Field Name: TotalPT. How do I format a DLookup to pull Total!TotalPT into the form...
  5. SpeedStick

    Query Help

    All, I need to write a query in SQL Server 2008 that will find all records that have an end date for next month and also all records for the previous months. This query needs to be re-used in subsequent months. Thank you, Scott
  6. SpeedStick

    Comparing 2 Columns

    I have 2 columns that I am using to identify information (for over 14,000+ records). The first column is used to group the information by number. The second column shows different letters assigned to these numbers. Is there a formula that will allow me to identify a group like 655 and identify...
  7. SpeedStick

    Quering Email Address

    I am trying to develop a query which only pulls the domain name for email address. I want to only display the information between the @ symbol and .com for an email address. What is the best way to do that? I thought by putting this in the criteria section Like "@*", it would work. It does not.
  8. SpeedStick

    Embeded Picture

    I have an application that creates an email and sends it via outlook. How would a person embed a picture in an email to have it sent out. I am not at all fimiliar with handling images in Access. I am looking for idea on how to use images.
  9. SpeedStick

    Copy A Word Document File and Not Just Text File

    I am trying to modify the below code to allow me to copy files other than text files. I have been looking for an alternative to 'TextStream' but I have not been able to find one. Essentially, I would really like to copy Word Documents. Any assistance would be great. Public Function SendEMail()...
  10. SpeedStick

    New Record, text box appear

    I would like to have a text box appear each time a new record is added. I have form which is used to maintain the staff login page. We only want the password field to be visible only when a new employee is added. Below is the code I have been working on. I am really looking for the value to put...
  11. SpeedStick

    Read Only Privileges

    I have form that I want some users to have 'read only' privileges. I have table that defines which users have what privileges. Can someone help me develop the solution so that certain user have 'read only' privileges on a form?
  12. SpeedStick

    One to Many Report

    I have developed an Action Item database. In which, I have main table named Action Item, which has a primary key field named ActionItemID. I have second table (Tbl_Assigned) for individuals who will be assigned these action items. Since there can be more than one individual to an action item...
  13. SpeedStick

    Relating Forms

    I have a created 2 Forms in Access 2003. On the main form, I have check box and if the check box is checked, the 2nd form opens. Data is abled to be entered in the second form and captured in a table. I would like a person to re-enter the main form and if the check box is checked again, the...

Part and Inventory Search

Back
Top