Search results

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.

Ok, so I found a way to cheat. Apparently .value doesn't require a focus. If Forms!LRUChoices!Number.Value = 1 Then RecordSource = "AFT" with my hidden textbox on the first form yields the results I need. Been at this issue for days...On to the next one!:D

This makes absolutely no sense to me and is why I was trying my unorthodox method. Sub Button_Click() DoCmd.OpenForm "LRU Data", acNormal, , , acFormAdd, acWindowNormal, "Number" Private Sub Form_Load() Dim strNumbers As String strNumbers = Forms!LRUChoices.Number.Text.OpenArgs If...

I'm rather new to Access and I've been trying to get something to work and countless searches have provided nothing that I can use. I'm trying to set buttons as numbers on one form and then checking another form to see if those buttons were pressed so it will set RecordSource. Button Form...

:) Got it working now with: Private Sub CIU_Click() DoCmd.OpenForm "AFT", acNormal, , , acFormAdd Forms!AFT.RecordSource = "CIU" DoCmd.Close acForm, "LRU Choices" I just have to do that for each button. One table scares me, so for now I'll stick with individual tables, but I thank you for...

I coppied all the buttons to the new form and it was still bugged. I ended up deleting all code (to include subs with nothing in them) and then put in DoCmd.OpenForm "AFT" for onClick and it works now. I guess the button became corrupt. Thanks for your help/suggestions!