Search results for query: *

Dear Coding Gurus: My code is created the childnode twice. I cannot figure out what I'm doing wrong. I should have a tree that looks like this: Subject - Parent Child Subject Parent Child What my code is doing is populating the child twice. [code] protected void...

Hi, I'm new to SAS coming over from the Visual Basic/.Net side of the house here. I'm not SAS programmer, yet, I'm currently a SAS Cut-n-Paster. I have some SAS PDFs and they cover SUM and MEANS but using these handouts, I can't get my answer. Your help would be appreciated. I am trying to...

I've struggled with my textbox code. I am trying to only launch a form if the textbox data has actually changed. Private Sub txtLastName_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtLastName.TextChanged Try 'If the last name has...

Below is an example of one of my update procedures. I'd like to capture the changes after update with something like, haschanges or getchanges. Working with the code as it is, I'm sure it's pretty bad, can I call a procedure that will create a datatable with the updates? Then from there I'd...

I'm referencing this thread: http://www.tek-tips.com/viewthread.cfm?qid=1176988 This thread and the answers has helped me finally clear all controls in a groupbox on my form. However, I need help with clearing more than one groupbox on a form. To further complicate the issue: I have a form...

Dear Experts: I've looked high and low all over the web. I'm stuck with handling this null date being retrieved with DAL from my MS Access Database. I have researched this for a long time. Specific help would mean a lot to me. Dim cmdRevEmp As New OleDbCommand Dim daRevEmp As New...

Hi I hate to bother the community with such a trival question, but as much as I've researched since last week, for the life of me, I cannot see what is wrong with my syntax. Would you review my syntax and see if something leaps out at you and let me know what I might have missed? My connection...

Hi, My experience is with VBA and MS Access. I'm new to using Table Adapters in VB to consume data in Access. I'm trying to put all this new information in my head so I can move forward to the new technology. I cannot seem get data back from my Select Statement, Insert a row, or update a row...

Hi, I'd like to ask what is the best practice for the industry, when connecting your application to the underlying databases. For instance do you make a global connection upon load of the project? Do you put it in a class and call it? As you can tell, I don't have the proper terminology...

Here is my code, the IP address is returned as a alpha instead of a number. Can anyone see what I might be doing wrong? Private Sub GetIPAddress() Dim strHostName As String Dim myIPAddress strHostName = System.Net.Dns.GetHostName() myIPAddress =...

Dear Experts: LINQ is the new thing for me. Can I list all installed applications querying my system with LINQ? Is there another way to expose this information? I've tried to find a way to do it, but I'm not having any luck. If you'd point me to a namespace that might expose this information...

Here is my code. In my IDE, "Left" appears as a Property and Integer, where "Mid" appears as Function is a String. Which it should be. I'm trying to figure out how can I find out why this Left is set as a Public Property. I don't know how to find it and fix it. I know it's a stupid question...

Is it possible to install a project created in VB 2008 on older PCs? Will you have to check for a specific verison of .Net Architecture to ensure it works? Maybe I'm barking up the wrong tree anyway. So when I distribute my VB 2008 project to older PC's, can I do it, or do I need to jump...

I'm sorry to be asking the stupidest question today. But, I'm trying to set some references and I'm having difficulty. Back in the good old days of VB 6, it was easy to set a reference. But now, I'm having problems with .Net. How do you set a reference to Scripting? I see it set in my example...

I am terrible at understanding these IIF statements. Would you help me determine the number of days in a quarter, I'll pass in the date. NumDaysInMonth= First(DateSerial(Year(tbl_Cognos_GL_BS_YTD.Month),Int((Month(tbl_Cognos_GL_BS_YTD.Month)-1)/3)*3+1,1)) NumDaysInMonth2=...

Hi! I've done this before but for some reason today, I can't find my old source code, and bonus...I'm having a mental block and can't figure this out. I'm trying to simply return one item that is selected in a listbox. I need to eventually pass it into my query, but I feel confident I can do...

Hello experts: I am so new to this tool that I'm still learning the terminology. It's making it hard to search for the right answers. I am working to quickly learn this information. I'm working with space delimited text files. This data is created from a product that my department does not...

I have this code in production and it's working fine. Except, I send out so many emails that I'm starting to crash out of my applicaton because my email box is full. One reason is that I have this code: DoCmd.SendObject , "", "", "Kjones@blahblah.com ", " SandyooU812@hotmail.com", ...

Hello, (I have inherited this database. Things are not done properly. I'm tasked with "makeing it work." I redesign whenever there is a chance to fix it.) I have a query that I'm trying to remove the parameter prompt asking for a date (six times). The designer of this database is, his wisdom...

Hi, I'm stumped. I've searched the forums, but I'm still struggling to determine the very best way to resolve my problem. I've inherited an unnormalized database. I'm empowered to only continue to band-aide it, not normalize it or rebuild it. :( This is a table that was being updated (on click)...