Recent content by macattack

  1. M

    Can't use Find or Replace now.

    Ok, the true source of the issue (since it reared its head again): To many characters on a report?!? When I went and deleted my "stress test" entries in the database I am able to search just fine. Is there some way to deal with acCmdFind not liking too many characters on a report?
  2. M

    Can't use Find or Replace now.

    I am having a hard time figuring this one out. I created a button on my report to search through the report and it worked fine. I made a boatload of changes and now I can't get it to work. I have no clue why, as there were no changes to the report that I can remember (other than making the...
  3. M

    Novice Report question

    I appreciate the example but I don't think I explained what I was trying to do well enough. I need all records to show on one page (without cycling). I played with it for a few more hours and got most of what I wanted. I'm able to query with all my search criteria except the "By Word", having...
  4. M

    Novice Report question

    Hi guys, I'm trying to make a report and I'm pretty much totally lost. I have multiple records I would like to show on a report. I have created a form to enable options (date range, serial number, word search). Given the options available, the number of records will be variable. If someone can...
  5. M

    3rd combo box

    I had to change the bound column to "2" for whatever reason. When I would make the textbox = .Column(#) it would only show the first column and only when the # was a -1 (no other negative or positive numbers worked). Regardless, working now, thanks!
  6. M

    3rd combo box

    I tried to throw in the ID and tried columns 0-6 and couldn't get it to show. on cmbJCN change: Me.txtID.Value = Me.cmbJCN.Column(0) This doesn't even show the value from JCN (regardless of the number I try). row source: SELECT ATU.JCN, ATU.JCN FROM ATU WHERE (((ATU.[Serial...
  7. M

    3rd combo box

    Simple issue but I have spent hours and hours trying to find the answer and I have come up empty-handed. I need the 3rd combo box to be cascaded off the 2nd. The 3rd is to display the ID based off what the 2nd combo box is. For some reason when I copy the steps I took to cascade the 2nd and...
  8. M

    cascade combo boxes with duplicate values

    EDIT: FIXED "where" option field had to be changed. I had to do a me.requery on change rather than afterupdate, don't know why.
  9. M

    cascade combo boxes with duplicate values

    Parts come into my shop and we repair them. They are tracked serially (for history purposes) and via another generated code (JCN, it is based on a date/time). People must be able to enter that data into the system and detail what is accomplished to fix the part. It is necessary to revisit these...
  10. M

    cascade combo boxes with duplicate values

    Those two videos showcase exactly what I want to do but I can't get it to work haha. I deleted my combo boxes, made new ones and followed his instructions, doesn't work. Is there a table setting that must be set that he doesn't explain?
  11. M

    cascade combo boxes with duplicate values

    I threw in a picture to help illustrate what I'm trying to do. Once JCN is selected a 3rd combo box will be introduced (hidden) that will be linked to the ID. The ID will then be used to edit data (or so I hope). I'm probably over-complicating this so if anyone has ideas of how to make this...
  12. M

    cascade combo boxes with duplicate values

    Hi guys! I'm trying to Identify a particular entry in my table for editing via combo boxes. The same serial number will come in multiple times but a different job number each time it comes in. To identify a record for editing I need the user to identify the serial number in combo1 and then the...
  13. M

    Unique values in a combo box

    Ok, I'm rather confused by the fix I just luckily guessed. The solution was to have two Serial # fields and to turn unique on.
  14. M

    Unique values in a combo box

    I'm fairly new to Access and I've been at this for quite a while now and can't figure out how to make only unique values show in my combo box. In the picture I show lots of "1"s. If I move "ID" to the right of Serial # and select unique values, it removes duplicates entirely (meaning there are...
  15. M

    Unorthodox Routing

    Thanks, going to read through this to get a better understanding of it.
Back
Top Bottom