Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by colossalUW

  1. colossalUW

    CBO lookup field disappeared

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

    CBO lookup field disappeared

    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...
  3. colossalUW

    Nested SQL string to populate listbox

    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?
  4. colossalUW

    Nested SQL string to populate listbox

    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...
  5. colossalUW

    SQL string works, but not w/ ADO to open qry from frm

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

    SQL string works, but not w/ ADO to open qry from frm

    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...
  7. colossalUW

    Row Source: query and fixed value

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

    Row Source: query and fixed value

    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...
  9. colossalUW

    Pass Yes/No (checkbox) value to SQL statement

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

    Pass Yes/No (checkbox) value to SQL statement

    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...
  11. colossalUW

    DAO.Recordset copy to second recordset

    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.
  12. colossalUW

    DAO.Recordset copy to second recordset

    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...
  13. colossalUW

    DAO.Recordset copy to second recordset

    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...
  14. colossalUW

    List box display data

    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...
  15. colossalUW

    List box display data

    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...
See more

Part and Inventory Search

Back
Top