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 strongm 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 vanlanjl

  1. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    the pass-through query you provided does not work. Also the ADP format is supported as instructed in MSDN for Access 2007. I think this is becoming more complicated then it needs to be. I just twant the user to be able to search for one deviceName and be able to edit the AttributeName and...
  2. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    yea as stated in the original post this is an access .adp database, meaning it is linked to a SQL server database
  3. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    Okay i changed it to continuous and now when i make a selection form the combobox it will show all 7062 records. this defeats the whole purpose on making it so the user does have to search through all the reords to find one
  4. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    it is not contious it will show only one record at a time depending on the selection in the combobox
  5. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    i tried that and i get the error: invalid column name ": " I stated that in the above post
  6. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    the combobox is unbound. I have no idea what you mean by coninous or single
  7. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    Subforms are sloppy and confuse users. i just need a form wher the user can look up the device by the device name and the edit the attributeName and the AttributeValue Sometimes we may swap a network device and the ip address will change or the serila number etc. Or maybe we add a new type of...
  8. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    why would I want a subform? the form is very basic it has a combo box at the top and three text boxes. The combobox selection should populate the text boxes I dont want a subform
  9. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    maybe it needs some way to requery when selecting again?
  10. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    i meant " invalid column name ":
  11. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    sorry - i thought you said "bound column" invalid at ":
  12. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    I just want help with the question I had please. If anyone can help much appreciated.
  13. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    Bound column is set to one. I want to use the combobox to search for the appropiate device I have over ten thousand records in here, if i did a form and subform it would never load.
  14. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    I dont know VBA, usally people on here help me with that
  15. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    My problem is that i have a combobox that displays two fileds, when selecting it will populate the data in the text boxes. Before I explain my problem though you may need to understand my database. Also i am building the frontend in Acess 2007, the backend is already built in SQL Server, the SQL...
See more

Part and Inventory Search

Back
Top