|
Hi,
I am using vb.net 2008. & 2003 ms access database.
how i connect my vb.net application to remote ms access database.
Thanks & Regards
Form :-
Vikash Yadav
Mob : 773785977
|
|
|
|
|
|
Public con As New OleDbConnection("Provider=MS Remote; Remote Server=http://shpl.co.in;Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\DBSMSoft.mdb;" & "Jet OLEDB:Database Password=3010329431;")
not working
Thanks & Regards
Form :-
Vikash Yadav
Mob : 9210907172
|
|
|
|
|
|
Hello ,
I'm having this problem to where I cannot copy a root directory (e.g.,J:\, F:\, V:\, E:\ <--Common removable drive roots) of a flash drive onto a specific area of the main hard drive on my computer.
It's basically copying the drive "J:\" to "C:\Flash Backup\Current date and time" on my computer, but I'm facing a problem, while compiling and debugging it gives me the error: Could not complete operation since directory is a root directory: 'C:\'.... is there anyway around this? I'm using the following line of code to copy it: Microsoft.VisualBasic.FileIO.FileSystem.CopyDirectory(directory to copy from, where to copy, some other stuff that are boolean values)
Any help would be greatly appreciated...
Regards,
Brandon T. H.
Codeproject Member
|
|
|
|
|
Hi.
I think your problem comes with WNet security implementation exploited by your Runtime (viewing code, I denote .NET but don't know what release). Perhaps making a 'net use ...' first, could solve the IOException. If not, here you can find information : http://msdn.microsoft.com/en-us/library/Aa385413[^]
Hope it helps!
Regards
|
|
|
|
|
Hello everyone -- Need some help. I am setting up an Access Database with employee information, here's the problem...I need to search for an EmployeeID and if it does not exist I need to add it, if it does exist I need certain fields on the form to autofill. It keeps crashing on the FindFirst statement...Here is my code
Private Sub ID_AfterUpdate()
Dim strAdd As String
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("Employee Table";)
rst.FindFirst "[ID] = " & Me.ID.Value
If rst.NoMatch Then
'Add new employee information to database
rst.AddNew
rst![ID] = Me.ID.Value
rst![SocSecNo] = Me.txtSocSecNo.Value
rst![Craft] = Me.txtCraft.Value
rst![JobNo] = Me.txtJobNo.Value
rst![LastName] = Me.txtLastName.Value
rst![Suffix] = Me.txtSuffix.Value
rst![FirstName] = Me.txtFirstName.Value
rst![MiddleInitial] = Me.txtMiddleInitial.Value
rst![TWICCardNo] = Me.txtTWICCardNo.Value
rst![TWICCardExp] = Me.dteTWICCardExp.Value
rst![HireDate] = Me.HireDate.Value
rst![TermDate] = Me.TermDate.Value
rst.Update
Else
'Autofill form based on ID number entered
Me.txtSocSecNo.Value = rst![SocSecNo]
Me.txtCraft.Value = rst![Craft]
Me.txtJobNo.Value = rst![JobNo]
Me.txtLastName.Value = rst![LastName]
Me.txtSuffix.Value = rst![Suffix]
Me.txtFirstName.Value = rst![FirstName]
Me.txtMiddleInitial.Value = rst![MiddleInitial]
Me.txtTWICCardNo.Value = rst![TWICCardNo]
Me.dteTWICCardExp.Value = rst![TWICCardExp]
End If
End Sub
Any help I can get will be very much appreciated...Thanks!
Cynthia Quiroz
|
|
|
|
|
Cynthia Quiroz wrote: It keeps crashing on the FindFirst statement...
Does it crash without any hints at what might be wrong? Doesn't VB6/ADO throw an error with a message?
Cynthia Quiroz wrote:
rst.FindFirst "[ID] = " & Me.ID.Value
Two things that could go wrong, theoretically; the column ID might not exist, or Me.ID could be vbNothing (or something similar).
Did you know that you can use .NET to do this kind of stuff? You could be writing VB.NET code and call that from VB6 - that way you don't have to rewrite the code later on 
Bastard Programmer from Hell 
|
|
|
|
|
I created a reference to a file at some location in the hard drive in a vb.net application.
db_optb.Image = Image.FromFile("F:\Documents and Settings\Raza\My Documents\My Pictures\quiz_pics\opt_bg_post.jpg")
The program executed fine.
But when i took the whole project folder to another PC and executed it there it gave a 'File does not exist' exception.
Definitely the file was not there in this PC.
So can place the file in the project and refer it in such a way that taking the project to any other place does not create problems?
|
|
|
|
|
Razanust wrote: I created a reference to a file at some location
That's not a reference, that's loading something from a specific path.
Razanust wrote: So can place the file in the project and refer it in such a way that taking the project to any other place does not create problems?
Include it as a resource[^].
Bastard Programmer from Hell
|
|
|
|
|
+5, Thats how I'd approach it too
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Hi, 
The scenerio: I would like the user to enter data into a text box, before clicking continue. If the data is numeric then the program should assign it to a variable and continue as it should, but if the data is not numeric, the program should respond with a message alerting the user of this mistake.
The question: Is there anyone who can either help me directly or atleast point me in the right direction to work it out myself?
Any assistance in this matter would be greatly appreciated.
|
|
|
|
|
Use the TryParse()[^] method to check the string from the text box and take action accordingly.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Further to what Richard has said take a look at the following textbox events; textchange, validation or even the lost focus event.
You can use these events to automatically trigger your checking code without the user having to do anything.
|
|
|
|
|
Is a numuricupdown not beter. it can only contain nummeric values
|
|
|
|
|
You can you on keypress event of text box. Handle e.keychar not a character and display msg.
|
|
|
|
|
Thanks people , not able to test any of suggestions as my computer is down  , but when I get a chance, I will let you know how I get on. Thanks again for the help.
|
|
|
|
|
|
validate each keypress on the textbox
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
If InStr("0123456789", e.KeyChar) < 1 Then
e.Handled = True
End If
End Sub
|
|
|
|
|
Hello everyone:
Try to load a text document into my vb.net program using the code below. nothing happens when I click on the button to execute the method below.
Private Sub Contents_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Contents.Click
Dim openFile As System.IO.TextReader
openFile = System.IO.File.OpenText("..\User_Manual.txt")
Dim MyFileContents As String = openFile.ReadToEnd
openFile.Close()
End Sub
what am I omitting here?
Thanks in advance
|
|
|
|
|
waner michaud wrote: what am I omitting here?
Who knows? What are you expecting to happen with this code?
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Well, for one thing, you're reading the file contents into a variable... and promptly doing absolutely nothing with that variable! If you want something to happen on-screen, you'll need to provide some form of user interaction - say, put the contents of the file in a RichTextBox or something...
|
|
|
|
|
You are omitting to display read text. You can display it in message box or in label
|
|
|
|
|
Next time, put a breakpoint on the first line in the method, step through the code, line-by-line, and watch what happens in your variables and. That stuff under the Debug menu is there for a reason.
|
|
|
|
|
Thanks lot guys I got it to display into a richtextbox. But this is not I want to accomplish..
Instead of using a text file, i rather like to use a word document..
Ok now i have this scenerio:
I load a word doc using the following code:
Dim MSWord As New Microsoft.Office.Interop.Word.Application
Dim WordDoc As New Microsoft.Office.Interop.Word.Document
WordDoc = MSWord.Documents.Open("E:\Manual.doc")
MSWord.WindowState = Microsoft.Office.Interop.Word.WdWindowState.wdWindowStateMinimize
MSWord.Visible = True
Document loads fine...
However, when I click X from word to close the application, got a message saying that
1) file is being used by another application or user
when X or OK...
2) Ask to save as
click cancel the document is now closed
click X to close the word application
3) changes have been made, do you want to save...
click NO...it is now the word app is closed.
I want to close ms word application without having to go thru the three warnings mentioned above.
I am doing this to load a user manual as word document for a small application in vb.net.
On the main menu, have help button that will load this word doc as a manual..
Also, I want this document to be on read only mode so that user cannot edit the document.
Your guidance is very well appreciated..
Thanks in advance.........
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
