Recent content by redbe4rd

I've tried using sub-forms, but it won't let me display the main form in Continuous Form mode, so it limits me to viewing one system at a time.

I got my report looking proper using the grouping like plog suggested. Is there any way to accomplish this same feat on a form? :D Personally, it doesn't bother me having the system repeated on every line when viewing it on a form, but for aesthetic purposes, they'd prefer it not. If...

Hello all, I have a table of items for our companies quotes. When we go to print out our quotes to send to the customers, the salespeople would like most of the items to be grouped under certain "headers" for the systems they are part of. Ex: Autopilot System Part #1 Qty 2 Part #2 Qty 1...

I apologize in advance if this has already been posted/solved. I wasn't quite sure what to search for when googling this and searching these forums. Scenario: I have an Access 2007 database for keeping track of quotes/projects/inventory. The user receives an RFQ (request for quote) and enters...

Hi all, I have a quick (hopefully easy) problem for you today. I have an options screen for a report in my current Access project that asks the user for a starting date and a duration. My starting date field is to be inputted as "mm/yy" (ex. 11/12) for ease of use. When reading this as a...

But but but...I want it noooowwww! That makes sense now that I think about it. It has no problem using the first letter typed when I'm doing a search through our projects (less than 100 entries), but has the delay when I'm searching through our items (over 17,000 entries). Thank you again!

I still get a strange filter delay when I input the very first letter on a new form. Ex: I goto type "Furuno" in the Vendor search box, and the initial "F" doesn't filter all the vendors with an "F", but after "Fu" has been inputted, it filters correctly. Nothing major or project-breaking...

First off, I apologize for the delayed response. I moved on to another part of this project after hitting the snag and have been out of the office quite a bit since then. After returning to this problem (and frankly, I was completely ready to remove all auto-search functionality and just have...

Private Sub txtVendor_Change() Me.Filter = _ "((strSearchVendor Like '*" & Me.txtVendor.Text & "*' AND strSearchItem LIKE '*" & Me.txtPartNum & "*'))" Me.FilterOn = True Me.txtVendor.SelStart = Len(Me.txtVendor.Value) End Sub Private Sub txtPartNum_Change() Me.Filter = _...

Moving the FilterOn statement to after I set the Filter hasn't had any noticeable effect. The thing that confuses me is that it works flawlessly until I enter text in one of the textboxes that causes it to Filter to 0 results. Does it force focus to the table at this point? I've even tried...

Before I had the Me.txtVendor.SelStart line in there, it would select the entire contents of the textbox when it ran the filter. Since I'm filtering with every change of the text, it would auto-select the entire text and the user would continue typing, overwriting what was already in the box...

I've searched through the forums for posts regarding Error '2185' (You can't reference a property or method for a control unless the control has the focus.), but can't find anything so far that has helped my situation. Situation: I'm creating an item look-up form with 2 criteria that I wan't...