|
Hi,
i have a function on in a module.
i also have a button on a sheet.
how do i trigger the function when i hit the "Enter" key on the keyboard.
i tried to record a macro but this doesn't work.
any ideas?
thanks in advance.
Anoop
|
|
|
|
|
The worksheet and workbook objects don't have a KeyDown or KeyPress event, so the only way to tell would be if the sheet is set to recalcuate itself (which it normally does by default) and you handle the Calculate event.
|
|
|
|
|
Hello, My name is Jordan
I am using vb 2008 express edition
if someone could help I am really thankful but if not guess I have to
make my self push to what I can't do
My problem is if
1. How can I make save ms access database by using vb 2008?
2. How can I link a data base file to display by using a file in the database also?
Thanks and more power codeporject.com
|
|
|
|
|
Neither of your questions make any sense. Since Access is entirely file-based, everything you do to it is automatically saved. There is no "saving an Access database by using...".
Also, I think you really need to pickup a beginners book on VB.NET and ADO.NET. "Link a database file to display by using a file..." doesn't make any sense at all.
|
|
|
|
|
Hi!! How to encrypt stored procedure without using with encryption caluse.
I can encrypt with with encryprion clause. But it can be easily decarypted.
|
|
|
|
|
That's where carefully considered and implemented security of the SQL server comes into play. No, you can't create your own encrypting scheme to do this.
|
|
|
|
|
Hi All,
While sending sms message using GSM Modem (in vb.net), I am receiving CMS ERROR: 301 (because of making call).
How to resolve it? and send sms continuously....?
Thanks in advance.
modified on Monday, February 23, 2009 6:22 AM
|
|
|
|
|
|
How to browse folder not file
|
|
|
|
|
Look at the system.io.directory namespace you have everything you need there
For GUI searching there is a control 'FolderBrowserDialog' located in the toolbox under the group 'Dialogs'
|
|
|
|
|
It's giving error at line FolderBrowserDialog.ShowDialog()
|
|
|
|
|
Since my telepathic skills are a bit off today:
What error?
How did you initialize the dialog window?
How did you declare the dialog window?
Did you add the control in designer or in code?
|
|
|
|
|
I used this code for browse folder
Dim theFolderBrowser As New FolderBrowserDialog
theFolderBrowser.Description = "Please locate Directory..."
theFolderBrowser.ShowNewFolderButton = False
theFolderBrowser.RootFolder = Environment.SpecialFolder.Desktop
theFolderBrowser.SelectedPath = My.Computer.FileSystem.SpecialDirectories.ProgramFiles
If theFolderBrowser.ShowDialog = Windows.Forms.DialogResult.OK Then
txtpath.Text = theFolderBrowser.SelectedPath
Else
MessageBox.Show(theFolderBrowser.SelectedPath)
End If
It's give me error at If theFolderBrowser.ShowDialog = Windows.Forms.DialogResult.OK Then
error:Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. This exception is only raised if a debugger is attached to the process.
|
|
|
|
|
Are you using this code in a separate thread than the main (GUI) thread?
If so you can not do this (at least not that I'm aware off), all dialogs and GUI aspects of your program have to be executed by the main thread.
|
|
|
|
|
Thanks for yr continuos replay..
I don't know about separate thread than the main (GUI) thread..
|
|
|
|
|
Where are you calling this code?
Is it in the load of a form, in the click event of a button, in a separate class, in a background worker class,...?
Try adding the STAThreadattribute to the main function (the new constructor of you startupform) like the error states.
I'v never encountered this error before so you might have to google it a bit.
If you are just calling this dialog after the click of the event try adding a folderbrowserdialog onto the form by dragging it out off the toolbox (like you would do with any other control) and using that one.
|
|
|
|
|
I m calling this code in button click event..
I not found control on toolbox like folderbroswedialog.
|
|
|
|
|
What version of VS are you using because it's a standard control, it should be in your toolbox.
Check the 'All Windows Forms' group.
Or check if you can add it with the 'choose items' dialog (right click on an empty space in the toolbox).
Also check if you have the system.windows.forms reference (you should have that but check it anyway)
If you can't find it in any off those I'm afraid there is probably something wrong with your VS installation, and that's most likely why you are getting that error then.
(I just copy-pasted your code in a clean project with one form and one button and it works perfectly, so check if there is nothing wrong with the references, with your installation,...)
|
|
|
|
|
I m using VS 2005 and .Net framework 2.0. I found folderdialog in choose items.It is already checked.
But in toolbox it will not dispalyed. That's why i cn't drag from toolbox.
|
|
|
|
|
Try unchecking it, closing the choose items dialog, reopen the choose items, rechecking it.
(maybe even add it to a custom group in the toolbox so you can easily find it after (create the group then first and right click in the empty area off that group)
If this doesn't work there is something wrong with your installation of VS.
|
|
|
|
|
Thanks a lot for yr help.. I will try this . But if u find any other code than this then plz send me.
|
|
|
|
|
Is this for a web application...?
|
|
|
|
|
I might be mistaken but:
programfolder is not part of the desktopfolder
so it can't
change your rootfolder or selectedpath
|
|
|
|
|
That doesn't brake the code.
It simply means that the rootfolder property is ignored. And upon opening the dialog the program folder will be the one selected.
|
|
|
|
|
How to create a program of Scheduling Algorithm... Shortest Job First using VB6.. Thank you...
modified on Monday, February 23, 2009 9:13 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
