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 Wanet Telecoms Ltd 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. aharris2693

    Crystal Reports Training

    I am in North Carolina and am looking for a good 2-5 day workshop for Crystal Reports. Do any of you know of any in or around this area, NC, SC, VA, GA? Also, I have a background in VB and am competent in all MS Office software. Would an intro class be a waste of time or should I buy a book...
  2. aharris2693

    Looping through the alphabet

    Is there a VBA function for moving to the next letter in the alphabet? My loop is based on an integer, and I have considered using a select case to read each letter and change it to the next one. I only have 43 columns, so I could do this, but if there is a simpler way it would be great. Thanks
  3. aharris2693

    Dynamic TextBox

    I am looping through an Access database and for each record, creating a text box to display 1 field from each record. The problem is that the field is a memo and therefor some records are quite long. I have tried to set the multiline property to true, but I get errors everytime I use this...
  4. aharris2693

    Excel 97 SR-1 vs Sr-2

    I have built an application in Excel 97 Sr-2 that works great on my machine, and has been deployed to around 50 machines locally and have had no problems, once we started sending it off site, an "compile error" has begun showing up with people using 97 SR-1, has anyone come across...
  5. aharris2693

    deleting a record

    I have a program that allows the user to build the contents of an Access DB. they can add, update and until about an hour ago, delete. Everything worked fine and then I began getting the following message everytime I tried to delete, An unhandled exception of type...
  6. aharris2693

    loading a DB from a dataset

    From the research I have done as well as reading previious posts, I have written the following code as a sample to learn the process of reading and updating an Access DB. It all woks fine until the update command. At this point, I get the following message "An unhandled exception of type...
  7. aharris2693

    Form Control Combo Box

    I am an intern and am trying to make a form that will update another form when changes are made. i have built the whole thing using control objects, but once I am gone, no one will know how to change any of the VBA, so I am trying to do it much simpler using the 'forms' objects. My question...
  8. aharris2693

    Good Resource Material?

    I am an intern trying to teach myself VB.net based on some prior knowledge of ASP and VB6. I am doing some work for Facilities here, so there is no one in my department that knows anything about VB. I bought a book by MS, but it is extremely simple and really only goes into coding objects that...
  9. aharris2693

    Combo Box Values

    I think this is a relatively simple question, but being new to .Net, I don't know the answer to it. I have built a combo box that is filled through a datatable. All of this works, but what I am trying to do is add "PersonID", another field in the datatable as the value of each entry...
  10. aharris2693

    referencing fields

    Is there any way to pull data from a dataset and put it into a variable? I would think that this would be very easy, but the only way I can find to do it is by binding an object and then making the variable into that objects text. I am used to programming using ASP, but am trying to learn...
  11. aharris2693

    Navigating Between Forms

    This is my first time using vb.Net, and I am finding it to be quite different from VB6. I currently have a simple problem that jsut doesn't seem to work. If I want to close the current form, (form1), and open the next form,(form2), in VB6 i would simply use Unload Me Form2.show I feel knid...
  12. aharris2693

    I am relatively new with using VBA

    I am relatively new with using VBA for Excel and I am trying to reference two workbooks at the same time. What I want is for the user to make changes to a weekly "move list" that will then update another sheet that is a seating chart at the end of each week. Based on the names in the...
  13. aharris2693

    Filling a combo box from another workbook

    Is it possible to fill a combo Box that is on a userForm in one workbook with a range from another workbook. Thanks
  14. aharris2693

    disabling security in Excel 97

    I have created a program that is based completely off of the vba that runs when it is opened. I have now found out that some our older versions of excel were originally set up with a high level security. Part of the training that will go into using it will involve reseting the security levels...
  15. aharris2693

    Forcing IE to be used

    I am relatively new at javaScript, and I am working on some Intranet pages. We have both IE and Netscape on all of our machines, and I would like to force some pages to be opened using IE even if the user arrives to them using netscape. Is this possible? Thanks for any help
  16. aharris2693

    display a report in excel

    I have built a form that asks the user for search criteria, and then which field to look under. After searching a sheet called "Projects", I want to display each record in a seperate sheet called "Report". My code is below. Do Until (i > r) If...
  17. aharris2693

    Maximizing a Form

    Is there a way to maximize a form in excel upon opening it. I know in Access, codmd.maximize works, but excel doesn't seem to recognize this. Is this possible or should I just play with the height and width? Thanks for any help
  18. aharris2693

    Tab Order

    I am familiar with VB 6.0, so I built a form in Excel thinking that it would function in the same way, but I can't seem to find any way to setFocus, or set up any sort of tabs from object to object. I assume there has to be some way to do this. Thanks for any help

Part and Inventory Search

Back
Top