I ended up hardcoding the path to "Iexplore.exe" which is not good and not what I wanted to do, but the only way I could make it work.
If it works by placing the URL in the START ->> RUN box, why not with the SHELL command?
NJLDoc,
Thanks for your reply. They look very similar.
What I am thinking is that, those PCs are running multiple applications that is slowing down the loading of WORD and therefore giving me a timeout on the OLE connection.
I haven't seen it on PCs that are running just my App or less Apps at...
I got the code below to work. I even copy the current clipboard content and restore it later 'cause the spellcheck process erases it.
Anyhow, at times; there will be a delay or something that will display a "SWITCH TO application" or "RETRY" message box that appears to the...
Using the following code I found, I can read my "own" appointments for given date.
But how do I read other peoples appointments??
Application will be used by a front desk receptionist and she'll enter a name and the VB app will respond with the individual's schedule for that day...
I am wondering the same thing... I am using VB6 the CRYSTL32.OCX to do a PrintPreview. The DB connection is up during the PrintPriview. How do I terminate that connection without terminating the VB application?
Environment: VB6, SQL 7.0, CR6.0 OCX
Using the following, I can get the report to PrintPreview okay. But it keeps the connection open.
This VB app is a Print Engine, I pass data to it and it displays in PrintPreview to user.
1. How do I close the connection without terminating this VB app...
I am trying to automatically addrolemember rights to a user when their security clearance is set. I am trying the following Trigger.
----------------------------------------------------------
CREATE TRIGGER securityupdate ON MyTable
FOR UPDATE
AS
DECLARE @login varchar(50), @UPDsecurity int...
tlbroadbent,
I tried the following and although it is not coming back with an error, it's not creating the user.
------------------------------------------------------------
CREATE PROCEDURE user_create (@username as varchar(40)) AS
declare @password varchar(25)
set @password = 'password' --...
Components:
VB6
SQL7.0
I am trying to add new users to for my application, the SPROC that I calling contains:
------------------------------------------------------
use master
exec sp_addlogin
@login,
@password,
MyAppDB
use MyAppDB
exec sp_grantdbaccess
@login,
@login
exec...
SQL 7.0
I have added a user 'John' into my database via EM GUI (Databases -> Security -> Logins -> New Login).
When I try to add that user to the specific database (Databases -> DBname -> Users -> New Database Users) I get "Error 15023: User or role 'John' already exists in the current...
VB6.0
SQL 7.0
I added a new field to a table manually on my Test DB. Now I want to write a script and have it ready for Production DB implementation. The goal is to just run the script and will create the new field as well as other changes to the DB and it would be ready for the new VB code.
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.