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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.