|
Hi,
I had some problem with CR which I had posted earlier.
I needed to access a database in LAN environment...it works fine, accept some of the reports.
The solution I got is I need to give the connection information for the report.
I got the following code....
With crConnectionInfo
.ServerName = "YOUR SERVER NAME"
.DatabaseName = "YOUR DATABASE NAME"
.UserID = "YOUR DATABASE USERNAME"
.Password = "YOUR DATABASE PASSWORD"
End With
Now I just want to know what will be my server name, for access database?
Normally, what I used to do is::: I have the database in one server....and i access it through my connection string as follows
provider=......data source=\\MyServer\c:\aa\db1.mdb....;
So in this case...what will be the server name and database name?....Should I give server name as MyServer and database as c:\aa\db1.mdb?
Or should I give the full database path in DatabaseName like i used to do earlier(\\MyServer\c:\aa\db1.mdb).
Please help me out
-----------------------------
I am a beginner
|
|
|
|
|
Hi guys,
I'm supposed to develop a procedure to send SMS from a VB6 app. I have done a lot of research on this. Have information but I honestly dont know what is the major things to do in such an app.
I do not want to connect my phone to my PC, I really just want to send any cell number(regardless the network) to the procedure and have an sms sent 2 that number.
Please assist.
Thanks
|
|
|
|
|
|
Hi
I am looking for a way, to add another shortcut to Windows.
Ctrl-C does copy to clipboard
Ctrl-V does paste from the clipboard
I am looking to add another shortcut - e.g Ctrl-W - that will do the following:
1 - get the last entry from the clipboard
2 - add CRLF
3 - append to it the selected text
4 - copy it back to the clipboard
I am not a Windows developer. I only know VBA.
can someone help on this issue? I saw many posts on the web asking for COPY-APPEND to the clipboard but could not find any solution.
Actually I need it on IE only, But I saw that many are looking for this shortcut to be part of Windows.
Is it so complicated ?
many thanks for any help !!!
|
|
|
|
|
You can use Clipboard.Setdata while Pressing Key CTRL + W.
or Use Sendkeys({CTRL} + C ) while pressing CTRL + W key.
If you can think then I Can.
|
|
|
|
|
thanks for reply but I think I missed you.
Do I need to program it?
I would like to have this copy-append as part of windows. Not in my application.
link ctrl-c, ctr-v let us have ctrl-? to append what's selected to the last clipboard.
hope I am clear.
thanks again
|
|
|
|
|
In the key down event use the e argument to get the details of the key press combination
Then use your own suggestions
1 use the clipboard object to get the data into a var
2 clear the clipboard
3 add crlf to the var
4 add the selected text to the var
5 set the text into the clipboard object
6 informa the user it is ready for pasting.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Just wondering?
Are you still looking? The replies didn't quite enlighten me. I think one was talking about javascript, because of the usage of "var". Sure, you could do it with javascript, on a website... But what about OS-wide.
I don't know, does anyone have an answer, if not let's think about it!
|
|
|
|
|
I wrote a small program in vb.net that calls an external process.
I wanted to share this application between 40 users so I putted the content of the dir DEBUG (visual studio express 2008) into a shared folder and I used caspol to make it Trusted.
What I call in my app is an exe of a platform (PEBL) [http://pebl.sourceforge.net/battery.html] and I use it to execute some proprietary (PEBL) files.
What is STRANGE is this:
-if I share the same application on a shared dir and each client click on it executing the software I am not able to launch the external software for more than a single pc at time.
- IF I use a different publish for my vb.net application (that is, for K users, K different local(or remote) copies of my application, I am able to execute the same process contemporaneously
WHY THIS?
What I see is that if I use a single application shared on a common path [ for clear advantages of centralization] (example: just what you see in "debug" ] on a shared dir the process called does not allow for another client to execute the same external program. IS IT CORRECT? why should I use 40 different copies of my sw with 40 people?
IS IT CORRECT to share the same apps simply coping what includerd in debug?
|
|
|
|
|
HI Nico can you go through my code and see if you can help me on this
|
|
|
|
|
Hi
I've create a check box array, want to display a message box - moment the user clicks the 3rd check box
Private Sub step19() ' Action Item PGR
Dim conns1 As New ADODB.Connection
Dim rss1 As New ADODB.Recordset
Dim idexs1 As Integer
Dim sss1 As String
''On Error GoTo errorHandler
conns1.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & App.Path & "\EPMTDB.mdb;" & _
"Uid=;Pwd=;"
Set rss1 = New ADODB.Recordset
rss1.CursorType = adOpenKeyset
rss1.LockType = adLockPessimistic
rss1.Open "select * from StepSI", conns1
idexs1 = 0
For i = 0 To 2
Check(i).Visible = True
Next
For i = 0 To 2
Check(i).Caption = rss1!APGR
rss1.MoveNext
Next
' here I need the code, when the user click on 2nd check box gets the message box
For i = 3 To 9
Check(i).Visible = False
Next
rss1.Close
conns1.Close
End Sub
modified on Wednesday, May 27, 2009 8:09 PM
|
|
|
|
|
Where is this sub being called from? It would appear that it's just setting some values for your checkboxes, it's not handling the on click event of any checkbox.
You would need something like
private sub chkbox2_click (ByVal sender As Object, ByVal e As System.EventArgs) Handles chkbox2.Click
msgbox "you clicked checkbox 2"
end sub
|
|
|
|
|
Thanks
This does work, however in my program, there ate multiple conditions,
let me explain you in this way:
i have a list box that has 5 categories
1. if you select the first category, you get 5 check box and the message needs to be displayed ONCE the user clicks on the 3rd check box
2. if the user selects the second category, you get 10 check boxes and the message needs to be appeared , ONCE the uset checks the 7th check box with the different message
i tried the prevous code, ever time the 2nd checkbox is checked it is trowing the message
Please help.
|
|
|
|
|
hi there,
I am in a little trouble here. I have a database with employee names details etc.. and I also have a child sub table for their absence. what I want my program to do:
I have a list box that loads full employee names and selects the record
once I click on it I want it to display the info from a child sub table according to the name selected.
I already know how to write to the child sub table but do not know how to display it.
any help would be appreciated.
the code I have written so far fills up the list box with all absence disregarding individual record.
this is what I've written to insert the record into the child sub table. What I want is to display all the things that I add into the list box. some man suggested to have a look at "master-detail" on google but unfortunately the code is too complicated to be able to study it in short time. I need it ASAP as I cannot start doing another piece once this is sorted.
thanks to all people who help
Holidays = txtholiday(0).Text
Sickness = txtSickness(0).Text
Off = txtOff(0).Text
Holidays1 = txtholiday(1).Text
Sickness1 = txtSickness(1).Text
Off1 = txtOff(1).Text
AbsenceID = txtid(0).Text
intDay = cboDays.Text
conConnection.Open
With cmdCommand
.ActiveConnection = conConnection
.CommandText = "SELECT * FROM tblmain WHERE fullname = '" & fullname & "';"
.CommandType = adCmdText
End With
With rstRecordSet
.CursorType = adOpenStatic
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Open cmdCommand
End With
With cmdCommand
.ActiveConnection = conConnection
.CommandText = "INSERT into tblAbsence (AbsenceID, Holidays, Sickness, Off, Holidays1, Sickness1, Off1, DaysTaken) Values ('" & AbsenceID & "', '" & Holidays & "', '" & Sickness & "', '" & Off & "', '" & Holidays1 & "', '" & Sickness1 & "', '" & Off1 & "', '" & intDay & "')"
.CommandType = adCmdText
.Execute
End With
|
|
|
|
|
Hello Friends,
I like to accept a string and convert the case of the characters using vb .net
eg Input String : aBcDE
Output String : AbCde
depanding on the user selection
Thanks In Advance
Praveen
modified on Wednesday, May 27, 2009 5:17 PM
|
|
|
|
|
OP before modficiation
<blockquote class="FQ"><div class="FQA">Member 4514218 wrote:</div> Hello Friends,
I like to accept a string and convert the case of the characters using vb .net
eg Input String : aBcDE
Output String : ABCDE
Output String : abcde
depanding on the user selection
Thanks In Advance
Praveen </blockquote>
My Response
Check out the <code>String.ToUpper()</code> and <code>String.ToLower()</code> methods, you can use <code>Radioboxes</code> for the selection,
and read your class book before bringing homework here.
The OP first asked how to make a string either all upper or all lower case based off user selection, which is why the above post exists here. Don't want you guys thinking I posted random garble
See post below for response to *current* thread.
modified on Wednesday, May 27, 2009 5:39 PM
|
|
|
|
|
EliottA wrote: Don't want you guys thinking I posted random garble
Nah. Just making up random questions now?
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Luc Pattyn wrote: Just making up random questions now?
Those are the only ones I know the answer to
|
|
|
|
|
Keep up the good work.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
So you just want to flip each case?
Way to change the requirements after I answer your other post.
It usually goes against me to do someone's homework for them, and after I posted my other reply I initially had regret, going against my common practice.
This time I stick to it, go read your book or you will fail your course.
|
|
|
|
|
Easy. Convert to ASCII, XOR all letters with 0x20, convert back to Unicode.
Now what should happen with some specials, such as the trademark and registered signs?
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Need to be able to specify a month, date, and year for a db record and use the data later to produce results based on monthly/yearly production. New to programming, have read a bit about date functions and I see a couple different ways I could go about this. Was wondering if anyone wants to steer me to the easiest, or most efficient method of going about designing the logic.
Example
Loan office has loans working, or closed. Want to be able to generate monthly/yearly projected and closed figures.
What is the best way for me to work with the dates involved?
Thanks in advance for the advice.
|
|
|
|
|
I'd store the date information in the database as Dates. You can generate reports between any two dates you want.
Or are you asking how to get the date information from the user?? Perhaps the DatePicker control in the ToolBox?
Your question is pretty vague so it's difficult to come up with a proper answer.
|
|
|
|
|
Very vague, I understand and apologize. My only concern with simply storing the info as date in the db is that I want the program to upon loading, select certain records, say for the current month or current year, and perform some basic mathematical calculations etc. So with my extremely limited programming knowledge, I guess I am not sure how I could go about pulling say 3 of 10 records based on the current month I am in or current year etc. Does that help or only make only more vague =]
|
|
|
|
|
It barely helps, but you're just retrieve records for the current month quite easily. Code the SQL query to retrieve records between two dates. You first generate a date using the current month and year, just adding the 1st of the month to create something like 5/1/2009. Your second date would be todays date. Then use those as the bounds for the query and retrieve youre records. You can even do some of the math in the query if need be.
But, if you're new to programming, I would seriously pickup a beginners book on VB.NET before going forward with this project. The .NET Framework is pretty huge and there's a lot to learn that can make it much easier to code your app instead of guessing at things.
|
|
|
|