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: *

  • Users: dhrehor
  • Content: Threads
  • Order by date
  1. dhrehor

    Assign Label Text from Variable

    Wondering how I do this. I have a SQL query that pulls three fields from the database. SELECT quarter, startdate, enddate from quarters this then populates a drop down box with the quarter. I want to put two labels next to the drop down and have the text of the two labels populate from the...
  2. dhrehor

    VWD - ASP 2.0 - Database Connections

    Wondering if anyone can tell me (a newbie) how to connect to a SQL database and pull fields and assign them to variables. A sample script would be sufficient. Here some sample data: Database Fields: LastName, FirstName, MiddleName Variables: varLastName, varFirstName, varMiddleName I...
  3. dhrehor

    ASP SQL Statement Error

    Here is what I am trying to run SELECT quarter, startdate, enddate, requiredquarterhours AS quarter, startdate, enddate, requiredquarterhours FROM quarters WHERE quarter = DropDownList2.DataValueField I get an error stating that DropDownList2.DataValueField cannot be bound. I have also...
  4. dhrehor

    Need to Combind two fields into one drop down

    Sorry for the newbie question, but I am just getting started. I have a drop down list that I am trying to populate with data from two fields. If in the dataTextField, I populate lastname, the drop down works fine and populates the lastname field in the drop down. What I want is to do a...
  5. dhrehor

    Reference Book

    Just learning Visual Basic . NET via Visual Studio 2003. Wondering if anyone has a suggestion for a complete reference book / manual and I can put on my shelf. Looking for a book with "Everything I ever wanted to know." not a book I would read cover to cover. Just want to look in it to find...
  6. dhrehor

    Create Thumbnail from HTML File

    Wondering if anyone knows an easy way to generate thumbnail pics (jpeg or gif) from an HTML file. Prefer to be able to do this in bulk on a local machine. In other words, I have a directoy on my local drive with about 50 html files. If I click on one it will launch IE and show the web page in...
  7. dhrehor

    Excel Macro - Fill in Field

    I am trying to create a macro to do the following on an Excel Spreadsheet On Page 2 would be a permanent list of two Columns Client ID Client Name On page 1 I would like to be able to type or paste a client ID in one column and then have it autopopulate the column after it with the...
  8. dhrehor

    Export Script (Query) for MS Access

    ignorant question, but is there a way to automate the export of a table either via command line or via a query (SQL)? I currently have several queries in a macro. At the end of the macro, I would like to export a table in comma delimited format with the field names as the first record. thanks...
  9. dhrehor

    Combind Tables in Access Based on Conditions

    I have come up with the following Script (It does not work) INSERT INTO Table_1 ( item1, item2, item3, item4, condition_a, item5, item6 ) SELECT Table_2.item1, Table_2.item2, Table_2.item3, Table_2.item4, Table_2.condition_b, Table_2.item5, Table_2.item6 FROM Table_2; Where table_1.item1 =...
  10. dhrehor

    Access Substring Command ?

    Need to truncate a field. Here is what I have: update PARTS set weight = substring(weight,1, charindex(' ',weight)) Original Field is : 5.36 lbs Need to make it: 5.36 Need this done throughout the table PARTS. Thanks Don

Part and Inventory Search

Back
Top