|
I am working with VB6 looking at an Access 97 database. What I am doing is converting VB5 code to VB6. I have come across a problem where the code creates a Query in the Access file, then assigns that query to a Recordset (I know the query is fine because when I run open it in Access it shows the desired results). The problem is with some DSum, DMin, and DMax statements in the Query. It assigns the Query to the Recordset with no problem (.Data1.RecordSource = "SELECT qryJCDSSchedLU1.* FROM qryJCDSSchedLU1 ") but then it runs a refresh (.Data1.Refresh) and then this gives an error. (Error – 3085 DOA. Database – Undefined function ‘DSUM’ in expression.) If I remove the DSum then it gives me this error on the DMin, and if I remove that it gives me the error on the DMax.
This works just fine in VB5 but not in VB6. Can anyone give me any suggestions on what I need to do to fix this? Thanks in advance for any help that you can give.
modified on Thursday, January 31, 2008 3:21:19 PM
|
|
|
|
|
And here I thought we were using cutting edge technology. The temptation to be rude is sooo strong but I'll refrain.
You are upgradeing from 5 to a product that is already retired and no longer supported. Why not move straight to .net you would get a lot more support and resources would be current.
Take the opportunity to rewrite the app, upgrade your skills, produce a BETTER solution.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I am sorry I thought this form said Visual Basic / VB.Net which I thought meant that you could post any questions in here regarding Visual Basic. Can someone help me with the question that I posted? This is probably a very easy answer that others have come across in the past and know exactly how to handle it.
I don't understand what drives some people to waste their time by going in and out of forums making stupid comments and judging others instead of helping that person with the situation at hand (do you really have to try and make others feel bad to make yourself feel better?). I don't think I have to justify the reason that I am converting to VB6 or what I plan to do with this code once it is in VB6.
Mycroft Holmes wrote: The temptation to be rude is sooo strong but I'll refrain.
...right back at ya buddy!
|
|
|
|
|
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>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
