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 Chriss Miller 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 bsawers

  1. bsawers

    Updating MS Access with User Input

    One quick question, for my combo box the row source is: SELECT Min(MSLINK),IDSTD FROM STNDAREA GROUP BY IDSTD; Is there any way I can order them further? Perhaps sort by Ascending or Decending so when the user drops down the list the values are not only grouped but sorted as well. thanks
  2. bsawers

    Updating MS Access with User Input

    Just to gain a better understanding, what is the significance of .Column(1)?
  3. bsawers

    Updating MS Access with User Input

    I was quoted earlier as saying "it doesnt have to update more than one record at a time". My supervisor now wants all like values ie. (all L1 values in the IDLIN column) that when selected will update all corresponsing values in the WINGSPAN_ID column. For example: IDLIN WINGSPAN_ID L1...
  4. bsawers

    Updating MS Access with User Input

    Now I have a combo box in a form which displays unique values from field IDLIN. I also have a textbox on the form which is bound to the column WINGSPAN_ID and when a value is selected in the combo box (lets say L1 is selected) the corresponding value in WINGSPAN_ID is displayed in the text...
  5. bsawers

    Updating MS Access with User Input

    Yes it works...Thanks alot! :)
  6. bsawers

    Updating MS Access with User Input

    Row Source: SELECT DISTINCT [TXILINE].[MSLINK], [TXILINE].[IDLIN] FROM [TXILINE]; Bound Column: 1 Column Count: 2 Column Widths: 0";1
  7. bsawers

    Updating MS Access with User Input

    When I use SELECT DISTINCT IDLIN FROM TXILINE; it populates the combo box with no values...It appears that I need the MSLINK field in my query for any values to populate my combo box...it must be noted that MSLINK field contains only unique values...When I use SELECT DISTINCT...
  8. bsawers

    Updating MS Access with User Input

    When I do that it says I'm missing the MSLINK...
  9. bsawers

    Updating MS Access with User Input

    Its SELECT DISTINCT [TXILINE].[MSLINK], [TXILINE].[IDLIN] FROM [TXILINE]; The combo box drop down allows me to view and select all values from the IDLIN field within the TXILINE table, but they aren't distinc values.
  10. bsawers

    Updating MS Access with User Input

    Thanks for the help...It seems to be working but the one last thing I would like would be to group the values in the combo box drop down list so that they dont repeat...For example I dont want L1, L1, L1, L1, but rather grouping them together...Saying that, when I right click the combo box and...
  11. bsawers

    Updating MS Access with User Input

    Hi dhookom I added a combo box to my form which is linked to the Field IDLIN from the table TXILINE. The combo box now displays all the data from the field IDLIN from table TXILINE. After that I created a textbox and bound that textbox to the field IDLIN from the table TXILINE. Now when I run...
  12. bsawers

    Updating MS Access with User Input

    Thanks for the reply I figured a form would work best...The problem is I don't know how to code the form as my programming abilities are tepid at best...but I do know how to design the form. Do you have any example code which I could utilize or at least, point me in the right direction? To...
  13. bsawers

    Updating MS Access with User Input

    For further info. I was trying to use the update query. Heres my SQL UPDATE TXILINE SET TXILINE.WINGSPAN_FT = [Enter new WINGSPAN:] WHERE (((TXILINE.IDLIN)=[Select* From IDLIN]));
  14. bsawers

    Updating MS Access with User Input

    Hi, I'm new to Access, databases, and this forum. I have a table called STNLINE with 2 fields, IDSTD and WINGSPAN_FT. I want the user to be able to update the field WINGSPAN_FT with whatever value they wish based on the value in the field IDSTD...Whats the easiest way I can do this?
See more

Part and Inventory Search

Back
Top