|
I don't have a problem with using the old stuff, but he is right in one sense. VB6 has been "officially" dead for over a year now. DAO (not DOA) has been dead for about 8 years now, I think. That being said, your support resources out on the web are dwindling fast.
This[^] is about the best you're going to get.
|
|
|
|
|
Yes I agree that VB6 is "officially' dead. And I have no less than 3 other programs that are written in VB.net 2005. But for this project I have to convert it to VB6 before I can more forward to .Net and I have it at least 90 percent converted but there are several places in this code that uses the scenario that I presented in my question. That is why I am asking for help.
|
|
|
|
|
I would think you will have to rewrite the query in Access to duplicate the results, I would guess that DSum is an Access specific function that is no longer supported by the later version of DOA.
And yes the forum is for VB and you are correct to ask the ? here, however it stikes me as invalid to move from 5 to 6 before moving to .net, a waste of resources. I just hope it is not so you can use the upgrade wizard to get the app into .net!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have Erorr message when I receving data on the net in tcpclient
in pocket pc .
I want to ask how Im receiving data on the net when i client pocket pc?
Sample Code maybe help
Thanks'
|
|
|
|
|
Agbaria Ahmed wrote: Erorr message when I receving data on the net in tcpclient
in pocket pc .
What kind of error message? Just saying you have an error message and not telling anyone what it says, really isn't going to have anyone help you at all.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
I have textbox where I am showing the date and the format of this date is short date "01/01/2008".I have a variable called mDeliveryDate as date and I want to stroe the textbox date in Variable with the format "01-Jan-2008" for which I am using the following statement
mDeliveryDate = Format(txtdate.text,"dd-MMM-yyyy")
I am getting error something like conversion from string to date is invalid.
Any idea how to fix this.
Thanks in Advance
Ejaz
|
|
|
|
|
Ejaz
Defining mDeliveryDate as Date means it is stored in the system date format, not a string.
The format is done later.
DateTime.TryParse(txtdate.text, mDeliveryDate )<br />
Dim longDate As String = mDeliveryDate.ToString("dd-MMM-yyyy")
will give you "01-Jan-2008" in longDate. If it is an invalid date it will give you DateTime.MinValue (01-Jan-0001)
Hope this helps
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks Bob I will try this.
|
|
|
|
|
i am using dotnet2005.i do my project in vb.net windows application.
i want to display amount as 12,34,567.00 in crystal report.
in my project,amount is displayed as 1,234,567.00 in crystal report.
displayed as 1,234,567.00 is wrong,displayed as 12,34,567.00 is correct.
so how to displayed as 12,34,567.00 in crystal report.
there is any options in crystalreport to displayed as 12,34,567.00.
no option means,can solve this problem using vb.net code.
|
|
|
|
|
First - this is a CR problem and so no VB-code will help you.
But you can provide format options for your fields in CR - try looking there (I think there might be a way).
If not you can create a formula-field in CR (it provides a own CR and even a Basic syntax) and format a number just like you would do it in plain VB.
If you don't manage this your last option is to use a character-field for the number and format it in VB before sending the data to the crystal report.
|
|
|
|
|
It looks like you want to format it for Indian currency.
I havn't looked into CR but I know VB does it automatically once you set the Culture setting.
|
|
|
|
|
i am using dotnet2005.i do my project in vb.net windows application.i want to add one year from selected date.the following code is
Private Sub FromDateTimePicker_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FromDateTimePicker.ValueChanged
ToDateTimePicker.Value = FromDateTimePicker.Value.AddYears(1).AddDays(-1)
End Sub
The above code is used to display as follow
for (ex)
using above code,if click date as 01/04/2008 in FromDateTimePicker means,then automatically displayed as 31/03/2009 in ToDateTimePicker.like this,if i click any date means,correctly worked.but if l click 29/02/2008 in FromDateTimePicker means,it must be automatically display as 27/02/2009 in ToDateTimePicker.But i want to display as 28/02/2009 in ToDateTimePicker.so in leap year above code is not working.how to solve this?
|
|
|
|
|
Use this condition to check whether the year is leap or not
If (DateTimePicker1.Value.Year Mod 4 =0) Then<br />
Else<br />
EndIf<br />
|
|
|
|
|
Note: That is not the complete condition to check for leap years, it only works for years close to now.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
add some code conditional on DateTime.IsLeapYear
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Just subtract the day before you add the year:
ToDateTimePicker.Value = FromDateTimePicker.Value.AddDays(-1).AddYears(1)
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi to all
In my gatagrid i populate the values from my one table with two fields
Now on edit dynamically i want to show the dropdown list with data in that cell
should come into that dropdown. and it should be get updated
how to do this i'll be very much thankful to you.
|
|
|
|
|
In you are using 2005
In your datagridview choose edit columns, and change the type of column of the column you want to be a dropdown from datagridviewtextboxccolumn to datagridviewcombobox column and then you can bind the dropdown to any datasource
Alexei Rodriguez
|
|
|
|
|
where should i go then? please help me out
|
|
|
|
|
hi
What is Wrong with you, are you crazy, this is not a chat room, Stop posting junk, what is your problem, lets see if we can help, explain
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
|
Hi,
I have this code that gives me an object reference not set to an instance object for variable objDI
when the code hits
outputfile = gserver.Outfolder & "\" & objDI.outputfolder
This is weird because the PDFDocs count is 1.
Please help.
<code>
For Each objDI In objSI.PDFDocs
outputFile = gServDef.OutFolder & "\" & objDI.OutputFile
If objDI.DocType = "HTM" Then
If Not PrintHTM(objDI.InputFile, outputFile, objSI.ToString) Then
LogPrintError(objSI, file)
Return False
End If
Else
If Not PrintOther(gServDef.InFolder & "\" & objDI.InputFile, outputFile, objSI.ToString) Then
LogPrintError(objSI, file)
Return False
End If
End If
Next
<\code>
|
|
|
|
|
You failed to specify what type of object objDI is, therefore you will not have access to its properties. If you add As PDFDoc after For Each objDI , or whatever type of object collection you are enumerating, this should work as you expect.
Clean code is the key to happiness.
|
|
|
|
|
I had actually declared the variable objDI at the top of the function
whch I did not include in the code snippet.
But I will try your idea anyway.
|
|
|
|
|
Hello everyone, I need help with some options.
I am creating a test app more as a proof of concept type deal. In the end, this project is likly going to moved to asp but thats later. Right now I have a set of classes that create themselves from a database. The program has to take the objects and put them into seperate groups, then compare them. Once an object is done, it is removed from the group.
This works fine when I am just comparing two objects, but I am stuck when it comes to finding a way to throw them into two or more groups, and compare each item in turn. At first I thought an array or linked list would work, but I am not sure what the performance would be when each array has over one hundred objects.
Is this the way to go, or is this a good time to break the books open and go through collection?
|
|
|
|