User Profile

Collapse

Profile Sidebar

Collapse
brat33
brat33
Last Activity: Nov 15 '10, 08:08 PM
Joined: Jan 15 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Name does not exist in current context of code (error message)

    I inheritede some code, and am making minor changes (email name changes) to the code, and want to recompile to another server.

    I am getting this error:
    "The name 'H39FE001E' does not exist in the current context"
    On this line of code:
    "emailSender.Fi elds(&H39FE001E );

    This is the code:
    Code:
     private string GetEmailAddress(AddressEntry emailSender)
            {
    ...
    See more | Go to post

  • brat33
    replied to What Assembly contains 'Session'
    Thanks again for all of your help! I was able to figure it out - I added a few more references and it seemed to accomplish what I wanted it to! Just took some more searching in addition to what I had already found! Session is in the System.Web.Mail reference!
    See more | Go to post

    Leave a comment:


  • brat33
    replied to What Assembly contains 'Session'
    Thanks for the additional info - that did take care of two of my three issues.

    The type or namespace name 'Session' could not be found (are you missing a using directive or an assembly reference?)

    Would you happen to know what I need to reference in order to use Session?

    Thank you so very much with the help on the other two - I have been fighting with this for over a week...Was sure I would be able...
    See more | Go to post

    Leave a comment:


  • brat33
    replied to What Assembly contains 'Session'
    When I try to add the line of code "Using Microsoft.Offic e.Interop.Outlo ok", I receive a error message that Office is not valid for namespace Microsoft. Would I just need to reference this within the solution for the dll? I am not sure what to do with this piece of information. I was expecting to add another USING line at the top of the page, but this does not seem to be the case.
    See more | Go to post

    Leave a comment:


  • brat33
    started a topic What Assembly contains 'Session'

    What Assembly contains 'Session'

    I am modifying the following code, and continue to get a error message stating:
    The type or namespace name 'Session' could not be found (are you missing a using directive or an assembly reference?)

    This is my code:
    Code:
    using System;
    using System.Collections;
    using System.ComponentModel;
    using System.Data;
    using System.Diagnostics;
    using System.Net;
    using System.Net.Mail;
    ...
    See more | Go to post

  • brat33
    started a topic How to add to asp.net code

    How to add to asp.net code

    I have a site which I need to modify and add phone numbers based on what branch is being displayed. I have NO clue what-so-ever on how to do this.

    I have a .aspx file which is using another file as its code behind. My first question is: If I want to add "if statements" into this code, do I add them in the .aspx file or the code behind (aspx.vb) file? Next question is: A statement like
    "<asp:Liter al runat="server"...
    See more | Go to post

  • I am a little slow this morning! I got it figured out. I removed the word Trips, had to add a few parens, change an AND to an OR but now it is displaying data!
    See more | Go to post

    Leave a comment:


  • My bad! The error message does read: The specified field 'Trips.[Enter Trip Number]' could refer to more than one table listed in the FROM clause of your SQL statement.

    Can I not add a parameter query input function into this type of SQL statement? With the joins, and unions and everything else that is going on inside the SQL, that is...
    See more | Go to post

    Leave a comment:


  • I am back at it, and am trying to add another table to perform another check. I get the following error:
    The specified field 'Trips.[Trip Number]' could refer to more than one table listed in the FROM clause of your SQL statement.
    I have the table name specified in front of the column name, and am not sure why I continue to get this error. I am not using Name AutoCorrect in this database. It is turned off, but I still cannot seem...
    See more | Go to post

    Leave a comment:


  • Thank you zepphead80....I was onto something similar, but gave up and used you code snippet. Thank you for helping out... Works well!

    Thank you to everyone else for input as well. I am taking all these "comments" about the design and showing that this database really is as bad as I have said it was! :)

    Everyone have a great weekend! and THANK YOU AGAIN!!!...
    See more | Go to post

    Leave a comment:


  • the use of a temp table may be easiest for me to use. Let me play around with that a bit and see what I can come up with. I have had nothing but problems when they gave me this database to modify for them! I am hopeful that I can convert it over soon...I will get back to you if I need more assistance. But the temp table may just be the route for me to go! Thanks...
    See more | Go to post

    Leave a comment:


  • All the data does exist within the customers tables, but I do NOT want to combine the duplicate data in the table to one entry, but, want to combine the duplicate data to just one entry on a report. So I will have a report that is similar to:

    (combined line) Mr & Mrs Bob Jones Address........ .
    not combined) Mrs Pearl Perry Address.....
    (combined line) Mr. and Mrs. fName lName Address.....
    See more | Go to post

    Leave a comment:


  • Adezii - yes this is how we want to proceed at this time. This project is very sloppy for a number of reasons, and I will continue to inform the uppers how things "should" be done. If you could help me out that would be great! I will say the data entry people are very meticulous on how they enter their data, and check for consistency very well. They understand that the address have to match 100%. Thank you so much!!...
    See more | Go to post

    Leave a comment:


  • combine matching addresses on multiple lines onto one line

    I am trying to modify the following code from showing all customer names on each line to combining customers with same address onto one line, while leaving the customers who are not duplicating address alone.

    Code:
    SELECT Customers.Salutation, Customers.[First Name], Customers.[Last Name], Customers.Title, Customers.Address, Customers.City, Customers.State, Customers.Zip
    FROM Customers INNER JOIN (Trips INNER JOIN [Sales &
    ...
    See more | Go to post

  • Thank you for the information. I went with a .VBS script to perform the conversion. I will have to look into sed as I have never heard of this before. Thanks again!
    See more | Go to post

    Leave a comment:


  • brat33
    started a topic Modify a Substitution Line and a Split function
    in Perl

    Modify a Substitution Line and a Split function

    I have the following two lines of code:
    Code:
           
    $line =~ s/(^\s+|\s+$)//g;
    my($account, $warning) = split(/\s+/, $line);
    I believe this is removing all the white space from the beginning and the end of each line of data in the file. Then it is splitting the line into two separate variables based on white space found on each line.
    I want to modify it to that the Split function will split the line up into...
    See more | Go to post

  • How can I convert a .csv file to a space delimited .txt file in one step

    I am trying to rename, convert, and move a file in one step.
    I have file one:
    \\server\folder \folder\file.cs v
    that I need to convert into space delimited file and rename it and move to another location all in one step.

    Does anyone have any suggestions? I can move the file fine using Command Scripting using:
    copy \\server\folder \folder\file.cs v \\server2\folde r\folder\file.t xt /Y
    BUT the .txt file...
    See more | Go to post

  • Open database in Edit mode rather than Read Only mode

    I am working with a database created using Access 2007, but saved as a 2002-2003 version. My problem is....I have three users who need to access the database at the same time. One can open it in edit more, then the other two can only open in Read Only mode. I can open in edit at all times. I assume this is because I am an admin on all Servers and computers we have. Please correct me if I am wrong in that thinking. There is no id and password...
    See more | Go to post

  • Delete specific files using Command Scripting

    I have lots of files that need monthly cleanup done on them. These files are located in many different directories on the same server. Some example files names are C1234.idx, C1111.idx, C8693.idx, etc....ALL the files will start with either an 'C' or an 'L' and then contain 4 random numbers followed by an extension of either .idx, or .dat. The problem is that there are also files named CTFIX.idx, Ctons.idx, etc...So I can not use:
    ...
    See more | Go to post

  • brat33
    replied to How to use If, Then, Else inside of a query
    I thought I had it figured out. I have modified it so many itmes I am stuck again... :(

    Currently I have the following SQL code being used to gather the correct data.
    Code:
    SELECT Customers.Salutation, Customers.[First Name], Customers.[Last Name], Customers.Title, Customers.Address, Customers.City, Customers.State, Customers.Zip
    FROM Customers INNER JOIN (Trips INNER JOIN [Sales & Payments] ON Trips.[Trip Number]
    ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...