Search results for query: *

Wow, nice work! That was exactly the problem. I removed the > forcing the capitalization. Thanks also for the link. Cheers!

Hi all, This is a strange issue that I'm not sure how to being troubleshooting. I have a grant tracking application that has been successfully running on an XP machine for several months. I noticed recently that two of my forms are now not working properly. One form is a standard...

Thanks for the reply, PHV. I still get the error message: "Microsoft Access can't find the field '|' referred to in your expression". Any thoughts?

Hi all, On my form frmParView, I want to view the parents' last and first names in a listbox for the student shown at the top of the form. Since there can be multiple parents for each student, and multiple students for each parent, my tblStudents and tblParents are linked by tblLinks. Table...

You nailed it, Roy. The brackets solved the problem. I did not know 'Section' was reserved. Thanks!

Hi all, I have a form with which the user can build a query by selecting criteria from various list boxes and AND/OR conditions with radio buttons. Upon clicking OK, the query opens. Also, the user can click to export to Excel. This works great. I use the parent table Grants and several linked...

Thanks PHV and AceMan! I ended up creating a union query and setting it as the Row Source - works great.

Hi all, I can't seem to figure this out or find a thread on it... Is there a way to have a combo box row source based on a query AND have a fixed value? For instance, I want the first selection choice in the combo box to be "UNKNOWN", and every subsequent choice to come from a query...

Ah, yes, I'm slapping my forehead now. Thanks for the tip, PH!

Hey gang, This one is driving me nuts and I'm having no luck searching the forums. I have a basic search form containing combo boxes and check boxes. The user selects criteria from these, clicks the Search button, and the query results appear in a list box. Passing variables for the combo box...

Zion7, you hit the nail on the head! Changed the syntax and now it works great. Star for you. Thanks to all for the help.

Hi, Thanks for the response. I removed dbOpenDynaset but received the same error. It seems like it's not finding the records in tblCostsProposed, but they are there. Hmmm...

Hi there, Access 2000 project I've tried several iterations of this code (with the help of archived threads), and just can't quite get it to work. I'm attempting to copy the data from one subform to another if the user chooses yes from a message box. Basically, the first subform displays...

Hey AceMan, You're right, the name is not the result of data entry. Actually, I didn't concatenate the fields, either - I display them in the combo box in two columns: LastName and FirstName, but thanks for the idea to concatenate in the list box! And thanks for the solution of adding the...

Hi John, There are 3 columns in the list box: GC1#, PI, and Type. The bound column is currently the leftmost column, which is GC1#. I think I see what you're getting at. If I make the PI ID the bound column, though, I still get the ID displayed and not the name -- I assume b/c the name isn't...

Hello, I've created a form to search for a particular grant proposal. The form contains several combo boxes (for grant number, PI ID, and Type) with which the user can narrow the search. A list box (lstSearch) appears at the bottom which displays the search results after "OK" is clicked. My...