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!

Register Log in
  • Congratulations Rhinorhino 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: Kim296
  • Content: Threads
  • Order by date
  1. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I really need some help from a genius. I'm working on a dynamic excel spreadsheet. There are over 1,500 columns with list data below each one. Does anyone know how I can dynamically find two or more like values that appear in any of the 1,500 columns. I don't just want to highlight duplicates. I...
  2. Kim296

    Sending Gmail using vba Send error

    Good Morning, I have been trying to figure out how to send gmail using vba in Microsoft Access. I feel like the below code is correct as it's the same on every tutorial, instructions and research blog that I've found over the past week. I feel like I'm missing something else that I should be...
  3. Kim296

    FILTER SUBFORM USING MAIN FORM FIELDS- VBA

    Hi everyone, I have tried researching this and watching videos for a week now, but my brain hasn't been able figure this out to save me. Any help is appreciated. I have a simple program that will be designed for keeping up with documentation on employees (tardiness, verbal warnings, recognition...
  4. Kim296

    SUBTRACT PREVIOUS DATE FIELD FROM CURRENT DATE FIELD

    Good Afternoon Everyone, I'm using a query with a lot of calculated fields. The stumper for me is how to calculate a date difference between the current record date and the previous record date within the same record set. query name: qryProjectionEventsAll record set: PROJID (Linked to Main...
  5. Kim296

    Send to Back

    Good Afternoon Everyone, I have a form which includes an image to appear behind lines that I drew for a chart (x and y coordinates). I can manually set the image behind the drawn x and y lines, but I can't figure out a way to automatically send the image to the back after an image is added. The...
  6. Kim296

    FORM CHARTS

    RE: ACCESS FORM Is it possible to base a chart strictly on unbound form fields? I've created a form template which allows simple calculations, using (2 columns with 12 rows) equating to 24 unbound fields, that I wish to chart. The unbound field calculations work perfectly; however, I'm unable...
  7. Kim296

    Calculating Date Diff for timestamps in same field

    Hi Everyone, How do I calculate the time difference between two date/time timestamps that are in the same field, but use different codes. The fields are linked by the same event number. For example: EMS arrived at the hospital (incilog.transcode= "H") at 02/28/2017 15:00 (incilog.timestamp...
  8. Kim296

    Query Expression Help

    I'm trying to create a formulated field that will display the record delivery status, so that I can filter the status for reporting. This formula appears to be working as I'm creating it in the expression builder; however, when I go to the datasheet view it shows "#error". Can anyone see what I...
  9. Kim296

    CONCATENATE GROUP RECORDS

    I found two formula's that allow you to concatenate detail records and I tried using it on group records and it works... Except it doesn't reset for new records; it just continues for ALL records. When using this to concatenate group records, does anyone know how I can reset it to start over on...
  10. Kim296

    loop

    Can anyone tell me the right way to make the following loop through multiple search words. (Ex. Search1, Search2, Search3, etc.) Right now, it will only search the text using 1 search word. Shared StringVar SearchText := {@SEARCH1} ; StringVar Htm1 := "<font color=#FF0066>"; StringVar Htm2 :=...
  11. Kim296

    change EXCEL emailed spreadsheet

    I have received an excel spreadsheet that someone converted over from another program. It contains information for one person in multiple columns and rows. I would like to convert this to show only one persons information in one row, so that I can sort and filter the information. Does anyone...
  12. Kim296

    Search Unrelated tables

    This is just a curiosity question for anyone who has time. We have a huge database with hundreds of different available tables. For example: Incident Reports Table Arrest Table Accident Table Field Contact Table Citations Table Each table has hundreds of availabe fields to use in an...
  13. Kim296

    SAME RECORD QUESTION

    I work for a jail and I am trying to create Superior Court List and State Court List from our Record Management System, but I can't quite figure out how to word my formula to make it pull correctly. For example: Each arrest has a unique system id (armain.armainid) that can contain multiple...
  14. Kim296

    Menu Navigation

    Somehow, I have removed my menu navigation bar from across the top of my program (file, edit, view, etc...). I can't figure out how to get it back. Any suggestions. Thanks, Kim
  15. Kim296

    OLE Object

    I have an OLE object in the details section of my report; the report returns all of the correct information. It filters out the last two pictures (OLE Objects) associated with the file name. The overall report returns good; however, just for appearance and space purposes. Does anyone know how...
  16. Kim296

    DATA BASE FIELD LINKS

    If anyone can help with this problem, it is very appreciated. I am using 2 tables in my report: nmmain (the master name table) syinvl (system involvements) I have all of the nmmain fields in the header; this is the most current information (name, address, phone, etc..) Then I have the...
  17. Kim296

    ODBC Connection

    In the past, a blank report could be created by selecting "ODBC", choose the Data Source Name, click finish and you would automatically have the tables to choose from. Recently our IT Department moved all of the database information from one server to a completely new server. Now, when you...
  18. Kim296

    Conditional Count ??

    Group 1 header: {lwmain.caseid},{lwmain.reportdate},{lwmain.casedescription} Details Section: {lwcase.status},{lwcase.statusdate} I would like to conditionally count {lwmain.caseid} based on criteria from {lwcase.status}. For example: There is only 1 Case Number {lwmain.caseid}; however, it...
  19. Kim296

    Add multiple search words

    I asked a previous question about highlighting search words using a parameter search word. I was able to find the following code which works perfectly for highlighting my parameter search word as a formula ({@SEARCH1}), but I have 10 parameter search words that I've converted to formula's...
  20. Kim296

    HIGHLIGHT SEARCH WORDS

    I would like to know if anyone else has figured out a good way to highlight "search words" in their reports. I am using Crystal Reports XI. I had to convert my notes section into a string. The following is how I find reports with the desired information: IF INSTR (UPPERCASE({@NOTES})...

Part and Inventory Search

Back
Top