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!

  • Congratulations strongm 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. SHAWTY721

    Send ASP Form fields to Access Database

    Hi I have a html form that I am calling an asp form from and I can't get the fields into the database. I'm not sure if I'm missing part of the needed code. <% @ Language="VBScript"%> <% ' Declaring variables Dim PlayerName, BDate, Grade, Address, City, Zip, Email, School, District, HPhone...
  2. SHAWTY721

    Exporting listbox fields to csv file

    How exactly do I initialize Element.
  3. SHAWTY721

    Exporting listbox fields to csv file

    I am working on a VB6 project and I am trying to export fields from a listbox into a csv file. I can get the titles to export but none of the actual content from the listbox is being exported to the newly created csv file. Is there something missing in my code that can is suppose to be there to...
  4. SHAWTY721

    Parent &amp; Child Forms

    I am creating an windows application using vb.net 2005, and I have a parent form which I want to be able to load various child forms onto depending on which one the user selects. I have the form created and the child forms created and they display on the parent form. I am running into an issue...
  5. SHAWTY721

    String Handling

    I am working in VB6 I have a form that contains a text box and I need to see if the user has ended the entry with a "\" and if not I will need to add it to the end of the users entry into the text box programmatically. I am wondering how this can be done, I am attempting to use the Right...
  6. SHAWTY721

    Resize forms and controls based on screen resolution

    I have a vb6 application where I am trying to change the form size and the form controls based on the users screen resolution. I have gotten the size of the form to change based on the screen resolution but the controls are staying the same size. Can anyone help me figure this out. Here is what...
  7. SHAWTY721

    combining two excel spreadsheets based on Codes Matching

    Okay I have created a VLookup but it is returning a value of '#N/A' even for the ones that should list a value. Here is what my VLookup looks like: "=VLOOKUP(B2,PRICING,9,FALSE)", Where Pricing is a cell reference to the sheet that I am trying to use the VLookup to find the values that...
  8. SHAWTY721

    combining two excel spreadsheets based on Codes Matching

    I have two excel spreadsheets that I need to combine based on a specific column value. I am trying to add price totals for the inventory information that is on one sheet while the pricing is listed on another sheet. I need the pricing information to be listed in the appropriate row based on...
  9. SHAWTY721

    Update Query

    I have tried to update the linked table but it will not let me in Access. So that is why I am trying to find a way to do it in Excel. Since I did not create the database and I am just working on keeping it up to date and creating things from the database.
  10. SHAWTY721

    Update Query

    Hi I was wondering is there a way to update a field in an excel spreadsheet, like can be done using the update query in access. I have a spreadsheet that contains a column that has a couple values that need to be updated to the new account number so it can the values can be linked between...
  11. SHAWTY721

    Update Query

    I have an excel spreadsheet that contains many records and I was wondering is there a way to do an Update Query in excel like can be done in Access to update a couple values from a column.
  12. SHAWTY721

    Automating Microsoft Excel

    I am trying to automate a process in order to make a monthly routine less time consuming. I have an Excel spreadsheet and an Access database. The spreadsheet contains formulas that calculate values for different fields based on values that are in other fields. The calculation all starts with the...
  13. SHAWTY721

    Grouping query results and exporting to excel

    Yes I meant 0-30, 31-60, 61-90, etc. Sorry about that
  14. SHAWTY721

    Grouping query results and exporting to excel

    Okay I have a database that contains records of billing information. I have created the queries I need to display the information but my issue is, is there a way to take the total values that are being produced from the query and separating them depending on amount for instance 0-30, 30-60...
  15. SHAWTY721

    Using combo box to open tab

    I've explained that to my boss but he says the users want an index page that they can direct them to the page they want even though, there is already a feature in excel that does this.
  16. SHAWTY721

    Bookmark in Excel

    Eventually I will need a VBA solution is it possible for you to send me the link of that specific forum so I can take a look. Thanks!
  17. SHAWTY721

    Using combo box to open tab

    It's not for me it is for other users who aren't so excel savvy and want a Index Page (Blank Spreadsheet), that list all the tabs and they can just click on the name of the tab they want and it will take them to that tab.
  18. SHAWTY721

    Using combo box to open tab

    I was wondering if it was possible to use a combo box to a blank spreadsheet that contained the name of all tabs in a worksheet. When you select a tab name out the combo box that sheet would open.
  19. SHAWTY721

    Bookmark in Excel

    I was wondering can bookmarks be added to Microsoft Excel spreadsheets so that you can have an index tab that will list all the tabs that are included in the worksheet. Similar to the bookmarks that can be created in Microsoft Word.
  20. SHAWTY721

    Hiding or Deleting Blank Rows on Excel Spreadsheet

    I have this excel spreadsheet that is linked to another spreadsheet. I was wondering is there a way to programmatically hide or delete blank rows on the excel spreadsheet. So the spreadsheet will only show rows that contain values. Okay is there a way to do this so automatically once a...

Part and Inventory Search

Back
Top