|
Q1/
If this is the path to save an open Excel file running in the background
xlSheet.SaveAs("c:\My Path\tk" & Format (Me.MonthCalender1.SelectionStart, "yyyyMMdd") & ".xls")
How would I open a file using the MonthCalender1 (Change-Date) as the trigger to determine the name? e.g. "tk20070727.xls" ?
Q2/ Having opened the file (running invisable in the background), how can I pull the data from a cell to a variable?
Q3/ How do I close the invisable running .xls file in runtime?
|
|
|
|
|
how to identify status of mscomm event when a reciever attend the phone
thank you
-RisKhan-
|
|
|
|
|
There is no event if the phone is picked up... Whatever you have the phone connected to, I'm assuming it's a modem, has to be able to send a message to the PC. AFAIK, there is no modem out there that will tell you if the phone goes "off-hook".
|
|
|
|
|
i m trying to use the filesave-dialogbox, it works ok bt 1 problem i m facing is when the filename is even nothing the "Save" botton is enable and clicking it does nothing except the dialog reappears.... Plzz tell me how can i disable the "Save" botton when the filename is "", r nothing.
(Jameel)
|
|
|
|
|
To do that would involve some complex code, as you'd need to hook into the existing save as dialog, or just create your own copy of it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hello frnd,
i am creating virtual directory programaticallu using VB 6.0, it is running successfully
i create the site using
<br />
ObjVirtual = object.create("IISWebVirtualDir","Name Of Virtual directory)
but how can i set the application name in virtual directory, when i create the virtual directory programatically and click to the properties then application name textbox is empty...
and second problem is i want to check the "Intergated windows authentication" check box programatically,
please help....
any helpful code OR link ??????
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Hi all,
i Have solve the problem, we can set the Application Name in virtual directory by using
ObjVirtual.AppFriendlyName= "Name of Application"
and we can give the intergated windows authentication by using
ObjVirtual.AuthNTLM = True
But i have a new problem how can i set the default page enable in virtual directory...
please help....
regards
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Have a look at this link[^] for the list of ADSI properties. You want EnableDefaultDoc.
|
|
|
|
|
i have some code in currentcellchanged about catching up anychange of cells but it works when click enter or mause click i wanna see changing when click keyboard one by one of keys pls help me
|
|
|
|
|
I can't understand what your saying, what does "...when click keyboard one by one of keys" mean??
|
|
|
|
|
wanna see result of pulled database info in anothercell of datagrid when i push a key to currentcellchanged
my code work but need to left click or enter , wanna that it works when push a key
|
|
|
|
|
i cant understand the meaning of this part of a code , can someboday explain me the meaning
thank you
-- modified at 6:35 Friday 27th July, 2007
|
|
|
|
|
If creates an IPEndpoint using any available IP address on the local computer, and any available port number.
|
|
|
|
|
Hi, I have a form which has multiple web form controls..
I have a post back to fill a dropdown list when another dropdown list is selected ...
Once this post back occurs the tab index is shifting to the first one
How can i retain my tab index to the same control or rather the next control.
Thank you
Hepsy
|
|
|
|
|
This is a question better suited for the ASP.NET forum...
|
|
|
|
|
Hello!
I would like you help me to write complected code of vb.net that is about Eastriver.dll. I want to connect to the Eastriver Er-980 but I don't understand to call function, so I would like you send me a complected code of it such as connect to it, test it on line or not, get data from it, rewrite all card, correct the time of it, setup the clock, new clock and new Eastriver.
Please help me in hurry!
Thank you.
|
|
|
|
|
chansothea wrote: Please help me in hurry!
No.
I doubt anyone even knows what you're talking about, but either way, you want a site like Rentacoder. When you're paying, you can ask people to write code to your specifications. Here, people ask for help with code they have written.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Christian Graus wrote: a site like Rentacoder. When you're paying, you can ask people to write code to your specifications.
You mean "attempt to write code...", don't you?? 
|
|
|
|
|
Hi there,
In the past I used SQL commands to retrieve recordsets from my DB. Now I moved those SQL commands to stored procedures in my DB to retrieve the recordsets. The main issue I have is that I cannot set the absolute position etc on that recordset from my stored procedure. Here is what I did in the past:
Dim rsRecord As Recordset<br />
<br />
Set rsRecord = New Recordset<br />
<br />
rsRecord.Open "SELECT * FROM Customers", cnDatabase, adOpenKeyset<br />
If I open the recordset like the sample above I can get the rsRecordset.RecordCount, but if I use a stored procedure to fetch the same data into a recordset the rsRecordset.RecordCount property returns -1
Dim cmCommand As ADODB.Command<br />
Set cmCommand = New ADODB.Command<br />
<br />
Set cmCommand.ActiveConnection = cnDatabase<br />
cmCommand.CommandType = adCmdStoredProc<br />
cmCommand.CommandText = " [dbo].[FetchCustomers]"<br />
Set rsRecord = cmCommand.Execute<br />
rsRecordset.RecordCount = -1
How can I use a stored procedure to scroll through a recordset?
Thanks, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
Hi Werries
Your problem lays with the way that you are opening your recordset, rather than with the stored procedure. ADO is using the "adOpenForwardOnly" cursor-type in your second example. Try:
rsRecord.Open "[dbo].[FetchCustomers]", cnDatabase, adOpenKeyset, adLockReadOnly, adCmdStoredProcedure There are several other overloads for the Open method, including one that allows you to open the recordset from a command object.
Regards
Andy
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
Hi Andy,
Maybe I must rephrase my problem and question. I wànt to use a stored procedure to fetch the information, but the way I retrieve the recordsets does not allow me to scroll the records in the recordset. I need to be able to set the absolute position of the recordset and then fetch records from there. If I use a SQL command to retrieve the recordset like in my first attempt, I can set the absolute position of the recordset, but if I retrieve a recordset through a stored procedure the recordset does not allow me to set the absolute position on it. It raises an error 3251, ‘Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.’ If I can change the cursortype when using a stored procedute that supports bookmarks it will be great.
I hope I have explained myself better this time. Thanks for your previous reply on this matter. Any other suggestions? 
Thanks, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
I went back and modified my original reply to invoke your stored procedure. Your problem was caused by ADO using its default forward-only cursor type, rather than the keyset cursor type that you were originally using with your SQL select.
|
|
|
|
|
Hi Andy,
I did see your modification on your first reply and applied it to my code, but it seems to me I still have a forward-only cursor type. When I'm trying to set the absolute position of the recordset the same error occurs 'Current Recordset does not support bookmarks....'
I still don’t have a solution for my problem, but I'm thinking of trying a whole different way of implementing what I actually want to do. But if you've got a solution of why the recordset still have a forward-only cursor type, I’ll be glad to hear it from you. I appreciate all your help.
Have a nice weekend,
Regards, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
Hi Werries
If ADO doesn't think that a requested cursor-type is possible then it silently changes to another type.
I don't normally use bookmarks - so its not something that I have a problem with. I normally use GetRows() to grab the recordset's contents into a 2-dimensional array. This allows me to close the recordset and grab any output parameters.
Have a good weekend.
Regards
Andy
PS: Have you set "Set nocount on" in the stored procedure?
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
I have a application build around VB6 for windows, I want to change that application to VB .NET to run for Win CE. Can I do with the migration procedure?Or by any other means?
Thanx in advance...
birajendu
CyberG India
Delhi
India
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
