Search results

Hi Mihail, I've created a Test database since the current one uses an ODBC connection. Anyway the input box when it pops up when you run the report is "Test". Thanks for looking into this.

i've tried where the height was less than 0.05 and that bottom section was still showing up :banghead:

I have a sub-report and the last row is highlight, however, there seems to be extra spacing after the last row. I removed all report/page header/footer so all what's left is the Detail section but I still have this white space after the last row. Does anybody know what could be causing this...

okay thanks I'll give that a shot

No it doesn't.

Thanks that worked beautifully. Now, I'm also trying to bold the text for that row. I tried If ... Then .Detail.BackColor = 1234567 .FontBold = True Else .Detail.BackColor = 2345679 End If But it was giving me an error.

Is there a way to only highlight the last row of the detail section in a report? I tried the following code in the "Format" but could not get it to work in Access 2010. If Me.ClaimStatuses = "Total Potential Recoverable" Then Me.Section(acDetail).BackColor = vbYellow Else...

as a work around, i just created an extra column in the query to retrieve the ID in combobox3. this column had a value of "YES" and is the only column displayed when the user goes in that drop down. When the user selects YES the ID value is activated and then populates the form. Somewhat of a...

hi jbb, i tried that and still same result, nothing getting returned. Also, I can't bound the combo box that i want to auto populate that will be hidden because it's a PK and an Autonumber field. When i did that I got an error message that says I can't bound on this field. It seems like the...

I have to make the text box and other combo boxes bound to a table field because the user needs to make updates on these records but I did try that and the form just displays blank fields. Below is the VB I have after each combo box is updated with a value and just to touch on my original...

I have 3 combo boxes, 2 of which the users will see so they can input 2 fields where combo box 1 is coming from the result from a hidden form while combo box 2 is coming from the line item result from combo box 1 and the 3rd combo will be used to query the form because it's the primary key in...

This is the first time I've had to deal with retrieving a record using two combo boxes. I got this to work in the first form where it's only one combo box using an embedded macro After Update and in that macro I have a "SearchForRecord" with a Where Condition that equals the record I want to...