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!

Search results for query: *

  1. f5snopro

    Default view in word 2003

    In Word... 1. Click the "Tools" menu and choose "Options". 2. When the "Options" multi-tabbed dialog box appears, click "General". 3. Uncheck "Allow starting in Reading Layout".
  2. f5snopro

    Copy MS Project Data into Excel

    Hello, I'm looking to write some code to automatically copy MS Project data into an Excel spreadsheet. I'm doing this so that all I need to do is grab an updated copy of the project and it will update the data and charts in my Excel spreadsheet. Having a bit of a difficult time. This is what I...
  3. f5snopro

    Joining Tables Based on a STRING

    Well then...I probably have my syntax wrong. SELECT IWA.*, Servers.* FROM Servers LEFT JOIN IWA ON Servers.Server LIKE "*IWA.[Production Servers]*";
  4. f5snopro

    Joining Tables Based on a STRING

    I have a table with server ID's...I want to join it to a table containing applications. This application table has a string field with servers. How can I say "Give me the server information from Table #1 and the application information from Table #2 where the server ID is listed in the...
  5. f5snopro

    Find a value in a field with a string

    So simple! I let it pass right by me. Thanks for setting me straight.
  6. f5snopro

    Find a value in a field with a string

    I'm trying to search a field in access that contains server hostnames. For instance, I want to find av3300. A string might have av5500,cad1100,av3300,test1213. I want that application information returned if the av3300 is found. Ultimately I'm goning to take a list of servers I have, compare it...
  7. f5snopro

    Combining Tables

    I see what you're saying, but what I'd like to do is take say Table A and combine it with Table B. Table A might not have a Make listed whereas Table B does. Table A's data is otherwise complete and reliable. I just need to append Table B's model listing. Is this possible?
  8. f5snopro

    Combining Tables

    I have 17 tables all with server related data (Make, Model, utilization, etc.) There are duplicate fields across all the tables (i.e. Table1 has Make, Table2 has make). I want to create a query that builds a new table by combining the info of all 17. The catch is, I want to be able to rank the...
  9. f5snopro

    Queries with Null Values

    Actually...it goes beyond the Null issue. I have the two tables linked by Application ID. IF the main table has an application id but the attribute table doesn't have a matching ID, the record for that application will not be returned. I want it to return the application info and if it doesn't...
  10. f5snopro

    Queries with Null Values

    I have a database containing 3 tables. If I run a query calling for values from all of the three tables, the only recordset which is built is that of items with values in ALL 3 tables. For instance, if my attributes table doesn't display a value for languages on application ID # 1234, 1234 will...
  11. f5snopro

    Listbox Value as Query Parameter

    Got it! Thanks!
  12. f5snopro

    Dynamically Switching Between Record Sets

    Works wonderfully! Thanks!
  13. f5snopro

    Dynamically Switching Between Record Sets

    I have a form (frm_Main_Form) which can be called up one of two ways, either by imputting a value into a form (frm_By_ITMS_Number) for the ITMS number or by Selecting the person on a separate form (frm_choose_user). Both should call up (frm_Main_Form). Each have corresponding, predefined queries...
  14. f5snopro

    Form Checkboxes

    There has got to be a better way to do this...What a hassle to bind it to a textbox to "interpret" it. No doubt it will work, but does anyone know of a better way? Maybe a script or something I could run on the table to convert all the -1's to 1's? I'm going to use this data piped to...
  15. f5snopro

    Building a Listbox from a field in a table

    Got it working! Thanks so much!
  16. f5snopro

    Building a Listbox from a field in a table

    I have a form (frm_choose_owner) with a listbox which I would like to dynamically build based on the values in a specific field in a table (tbl_ITMS_dump)I have. Trick is, I don't want duplicates in the listbox. The values dynamically added to the list box will allow the user to select on and...
  17. f5snopro

    Listbox Value as Query Parameter

    How can I set a value from a listbox as a parameter in a query?
  18. f5snopro

    Linking Tables

    I'm currently working on a form which has two tabs...The form opens using a query which asks for an application ID. The information gathered through the query for that ID is displayed on the first page. The second tab has 4 subtabs underneath it. Each have different attributes about the...
  19. f5snopro

    Form Tab Controls

    I figured it out! Woo hoo! Thanks for your help.
  20. f5snopro

    Form Checkboxes

    How can I get a form check box to input values into a table as 0's and 1's instead of 0's and -1's?

Part and Inventory Search

Back
Top