Search results

Would it be easier to send you a copy of the file? It's not a very big database, if you'd have time to look at it.

It's filtering on the main form. My form filter ended up looking like this: [job]= '

Here's what I've got in there, I copy-pasted. I'm getting an error saying I'm missing an operator. Can you find it? Private Sub cboJob_AfterUpdate() Me.Filter = "[job] = " & "'" & [cboJob].Column(1) & "'" Me.FilterOn = True End Sub

Something's not right, the combo box still stops working after I show all the records.

You're a popular guy! Could I get a copy of the code, too?

Thanks, but could you be more specific? I pretty much have to follow examples. How do I set the filter before the ApplyFilter?

I have a combo box on a form that I use to filter the records. It's set up using ApplyFilter in a macro in the AfterUpdate property of the box, and the Filter property of the form itself is set to match what's in the box. My problem is that it works fine until the filter is removed to see all...

How do I requery the page?

My form with a header and a tab control always opens slightly down from the top so that the tabs don't show. You have to use the scroll bar to see them. What's causing this? If I can get it to open right, I can get rid of the vertical scroll bar and have a little more room on the screen.

How do I requery the page?

I have two subforms on separate pages of a tab control. They both contain information about the same records, there were just too many to put on one page. I'm linked OK to the main form, but what I need is for the two tabbed pages to show the same records. If I've had to scroll down the page on...

The postings I've tried to follow haven't worked, here's my scenario. I'm using Access 2000, if that makes a difference. I have a bound list box with job numbers in it. It's set to limit to list. I need to be able to add a new job number to the list AND the underlying table, and have it show up...

How do I do that?

I have two tables. One has Job Number, County, Route. The other has Job Number, Cost. They are linked on the Job Number. On my form, I want to enter a Job number and have the County, Route display automatically from the table. Currently, the County,Rte data isn't displaying until after I close...

I have a combo box which is used to enter new data. However, sometimes the user accidentally changes data, when what they meant to do is filter by form. What's the best way avoid this and still be able to enter new data in the combo box? I've tried using a separate unbound combo, but it doesn't...

That worked great! Thanks a bunch.

That made it fit, is there a way to use that automatically when the report opens?

How can I make a report fill all of the available screen area? Maximizing doesn't work, there's always a gray border to the left and top. The report is on ledger paper, so I need to use every bit of screen space I can.

Thanks for the reply! While I was waiting, I made some design changes to my report, and when I tried the filter this morning, it worked! I don't know what fixed it, must have been something in my report. At least you learned something out of it, though, so it wasn't a total waste of time.

I have a report based on a table, not a query.I need a dialog box to filter it from. I found an example in the Developer's handbook, but can't get it to work for more than the first selection. Could someone check this to see what's wrong? I'm using 2000. Private Sub cmdPreview_Click() Dim...