|
I want to backward format a date to the number. Does anyone know how to do that? Like take 01/01/2003 and get the number value.
Thanks
Santana
|
|
|
|
|
What number value? Are your talking about some kind of serial number representing a date? Like how many seconds from a base date, like Jan 1, 1970?
RageInTheMachine9532
|
|
|
|
|
When you register the dll and copy the registered .dll to another directory
generates serious problem. even unregister both .dll and reregister the original dll again won't solve the problem. Probably i have to work with registry and delete some key( i am not sure which keys to delete).
another option for this kinda problem. I have listed all dll that have the same dll in VB's reference library.
Thanks in advance.
Shinya
|
|
|
|
|
You can't register the same .DLL multiple times. This is because the registration is based on the GUID's in the .DLL, not the location of the .DLL. Unregistering it and then reregistering the .DLL will only update the location of where the .DLL can be found when it's needed.
skoizumi29110 wrote:
even unregister both .dll and reregister the original dll again won't solve the problem.
You might want to provide a description of the problem itself. Maybe there is another cause you haven't thought of, besides a registration issue...
RageInTheMachine9532
|
|
|
|
|
What I need to do was just clean up the registry and reregister the dll
like you said
"Unregistering it and then reregistering the .DLL "
is probably important.
Thanks for the tip.
Shin
|
|
|
|
|
Hello,
Ok, I have a table with alot of accounts and I want to copy only the accounts for a month at a time to a new table.
what is the fastest and best way to do this there are like 400,000 accounts that are going to be copied and i have to only copy accounts between the startdate and enddate that the user picks from date pickers. I am using vb.net and access as the datebase. Another problem is that the date in the original table is not in a standard format 1/1/2004 it is in a Timestamp which is time since 1/1/1900 and it lookes something like this 54745186 so i have to format it before i can check it against the dates the user enters. The way i am doning it know is like this, if anyone can suggest a faster way, cause this is taking like 10 mins.
MDRDataAdapter.SelectCommand.CommandText = "Select RecID,Format([mCallEnd]![Timestamp]/1440+1,""ddddd""),
Call,Account,Billing,Client,OrgAccount,
Duration,Port,Initials,CallKind,OpTime
From mCallEnd"
MDRDataSet.Clear()
MDRDataAdapter.Fill(MDRDataSet)
For i = 0 To MDRDataSet.Tables("mCallEnd").Rows.Count - 1
tempdate = MDRDataSet.Tables("mCallEnd").Rows(i).Item("Expr1001")
If tempdate >= startdate And tempdate < enddate Then
NewMDRdap.InsertCommand.CommandText = "insert into newtable
(RecID,[Timestamp],Call,Account,Billing,Client,OrgAccount,
Duration,Port,Initials,CallKind,OpTime) values
MDRDataSet.Tables("mCallEnd").Rows(i).Item("RecID") MDRDataSet.Tables("mCallEnd").Rows(i).Item("Expr1001")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Call")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Account")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Billing")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Client")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("OrgAccount")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Duration")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Port")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("Initials")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("CallKind")
MDRDataSet.Tables("mCallEnd").Rows(i).Item("OpTime"))
NewMDRdap.InsertCommand.ExecuteNonQuery()
End If
Next
|
|
|
|
|
ACCESS?? 400,000 records in ACCESS??
Uhhh... Access is a desktop database. It was not designed for this kind of volume. Your not going to be able to speed this up very much at all since it works entirely in files. SQL Server is MUCH better at handling this kind of volume. If you really want to speed this up, migrate the database to SQL Server or even the MSDE first. In Access 2003, use the Upsizing Wizard...
And why would you copy all the records for a month into a new table? If you are looking to speed up future queries on that new table, the time your save then is only going to be eaten up by copying everything to a new table first. So in the end, your not really saving that much time...
RageInTheMachine9532
|
|
|
|
|
I'm not sure why you want to pull the entire months of tables data. I suspect that the data set will take some time to fill. You could try a paramtized query. Only fill the dataset withthe requested row. The difference is you would add "Where RecID = ? ".
Your form would then have a text box for the user to enter an ID and a button to retrieve the data. Is this something that you could use?
|
|
|
|
|
hiii to alll
i want to know how can i replace color of an image pixel by pixel. means i have an image having differnt colors e.g a carpet design , now wht should be hapened that if i want to replace red color whereever it is the red color on the image, it is then replaced with (say) green color, wht should i do?
can any body give me code in VB 6.0 coz i m new to VB.
plz its a bit urgent
thanx
regards
Tahir
|
|
|
|
|
THe PSet method will change a specific pixel of an image loaded by a picture box control.
Glano perictu com sahni delorin!
|
|
|
|
|
I have a program that loads a excel spreadsheet into a datagrid on my form. I now want to take that same information and load it to a SQL Server table from the datgrid. Is this possible?
here is what i am doing so far:
Dim a As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=c:\supplier requirements.xls;" _
& "Extended Properties=Excel 8.0;"
' Create the connection object by using the preceding connection string.
Dim objConn As New OleDbConnection(a)
' Open connection with the database.
objConn.Open()
' The code to follow uses a SQL SELECT command to display the data from the worksheet.
' Create new OleDbCommand to return data from worksheet.
Dim objCmdSelect As New OleDbCommand("Select * from [supplier requirements$]", objConn)
' Create new OleDbDataAdapter that is used to build a DataSet
' based on the preceding SQL SELECT statement.
Dim objAdapter As New OleDbDataAdapter()
' Pass the Select command to the adapter.
objAdapter.SelectCommand = objCmdSelect
' Create new DataSet to hold information from the worksheet.
Dim objDataset As New DataSet()
' Fill the DataSet with the information from the worksheet.
objAdapter.Fill(objDataset, "XLData")
' Build a table from the original data.
DataGrid1.DataSource = objDataset.Tables(0).DefaultView
|
|
|
|
|
Greetings
I am using VB.Net (Visual Studio 2003) & i would really like to know how the MS Access's "autonumber" should be handled in a disconnected programming environment under ADO.NET.
Your response is greatly anticipated.
Many Thanks
Gizmo
|
|
|
|
|
You wouldn't do anything with it. The autonumber field will get filled in when the recordset is finally added to the table.
RageInTheMachine9532
|
|
|
|
|
Thanks alot.
I appreciate your help.
Gizmo
|
|
|
|
|
Hi,
I have a dll writen in C++ which contains a fn that takes a char** parameter. Now, if I call this fn from a VB application, how can I specify aargument-value to the fn.
it shows a 'long' in my VB method call.
Shenthil
|
|
|
|
|
char** means : pointer to pointer of type char
pointers are 4 byte integers in Win32
so long is the VB6 type that can represent it..
If you use COM pass BSTRs not chars
|
|
|
|
|
|
|
see, I am using the foll. Win32 API. here I want to pass the argument for the third parameter- lpServiceArgVectors . If I call the same api from my .cpp program I will pass the arg.vectors or arg.array. But, in VB how can I pass the vector/array. can u help me?
Public Declare Function StartService Lib "advapi32.dll" Alias "StartServiceA" (ByVal hService As Long, ByVal dwNumServiceArgs As Long, ByVal lpServiceArgVectors As Long) As Long
Shenthil
|
|
|
|
|
|
I am trying to print the content of a textbox to a printer using visual basic 6. What is the easiest way of doing this?
SDE
|
|
|
|
|
Use the Printer object and it's Print method. See this MSDN section[^] for the docs on printing in VB6.
RageInTheMachine9532
|
|
|
|
|
|
I am using the classes and methods from the Msxml2.DOMDocument.4.0 namespace to dynamically create an XML file using VBScript. (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm/xml_mth_sz_3jol.asp). I was able to successfully create the XML and load it into memory for parsing. However, for some reason, I am not able to use the SelectSingleNode() method of the IXMLDOMNode object. The error I get is: "Object doesnt support this property or method. Error code: 800A01B6".
Any ideas?
|
|
|
|
|
Does anyone know if you can interact with an embedded OLE object in PowerPoint slideshow mode? I have an OLE object which draws a 3D representation of a plane and would like to manipulate it using mouse events. I can get to the COM interface of my object, but it seems impossible to refresh the content of the slide with the new picture.
Thanks to all,
pnyr
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
