Search results

  1. E

    Grouping and totals

    I'm very sorry - TrainListBICB is the report.
  2. E

    Grouping and totals

    Thank you! Attached is the whole database.
  3. E

    Grouping and totals

    I have Seq set to No for both Group Header and Group Footer, with Station set to No for Group Header and Yes for Group Footer. I then have the footer defined as a line of dashes. However, in the output, I get a line of dashes after EVERY entry, even when the Station value hasn't changed. That...
  4. E

    Grouping and totals

    Thanks. I tried that earlier, but because Seq has to be the first field in the sort hierarchy in order to keep the entries in Seq order, it treats each line as a new Group, printing a dashed line after each one (since Seq is different with each record). I'd like it to sort based on Seq alone...
  5. E

    Grouping and totals

    Thanks for your reply. Unfortunately, I don't think I understand what you mean. I'd like to sort strictly on the Seq field, which is visible. Entries for each Station ID will then be together in the report, such as the two Newton entries, or the three "IOWACIT" entires. So, I don't want to...
  6. E

    Grouping and totals

    Okay, apparently my friend's solution didn't resolve the problem after all. After further testing, I realized that his solution printed the records out of Seq order. To recap, I'm trying to create a report based on the format in the attached .zip file. Without getting into VB code, is there a...
  7. E

    Grouping and totals

    Thanks for the correction vbaInet. Different convention than what I'm used to on my hobby-related forums, so I appreciate you setting me straight. The dashed lines I'm referring to are those between each group of records in the attached document above, e.g. between "NEWTON" and "IOWACIT"...
  8. E

    Arrow up/down between records?

    I'm building my first Access form (attached), but haven't yet been able to determine if there's a way to use the arrow up/down keys to move between records/lines. As it stands now, the down arrow key behaves just like a tab, moving to the next field on the current record, and the up arrow...
  9. E

    Grouping and totals

    I'm attempting to create a railroad report using the format of the attached sample, and I've run into a few questions: 1. Without getting into VB code, is there a way to generate the dashed lines whenever the Station ID (e.g. "STU", "NEW", "IOW") changes, while maintaining the overall sort...
  10. E

    Simple text field comparison to blanks

    Yes, I meant characters and not bytes, thanks for the correction. I updated my post to clarify. I'm checking the field from a Module, and your code suggestion worked perfectly. Thank you!
  11. E

    Simple text field comparison to blanks

    I'm using Access and VB for the first time, trying to develop an application for hobby use. I built and populated my database, and I'm building my first module. Unfortunately, one of the most simple actions is tripping me up. I'm attempting to perform an action only if a 255-character text...
  12. E

    The newest of newbies

    I found this forum while Googling various errors I'm having in my first attempt at using VBA and one of my first attempts at Access. I'm trying to develop a fairly simple railroad traffic simulation application, and heard that Access would be a relatively easy way to do so. I'm looking forward...
Back
Top Bottom