I'm looking for a solution to a simple problem. I want to sum several non-contiguous cells in a column. Some of the cells, however, have text (usually some text like "SKIP") instead of a number. I have tried using SUMIF like:
=SUMIF((A4,A8,A12,A16),"<>'SKIP'")
This gives error in the cell...
Found out the problem.
In the Page Load event, which is where the data is binded to the grid control initially, I did not check for IsPostBack. What I should have had in the Page Load was something like:
If Not IsPostBack Then
...
dgGrid.DataSource = dtTable
dgGrid.DataBind
...
End...
I have a column in a datagrid that is a template column. When the user clicks EDIT on the row, the user can then edit data in the textbox in that row.
When they click UPDATE, the program executes the following code:
Dim txtTextBox as TextBox
Dim strText as String
txtTextBox =...
I'm using ASP.NET to send emails. I'm using Exchange as my SMTP server. I'm using all the correct code to do this and it is working well.
What I need to do is to somehow get a delivery receipt from the recipient's email server sent back to the person whose name is the sender of the email...
I'm using the following VB code to view a pdf file in a browser:
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile "c:\inetpub\wwwroot\reports\myreport.pdf")
Response.Flush()
Response.Close()
The problem is that this will show fine...
I'm using the following code to create a PDF file from a Crystal Report.
Dim oRpt As New CrystalReport1
Dim DiskOpts As CrystalDecisions.Shared.DiskFileDestinationOptions = New CrystalDecisions.Shared.DiskFileDestinationOptions
oRpt.ExportOptions.ExportDestinationType =...
Thanks, Isadore.
I tried doing that but it still sent corrupt files. You did, however, send me in the right direction. What finally worked was:
myMessage.Attachments.Add(New MailAttachment("c:\myfolder\ExportFile.pdf", MailEncoding.UUEncode))
Thanks for your help.
I'm using VB.NET with the following code to attach a PDF file to an email message:
Dim myMessage As New MailMessage
myMessage.From = "me@mycompany.com"
myMessage.To = "someone@anothercompany.com"
myMessage.Subject = "Monthly Report"
myMessage.Attachments.Add(New...
I'm using template columns in a datagrid so that a user can edit data when they select "edit".
The problem I'm having is when I've added some validation controls. Not all the columns have validation controls. The ones that do, have the text boxes align differently in the cells from ones that...
I have a macro which retrieves data from a database after a user enters an order number in an inputbox. After the macro retrieves the data, it puts the info in some bookmarked places in the active document in MS Word. Afterward, the macro calls the command to print the document...
I am new to Exchange Server admin but I have a problem that involves a public folder.
An employee who used to work here created a public folder that is a sub-folder to one in which I am the owner. This employee no longer works here and he did not set permissions for anyone else in the company...
Do the following in Word:
1. Before merging, press ALT+F9. On your mergefields you will see something similar to the following:
{MERGEFIELD EntryTime}
where EntryTime is your Access field.
2. Place your insertion point between the word "MERGEFIELD" and your field name.
3. Type \@...
Here is a javascript command that has helped me before. Let me know if it works.
<script Language="JavaScript">
if (self!=top){
top.location = location
}
</script>
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.