Recent content by macattack

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?

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...

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...

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...

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!

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...

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...

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.

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...

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?

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...

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...

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.

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...

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