425 Posted Topics
 | Hi all, I'm about to get a little long winded here and I'm sorry for that but I have a couple of issues that I need guidance with. I have assembled a procedure that basically performs a bunch of web browser clicks to query Statistics Canada (SC). The query itself … |
| | Hi all, I have the following procedure that connects to my database. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim stmt As String SQLConn.ConnectionString = ConnString SQLConn.Open() stmt = "select Table_Numbers From tblRelease_Dates Where (Release_Date Between '" + fileCreatedDate + "' And GETDATE())" SQLCmd.Connection = SQLConn SQLCmd.CommandText …  |
 | Hi Doogledue123, I'm fairly new to all of this but I think you need to handle the event like so: Sub ImageFollow(e As System.Windows.Forms.MouseEventArgs, myImage As System.Drawing.Image)Handles Me.MouseDown  |
| | Hi all, I have the following VB.NET code where I am attempting to connect to a SQL Server table, query it to find out if a date in the table is between a derived date called "fileCreateDate" and now/today. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim … |
| | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
 |  |
| | Hi all, can someone tell me where the path is for the images used in folders. I'm making an interface right now and I need access to the images like the "Open file" image (or an image of a file). I know that I can use the interwebs to find … |
| | Hi all, I have a form that is supposed to query a website. I have the following code that first looks at and uses data from an SQL Server db connection: ConnString = "Data Source=SQL2008T1;Initial Catalog=EconAnalysis;Integrated Security=True" SCqryStr = "" SQLConn.ConnectionString = ConnString SQLConn.Open() SQLStr = "SELECT vSeries_Number FROM tblVSeriesList" … |
| | Hi all, I have a .NET form where I want to connect to a table and then pass each defined (by query) string from the table into a string within the code. I have created a connection to the database already via Data Sources but I'm unsure about the syntax … |
 | I'm not sure if this is what you need but in your query use SELECT DISTINCT CustomerID FROM Customer_DETAIL If there were any dupes DISTINCT will get rid of them at query time  |
 | You know you're old when you start reading threads about when you know you are old!  |
| | Re: Where to go now? You could also try and think about some real world possibilities for writing code and then start writing. Why is it called writing code when we type it? Anyhow, practice makes perfect so practice a lot. I just perused the outline for Java in 21 days and there is so …  |
| | Just curious as to how to report spam here or if it should be reported at all. I received an email from babyl which reads: > Hello >My name is amaram I am tall ,good looking, perfect body figure and sexy.I saw your profile and was delighted to contact you, …  |
 | > It's going to take you weeks of well-supported learning and effort @JamesCherrill, I wish it only took me weeks to learn! I entered the analysis and coding world when I started university 4 years ago and I have years worth of learning to still accomplish. @joejo, as stated throughout … |
 | |
| | Hi kovidd, as soapyillusion pointed out you haven't really let anyone know what you do know. If you are comfortable with arrays and pointers you could move onto data structures and algorithms located [here](http://ww0.java4.datastructures.net/). I think that learning about stacks, queues, lists, iterators, and trees would be the next step, …  |
| | Why reinvent the wheel? Use Excel or Google Docs. |
 | Re: Petrol Prices I hate petrol prices and despise the multi-billion dollar (a day) companies that control the flow as it were. I see scare tactics when hurricanes hit oil nations and the barrel prices go up and so do the pumps, almost instantly. Yet, when barrel prices go down, the pumps do … |
| | Hi Nole diver, Is there any chance you can upload your workbook without sensitive or private data. It would be a big help if you provided a before and after scenario to go along with it. This way we can know for certain what your requirements are. |
 | I'm a newbie and I feel welcome! I know I don't have much to offer (yet) but I will once I feel more comfortable with my .NET coding practices. For forums like this to be successful, the gurus and long term members (whatever they may be) need to be actively …  |
| | I don't get this thread. The first post is very non-descriptive and then the 3rd question wants the same non-descriptive thing. Given that this is sort of an open forum where there are VBA questions mixed into the frey, what is it you (Maj.Clac & cathekitten) really want? Also, have …  |
| | Is it possible that you are having a padding issue? I'm not sure but maybe if you posted your css code (whatever you wish to call it) you might get a quicker resolution to your problem. |
| | I would like to invoke a click on a link from a link that is generated by an HTML query. I am attempting to program an application that queries a website and am getting hung up where I download the .csv that is loaded by the website. Here is the … |
| | Greetings all. I am a 38 year student and will be starting my last year of studies at a local university this fall. My field of study is Information Systems and I work as a student for my local utilities as an IS support for the company's Economic Analysis Department. … |
 | I am an Atheist but I don't practice! :) My wife and two boys go to a Baptist Christian Church and I don't knock them for it but sometimes I really have to bite my tongue when my boys tell me something that they "learned" about the Christian God. I … |
The End.