Recent content by Megawisdumb

  1. M

    Relation based counter

    DCount? I'm uncertain how the Dcount feature would assign a value to the records under the first CLP. I was thinking some type of loop would be needed (failed example attempt below). The key relation is that the 1st Seg field that has a CLP record gets a value that continues until the next...
  2. M

    Relation based counter

    Below is the final 3 column output I need in a query or table. The source is a query with the [ID] and [seg] fields only. The relation field is simply the count of the "CLP" seg until another "CLP" seg is encountered. My question is can this be done within a standard query or is recordset...
  3. M

    Loop Query Question

    I’ve got a basic access loop question. I tried various recordsets that start with the CLP segment and pull all the data until the next CLP segment into a single record line to no avail. From the example below, I want the data from row 19,22 & 23 on the same line and then move to the next CLP. Is...
  4. M

    Import Delimited HIPAA 997 X12

    Word I thought that would be the answer. It's odd though as this x12 format is used world wide. If I open the file in Word first and find ~ and replace with section breaks and save them import into access it works just fine. Do you know any way to replicate the find and replace functionality...
  5. M

    Import Delimited HIPAA 997 X12

    Column vs Row This is exactly what I need to automate the process. THANKS! However, I still can't seem to figure out how to get the ~ delimited data to populate the rows rather than columns. Every option I attempt on the import populates the columns instead of rows. What am I missing?
  6. M

    Import Delimited HIPAA 997 X12

    I've written a small DB to read an EDI X12 997 functional acknowledgment but can't get the import to work properly with the ~ delimiter. It loads it across the columns rather than in rows. Any advice would be greatly appreciated! phil
  7. M

    Like Statement in Join

    I'm attempting to left join two queries in which 4 characters of one field (entire field) match the other query. However, the other queries field has a string of 8-20 characters. The 4 digits could be anywhere in the string but they are consecutive. I thought about using a like statement but...
  8. M

    Hangs on Table open in Access 2002 only

    Odd situation. I have a table in my DB that hangs the Access application when opened with Access 2002 w/Win2000 or Server 2000 but works just fine with Access 2003 w/Win XP. Any thoughts? Thanks :eek:
  9. M

    Validation on another Form Field

    Why Java? I am open to any script as long as it performs! Frontpage2003 does not have any contingent field validation built in so I figured Java was probably the easiest way to go. What would you suggest?
  10. M

    Validation on another Form Field

    Trying to get validation from one field on a form to another (i.e. If field "PAFType"=3 then require field "Cdate" to be populated). However, I can't seem to find the right code combo to set the required flag. Any help is very much appreicated! Below is my latest attempt. phil <Head>...
  11. M

    Calendar Control ADO Problem

    I've added a Calendar Control 11 into a Frontpage 2003 form that drops into an Access 2002 table. All the other data elements make it over except the Calendar Control object. Below is the code. I want it to pass "MM/DD/YYYY" format but I get nothing. Anyone know what I'm missing? This is...
  12. M

    Limit to last record w/Edit

    YES! Works great! This was one of those easy sounding tasks that seemed to have difficult approach. Thanks for your assistance!
  13. M

    Limit to last record w/Edit

    Anyone know a way to limit a query to a single record (last/first) and maintain the ability to edit a yes/no field with the query?? Sounds simple but I can't figure this one out.
  14. M

    Send Object Report ???

    Anyone know a method to generate a report utilizing the docmd.Send Object method that will filter for current record only? I have an auto email script where each records gets an email with a report of their data only.
  15. M

    Single Record to Email from Form

    So my Set recSupps reference would point to the form? Me.frmOpen ??
See more
Back
Top Bottom