Search results

  1. 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...
  2. 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...
  3. 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
  4. 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...
  5. 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:
  6. 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>...
  7. 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...
  8. 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.
  9. 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.
  10. M

    Single Record to Email from Form

    Not having much luck taking a few fields from the record displayed in my form to an email with a command button. No attachments needed, just some basic text although with a couple of data fields from the form. I did get it to pull the first record by using the following: Function Email() Dim...
Back
Top Bottom