|
i don't think that  ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) foryou
ghlooooooooooooooooooooooo
|
|
|
|
|
I search any developper for exchange sample code Visual Basic with Adobe Product (Acrobat, InDesign, Frame)
Thank a lot.
|
|
|
|
|
Is it possible to some how pass IN a recordset to a stored procedure? I want to be able to do something like the following:
Alter Procedure uspBillClient
@RS Recordset
As
Begin
Update Bills
Set BillID = (Select MAX(BillID) From Bills) + 1
Where HoursID In RS
End
Thanks in advance for any help.
Jamie Nordmeyer
Portland, Oregon, USA
|
|
|
|
|
I have developed a client-server application in VB6 and SQL Server 7 as backend. The application works fine in our intranet. But I want to connect to the SQL Server physically located in our second office which is in different city. We have a fixed IP address. I am facing a problem in connecting to the SQL server. I have tried with DSN, provider, .udl file. How do I accomplish ths?
|
|
|
|
|
I have done this many times with the following code. Basically, I create a connection string and use ADO and OLEDB to perform the connection. Here is a code snippet.
strServerName = "127.0.0.1" ' Substitute your IP Address here
strDatabaseName = "YourDB" ' Substitute your Database name
strUserName = "YourUser" ' Substitute your UserName
strPassword = "Password" ' and Pasword here.
' Initialize the database connection string
mstrConnStr = "server=" & strServerName & ";database=" & strDatabaseName & ";provider=SQLOLEDB;uid=" & strUserName & ";pwd=" & strPassword
' Instantiate an ADO Connection Object - Trivial code left out
' Then, open the connection.
mobjConn.Open mstrConnStr
' Do some error checking here
That's all there is to it!
Rob
|
|
|
|
|
You need to make sure that the SQL Server is set up to use TCP\IP protocol and then on your client machines in the setup of the DSN you need to make sure they are trying to connect via TCP and not Named Pipes (which would only work in you intranet).
Jason Cono, MCSD
|
|
|
|
|
I'm writing a VB app that will be deployed as a service (using SRVANY) under
NT. It sits as an icon on the system tray, and puts up a visible dialog when
clicked.
The problem is that if it is started automatically before the user logs in
the Shell_NotifyIcon function can't display the icon in the system tray
because there is no task bar. Then when a user does log in there's no icon.
Can anyone tell me how I can recognise when a user has logged in (or out) so
that I can manage the icon properly?
Dave
|
|
|
|
|
.. what about something which [tries to] talks to the service which the user logged on in 'Startup' or the non-user visible eqiv.
[Like VNC]
Bon chance
Al.
ATL Student 
|
|
|
|
|
I'm sorry, I must be thick because I don't understand a word of that. What do you mean by "the service which the user logged on in 'Startup'"? What is VNC?
Dave
Dave
|
|
|
|
|
Write your service as usual, and then write secondary app which you can place in the user startup folder which tries to connect to your service.
VNC is a remote control app, which is well respected and exists under GPL I think:
http://www.uk.research.att.com/vnc/
It also gives an icon in the 'clock box' when running as a service.
Al.
ATL Student
|
|
|
|
|
Hi,
Does anyone know how to switch on (or off) antialiasing in a RichEdit
Control?
Cheers
Neil
|
|
|
|
|
I would like to use the IPAddress Control as provided by Microsoft in a VB Application. In VB, unlike VC, you can't just add the control to a form, it is just not in the toolbox.
I tried to create a new (subclassed) ActiveX control but I could not get things to work.
Does anyone know how to get this to work? Or can someone explain to me, why it can't be done (if so)?
Greetings,
Patrick
|
|
|
|
|
Does any one know how can i find if a word or excel has a macro in it from a vb program .
|
|
|
|
|
Hi everyone,
I want to make a website and to show tumbnails of images. I can't find any free component or source code to solve this problem. Does anybody to help me?
Best regards,
Leslie
|
|
|
|
|
Check http://www.vbpj.com and other link off the site for a control. You could also write a VB COM DLL to search your directory of images and write out HTML text based from your listing.
|
|
|
|
|
Is it a bug in Visual Basic? When pressing a key while holding down the ALT-key, normally a WM_SYSCHAR message is generated (WM_SYSKEYUP and WM_SYSKEYDOWN, too). Writing a program with VB, this WM_SYSCHAR message appears twice with the same wParam and lParam. The message-time differs by 10 milliseconds. VC programs do not have this phenomen.
|
|
|
|
|
I suspect theres a delay in VB and its coming up twice or your keyborad is really sensitive.
I notice key events react differently in VB.
|
|
|
|
|
How can I paste a Progress bar on top a Status bar in an MDI form.
Any help would be apprieciated.
Thanks
|
|
|
|
|
A simple way is to add a pane to the status bar as a separator and then in CMainFrame::OnCreate, create the progress control with the size of that separator. Then use CmdUI to enable it, and it is ready for use.
I can send you an example is you like.
Happy programming!!
|
|
|
|
|
Check out http://www.mvps.org/btmtz
|
|
|
|
|
If I want to save something to a file , how to do it?
|
|
|
|
|
Open "vbfordummys.txt" for output as #1
print #1,"Ive never read a vb book in my life!"
close #1
|
|
|
|
|
My project is actually lecture archiving . I suppose to screen capture whenever there is a refresh of any active application and when it does so , i will screen capture and save it into a file. However , before the screen capture occurs , there is a voice talking on a microphone which is connected to the PC and this voice is being recorded . So now I have 2 files . With these 2 files , I need to playback the voice recorded and at the same time show the captured screen output. I need to know if VB is capable of playing back the recorded voice and also show the captured screen ?
|
|
|
|
|
How about the MS Multimedia Control?
You can also use the Windows API to do this depending on what format your are saving your data to.
|
|
|
|
|
If I need to save the screen capture output into a file, and later i need to syunchronize with another file . What I mean by synchronizing with another file is that , when this screen capture file is open which shows the screen that I have just captured and at the same time I need to open another file which plays back a recorded sound file. Can VB do this ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
