Search the web
Sign In
New User? Sign Up
vbhelp · Visual Basic Help Center Forum
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 15833 - 15864 of 15864   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Show Message Summaries   (Group by Topic) Sort by Date ^  
#15833 From: "stv_gch" <stv_gch@...>
Date: Sun Apr 5, 2009 1:31 pm
Subject: Re: Equivalent to Lotus LIST
stv_gch
Offline Offline
Send Email Send Email
 
It is hard to explain what Lotus fits into, it is compliant with all OOPS
standards for BASIC, XML, JAVA, JAVASCRIPT etc and on top of that has it's own
formula language.

Most people will say that Lotus LOOKS like a childs paint program gone horribly
wrong, and they would be right until you realise that you can reskin the
databases underneath the client itself.

LotusScript is based on BASIC as Lotus (before IBM bought it) was heavy in
promoting w3c and compliance with the devleopment lanuguages of the day.

Anyway, enough about that.



--- In vbhelp@yahoogroups.com, "Ulrike Haupt" <rica@...> wrote:
>
> Rob,
> the 'specs' that are provided to me for many 'problems' are oten even more
obscure. <no offense intended>
>
> Isn't Lotus Notes an objct oriented type of db?
>
> And the 'result' looks like a cross-tab or pivot table.
>
> Sometimes it needs a couple of steps to get from where one is to where you
want to to go even when others want it done in a quantum leap.
>   ----- Original Message -----
>   From: stv_gch
>   To: vbhelp@yahoogroups.com
>   Sent: Saturday, April 04, 2009 11:10 PM
>   Subject: [vbhelp] Re: Equivalent to Lotus LIST
>
>
>   Gee Rob, thats a great idea if this wasn't a programmers group. :{
>
>   --- In vbhelp@yahoogroups.com, Rob <robhp@> wrote:
>   >
>   > Pretend for the moment that you (or the world) had never seen Lotus Notes.
>   > And pretend that you are an employee of a company (business worker, not
>   > a programmer).
>   > And there is a programmer in your IT section (probably in another country)
>   > Write up a spec (your needs, not pseudo code) and send it to him.
>   > And send it to us.
>   >
>   > Regards,
>   > Rob
>   >
>   > stv_gch wrote:
>   > >
>   > > Lotus Notes has a collection of objects that allows you to use a
>   > > string to refer to the index.
>   > > Is there a VB6 equivalent function or a class that exists?
>   > >
>   > > What I am doing is going through a grid controls contents that isn't
>   > > sorted, building a string of values that the user has entered like;
>   > > (I'll separate the columns with commas for this example)
>   > >
>   > > Make, Result
>   > > Ford, A
>   > > Ford, B
>   > > Ford, C
>   > > GMH , A
>   > > GMH, D
>   > >
>   > > The resultant list will have; (I am using the ~ as a deliminator)
>   > > The code would say;
>   > > Code:
>   > >
>   > > Car(Make) = Car(Make) & "~" & Result
>   > >
>   > > Which if you debugged would look like;
>   > > Code:
>   > >
>   > > Car("Ford")= "A~B~C"
>   > > Car("GMH")= "A~D"
>   > >
>   > > The Lotus example is this in case my example above doesn't make sense.
>   > >
>   > > Code:
>   > >
>   > > ' Make string comparison case insensitive
>   > > ' in this module.
>   > > Option Compare NoCase
>   > > ' Declare a list---myList---to hold first names.
>   > > ' The list tags will be unique IDs.
>   > > Dim myList List As String
>   > > Dim newTag As String
>   > > Dim newValue As String
>   > > ' Put some elements in the list.
>   > > myList("A1234") = "Andrea"
>   > > myList("A2345") = "Vera"
>   > > myList("A3456") = "Isabel"
>   > > ' Ask the user to enter an ID and a name.
>   > > newTag$ = InputBox$("Please enter your ID:")
>   > > newValue$ = InputBox$("Please enter your first name:")
>   > > ' Add a new element to the list with
>   > > ' the user's ID as the list tag and the user's name as
>   > > ' the value of the new element.
>   > > myList(newTag$) = newValue$
>   > > Print myList(newTag$)
>   > > ' Output: the name that the user entered
>   > >
>   > > Thanks for any assistance with this.
>   > >
>   > >
>   >
>   >
>   >
>   > [Non-text portions of this message have been removed]
>   >
>
>
>
>
>
>   __________ NOD32 3988 (20090404) Information __________
>
>   This message was checked by NOD32 antivirus system.
>   http://www.eset.com
>
>
> [Non-text portions of this message have been removed]
>

#15834 From: "Michael Hodge" <vbhelp@...>
Date: Mon Apr 6, 2009 4:12 pm
Subject: VB6 and Vista
braxtoncotta...
Offline Offline
Send Email Send Email
 
For better or for worse, I have Vista on a Laptop and XP on a Desktop.
Hitherto, I have programmed on the XP Desktop. However, I should like to use
my VB6, Professional Edition, on the Vista Laptop as well.

According to the Compatibility list, there is no problem. But when I try to
install VB6, lo and behold there is a compatibility problem. The various
so-called "Solutions" don't seem to work either.

Has anyone any advice - other than removing Vista! - or do I have to try to
learn VB 2008 a few days before my 75th birthday?

Michael

#15835 From: "Tim Rupp" <tim.rupp@...>
Date: Mon Apr 6, 2009 4:28 pm
Subject: RE: VB6 and Vista
timrupp804
Offline Offline
Send Email Send Email
 
You did install VB6 on your Vista machine under an Administrator account,
correct?



A few things that may help for the installation:

* Cancel any Visual Studio auto-run.

* Navigate to the CD/DVD and find the Setup.exe file.

* Right-click and select Properties, and on the Compatibility Tab, set
the following:

* Check the 'Run this program in compatibility mode for:"
* Select Windows NT 4 in the drop-down
* Check 'Disable Visual Themes'
* Check 'Disable desktop composition'
* Check 'Disable display scaling ...'

* Right-Click again and select 'Run as administrator'

I've got VB6 installed on a Vista laptop and haven't experienced any issues
with it.



Also, you're never too old to learn a new trick or two.so my 86 year-old
golfing buddy tells me!





/tr





   _____

From: vbhelp@yahoogroups.com [mailto:vbhelp@yahoogroups.com] On Behalf Of
Michael Hodge
Sent: Monday, April 06, 2009 12:13 PM
To: vbhelp@yahoogroups.com
Subject: [vbhelp] VB6 and Vista



For better or for worse, I have Vista on a Laptop and XP on a Desktop.
Hitherto, I have programmed on the XP Desktop. However, I should like to use
my VB6, Professional Edition, on the Vista Laptop as well.

According to the Compatibility list, there is no problem. But when I try to
install VB6, lo and behold there is a compatibility problem. The various
so-called "Solutions" don't seem to work either.

Has anyone any advice - other than removing Vista! - or do I have to try to
learn VB 2008 a few days before my 75th birthday?

Michael





[Non-text portions of this message have been removed]

#15836 From: "burkleyd" <burkleyd@...>
Date: Mon Apr 6, 2009 5:03 pm
Subject: Re: VB6 and Vista
burkleyd
Offline Offline
Send Email Send Email
 
--- In vbhelp@yahoogroups.com, "Tim Rupp" <tim.rupp@...> wrote:
> [trimmed by administrator - please remember to TRIM YOUR POSTS]

I don't know how true it is but I've heard tell...
starting with Vista (and beyond) software development
tools such as VB will need to be installed on a drive
that is NOT the same drive as the operating system.

For instance Vista is installed on your C:\ drive.
If possible... install Visual Basic on the D:\ drive.
But this isn't always possible. So Tim's suggestion
might be a better solution in just such a case.

David

#15837 From: "Michael Hodge" <vbhelp@...>
Date: Tue Apr 7, 2009 3:29 pm
Subject: Re: VB6 and Vista
braxtoncotta...
Offline Offline
Send Email Send Email
 
Many thanks, Tim and David. Before receiving your kind replies, I tried yet
again. This time I ignored every warning saying "This program has known
compatibility problems". The result? VB6 installed on the Vista Laptop!

I had further problems with the Service Packs. I think that I partially
solved this by copying VB6.exe from my Desktop, replacing the version just
installed on the Laptop. I was then told that the Laptop's VBA6.dll was the
wrong version, so I copied that too. Everything "seems" to be working OK. If
you can think of anything else that I ought to be doing (in order to get VB6
working fully on the Laptop), please let me know. Meanwhile, I shall keep
Tim's detailed response on file, in case my 'Installation + Heath Robinson
top-up' proves to be unworkable.

One interesting thing. Every CD inserted in the Laptop was greeting with
"unknown publisher". Has Windows never heard of Microsoft!?

Meanwhile, many thanks.

Michael

#15838 From: "Shawn K. Hall" <vb@...>
Date: Wed Apr 8, 2009 7:07 am
Subject: RE: Re: VB6 and Vista
vb_shawn
Online Now Online Now
Send Email Send Email
 
> ...I tried yet again [installing vb6 onto Vista]. This time
> I ignored every warning saying "This program has known
> compatibility problems". The result? VB6 installed on the
> Vista Laptop!

Yes, you will. :(

I've had luck by running the installer in XP compatibility (copy the
entire disk to a drive and right click, changing compatibility options
for the installer, run that) then, as soon as it creates the directories
under Programs, change the permissions for the new folder to "everyone +
full control".

Even so, I wouldn't recommend using VB6 directly on Vista if it can be
helped. Instead, use a WinXP VM or something, so you can completely
avoid compatibility and other Vista "issues". I've come to really love
Virtual Machines. They make computing actually work today.

-Shawn

#15839 From: Rob <robhp@...>
Date: Wed Apr 8, 2009 7:28 am
Subject: Re: Re: VB6 and Vista
crombierob
Offline Offline
Send Email Send Email
 
Hi Shawn,

Is there a free one that you recommend ?

Regards,
Rob


Shawn K. Hall wrote:
>
> Even so, I wouldn't recommend using VB6 directly on Vista if it can be
> helped. Instead, use a WinXP VM or something, so you can completely
> avoid compatibility and other Vista "issues". I've come to really love
> Virtual Machines. They make computing actually work today.
>
> -Shawn
>


[Non-text portions of this message have been removed]

#15840 From: "Shawn K. Hall" <vb@...>
Date: Fri Apr 10, 2009 12:08 am
Subject: RE: Re: VB6 and Vista
vb_shawn
Online Now Online Now
Send Email Send Email
 
Hi Rob,

> Is there a free one that you recommend ?

While I've used a number of different engines, VMware tends to be the
most powerful:
   http://www.vmware.com/download/desktop_virtualization.html
...though it's a memory hog (even when a VM isn't running) and doesn't
behave very well sometimes. The "player" is free, and you can use a
CD/DVD image to boot and install an operating system into it. I've done
it with a half dozen variants of Linux, every version of Windows, and
MacOSX (though MacOSX was a HUGE PITA).

I personally prefer to use Virtual PC:
   http://www.microsoft.com/windows/products/winfamily/virtualpc/
In my experience, VPC manages memory better, and doesn't require stuff
to run in the background all the time (even when not using it). It, too,
can run all sorts of operating systems including XP, Vista, Linux &
MacOSX.

They're both free, unless you're going all out and need super-duper
ultra-powerful features (unlikely). Check out the free versions first,
as features from the paid version have only been required for one
project I had (years ago), and I found that using a physical system
instead was cheaper and more reliable. I've been using virtual machines
for about 6 years now for almost all of my app and browser testing.
They're a huge time saver (not to mention MONEY saver).

-Shawn

#15841 From: Rob <robhp@...>
Date: Fri Apr 10, 2009 10:17 am
Subject: Re: Re: VB6 and Vista
crombierob
Offline Offline
Send Email Send Email
 
Hi Shawn,

Thanks for taking the time to respond.
My PC's are old (2002 2004), and not overflowing with memory.
Thus I will check out Virtual PC:

Thanks again,
Rob



Shawn K. Hall wrote:

Hi Rob,

  > Is there a free one that you recommend ?

While I've used a number of different engines, VMware tends to be the
most powerful:
http://www.vmware.com/download/desktop_virtualization.html
<http://www.vmware.com/download/desktop_virtualization.html>
...though it's a memory hog (even when a VM isn't running) and doesn't
behave very well sometimes. The "player" is free, and you can use a
CD/DVD image to boot and install an operating system into it. I've done
it with a half dozen variants of Linux, every version of Windows, and
MacOSX (though MacOSX was a HUGE PITA).

I personally prefer to use Virtual PC:
http://www.microsoft.com/windows/products/winfamily/virtualpc/
<http://www.microsoft.com/windows/products/winfamily/virtualpc/>
In my experience, VPC manages memory better, and doesn't require stuff
to run in the background all the time (even when not using it). It, too,
can run all sorts of operating systems including XP, Vista, Linux &
MacOSX.

They're both free, unless you're going all out and need super-duper
ultra-powerful features (unlikely). Check out the free versions first,
as features from the paid version have only been required for one
project I had (years ago), and I found that using a physical system
instead was cheaper and more reliable. I've been using virtual machines
for about 6 years now for almost all of my app and browser testing.
They're a huge time saver (not to mention MONEY saver).

-Shawn


[Non-text portions of this message have been removed]

#15842 From: "Shawn K. Hall" <vb@...>
Date: Sat Apr 11, 2009 3:13 pm
Subject: RE: Re: VB6 and Vista
vb_shawn
Online Now Online Now
Send Email Send Email
 
> Thanks for taking the time to respond.
> My PC's are old (2002 2004), and not overflowing with memory.
> Thus I will check out Virtual PC:

You're welcome, of course.

It occurs to me, too, that you should check out the prebuilt "tester"
VHD's (virtual hard drives) for various flavors of XP and Vista. While
they expire after a given period (usually 6 months, but the current
images expire at the end of the month), they are excellent baseline
operating systems for testing apps and websites:

http://www.microsoft.com/downloads/details.aspx?FamilyId=21EABB90-958F-4
B64-B5F1-73D0A413C8EF

-Shawn

#15844 From: "Michael Hodge" <vbhelp@...>
Date: Mon May 18, 2009 5:14 pm
Subject: Desktop Icon
braxtoncotta...
Offline Offline
Send Email Send Email
 
By including Autorun.inf on the CD, I have eased the process of the few
friends who are installing my VB6 program. While written using XP, it seems
to be working on 98SE, XP and Vista. I should like to go one step further. I
should like the running of the CD to install automatically a desktop icon
for this program.

Is this possible? If so, it is part of Autorun.inf or the compiled
SetUp.exe? A few hints - or even some code - would be appreciated, as every
attempt I have made so far has met with failure!

Michael

#15845 From: "burkleyd" <burkleyd@...>
Date: Mon May 18, 2009 5:46 pm
Subject: Re: Desktop Icon
burkleyd
Offline Offline
Send Email Send Email
 
--- In vbhelp@yahoogroups.com, "Michael Hodge" <vbhelp@...> wrote:
>
> By including Autorun.inf on the CD, I have eased the process of the few
> friends who are installing my VB6 program. While written using XP, it seems
> to be working on 98SE, XP and Vista. I should like to go one step further. I
> should like the running of the CD to install automatically a desktop icon
> for this program.
>
> Is this possible? If so, it is part of Autorun.inf or the compiled
> SetUp.exe? A few hints - or even some code - would be appreciated, as every
> attempt I have made so far has met with failure!
>
> Michael
>
I don't know if this will work or not but...
it supposedly can be done using a script.

http://www.msvisual.com/API_to_modify_OR_create_desktop_short_cut-ttopic25321.ht\
ml

Scroll down to "mr unreliable" script solution.
(Posted: Wed Dec 22, 2004 11:15 pm)

David

#15846 From: saqib rizvi <sqbrizvi@...>
Date: Fri Jun 5, 2009 5:50 pm
Subject: Re:questions
sqbrizvi
Offline Offline
Send Email Send Email
 
Dear all
 
I am using VB 6 as front end and access as back end for the database. i have fol
questions
 
1. i have password my access db file and  i want to use the same password to
open that database while remaining in aceess. I have  used  data object in vb.
2.how can i use predictive text in combo dbcombo
 
 
could any one answer above questions
 
riz




[Non-text portions of this message have been removed]

#15847 From: Iqbal hossain <iqbalcse2000@...>
Date: Wed Jun 10, 2009 7:58 am
Subject: Re: Re:questions
iqbalcse2000
Offline Offline
Send Email Send Email
 
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Jet
OLEDB:Database Password=123;Data Source=C:\spt.mdb;"

where 123 is password
 
for more informaiton
http://support.microsoft.com/kb/191754



Regards,

Md. Iqbal Hossain

http://www.SabaSafa.com

Do you need a coder?

--- On Fri, 6/5/09, saqib rizvi <sqbrizvi@...> wrote:

From: saqib rizvi <sqbrizvi@...>
Subject: [vbhelp] Re:questions
To: vbhelp@yahoogroups.com
Date: Friday, June 5, 2009, 11:50 PM



















Dear all

 

I am using VB 6 as front end and access as back end for the database. i have fol
questions

 

1. i have password my access db file and  i want to use the same password to
open that database while remaining in aceess. I have  used  data object in vb.

2.how can i use predictive text in combo dbcombo

 

 

could any one answer above questions

 

riz



[Non-text portions of this message have been removed]































[Non-text portions of this message have been removed]

#15848 From: "Michael Hodge" <vbhelp@...>
Date: Wed Jun 10, 2009 2:17 pm
Subject: VB6 and Desktop Shortcut Icons
braxtoncotta...
Offline Offline
Send Email Send Email
 
A week or so ago, I asked about how to get VB6 to add a desktop icon
automatically. My attention has been drawn to the following article. I tried
it - and it works!

http://www.freevbcode.com/ShowCode.asp?ID=3650

Michael

#15849 From: "Michael Hodge" <vbhelp@...>
Date: Wed Jul 15, 2009 5:28 pm
Subject: VB6 and Vista
braxtoncotta...
Offline Offline
Send Email Send Email
 
A VB6 program gives the User an opportunity to open a PDF file if desired.
It works with 98SE, but not with Vista, when the Message Box gives the
failed notice (see below). Any idea as to how I can get it to work with
Vista, as well as with 98SE and XP? Here is the relevant part of the code.

Private Sub cmdPDF_Click()
Dim lR As Long
Dim sFile As String
    sFile = "C:\Program Files\My Folder\My File.PDF"
    lR = ShellExecute(Me.hWnd, "Open", sFile, "", "", vbNormalFocus)
    If (lR < 0) Or (lR > 32) Then
       ' success
    Else
       MsgBox "Failed to start '" & sFile & "'", vbInformation
    End If
End Sub  'cmdPDF

The 4th line could also read: sFile = App.Path + "\My File.PDF", but with
the same result!

Michael

#15850 From: "Brad Bradfield" <b_bradfield@...>
Date: Thu Jul 16, 2009 2:59 pm
Subject: NEW TO GROUP - - -
b_bradfield
Offline Offline
Send Email Send Email
 
[Sorry if I end up with two posts here with the same name.  Something hiccuped
here.]

I'm new to this group. but have been writing personal projects in VB6 since
2001.

In the past year, I've worked on a VB6/WIA control interface for my Nikon D60
digital SLR, a complex program to calculate and display cutting speeds and feed
rates for various material on a metal lathe, and most recently I've been working
on a piece of control SW with GUI for a communications receiver over an RS232C
port.

Follow-on projects to these are control software for an amateur radio
transceiver (Icom IC-706 MK-IIG) and for a digital storage oscilloscope.

My overall real interest is mostly in amateur radio projects, but will often
jump into most anything else that lights my fire as well.

Any other amateur radio or camera software developers out there??

Brad, W5CGH

#15851 From: "Michael Hodge" <vbhelp@...>
Date: Tue Jul 21, 2009 2:07 pm
Subject: One Exe after another
braxtoncotta...
Offline Offline
Send Email Send Email
 
I have been trying to simplify - for the user - an installation CD. The
Command Button to be clicked will depend on the user's OS: 98SE, XP or
Vista.

However, for 98SE and for Vista it is necessary to install two programs (one
supplied by me; one by Microsoft). It is important that the second
(Microsoft) program is not run until the installation of my program is
complete. How can I ensure that this happens? (Some tests have suggested
that the 2nd sometimes starts before the 1st finishes.)

Private Sub cmdTwoExes_Click()
    Shell "Program1.exe", vbNormalFocus
    Shell "Program2.exe", vbNormalFocus
End Sub

Michael

#15852 From: Rob <robhp@...>
Date: Tue Jul 21, 2009 2:36 pm
Subject: Re: One Exe after another
crombierob
Offline Offline
Send Email Send Email
 
I recall there is a Wait parameter that you can add to the Shell.call
That probably won't meet all your desires.
You could then try this -
http://www.vbaccelerator.com/home/vb/code/libraries/Shell_Projects/Shell_And_Wai\
t_For_Completion/article.asp

HTH,
Rob

Michael Hodge wrote:
>
>
> I have been trying to simplify - for the user - an installation CD. The
> Command Button to be clicked will depend on the user's OS: 98SE, XP or
> Vista.
>
> However, for 98SE and for Vista it is necessary to install two
> programs (one
> supplied by me; one by Microsoft). It is important that the second
> (Microsoft) program is not run until the installation of my program is
> complete. How can I ensure that this happens? (Some tests have suggested
> that the 2nd sometimes starts before the 1st finishes.)
>
> Private Sub cmdTwoExes_Click()
> Shell "Program1.exe", vbNormalFocus
> Shell "Program2.exe", vbNormalFocus
> End Sub
>
> Michael
>
>



[Non-text portions of this message have been removed]

#15853 From: Iqbal hossain <iqbalcse2000@...>
Date: Tue Jul 21, 2009 4:17 pm
Subject: Re: One Exe after another
iqbalcse2000
Offline Offline
Send Email Send Email
 
I think this link will helpful for you.
http://www.freevbcode.com/ShowCode.Asp?ID=99

at vb.net you can use Process class with WaitForExit()

Regards,

Md. Iqbal Hossain

http://www.SabaSafa.com

Do you need a coder?

--- On Tue, 7/21/09, Michael Hodge <vbhelp@...> wrote:

From: Michael Hodge <vbhelp@...>
Subject: [vbhelp] One Exe after another
To: vbhelp@yahoogroups.com
Date: Tuesday, July 21, 2009, 8:07 PM






 





                   I have been trying to simplify - for the user - an
installation CD. The

Command Button to be clicked will depend on the user's OS: 98SE, XP or

Vista.



However, for 98SE and for Vista it is necessary to install two programs (one

supplied by me; one by Microsoft). It is important that the second

(Microsoft) program is not run until the installation of my program is

complete. How can I ensure that this happens? (Some tests have suggested

that the 2nd sometimes starts before the 1st finishes.)



Private Sub cmdTwoExes_Click( )

    Shell "Program1.exe" , vbNormalFocus

    Shell "Program2.exe" , vbNormalFocus

End Sub



Michael































[Non-text portions of this message have been removed]

#15854 From: "Michael Hodge" <vbhelp@...>
Date: Wed Jul 22, 2009 7:23 pm
Subject: Re: One Exe after another
braxtoncotta...
Offline Offline
Send Email Send Email
 
Many thanks. In the end I decided to use a simple MsgBox with vbYesNo. While
the user will (presumably) want to install my program, he or she will not
need to install the Microsoft program if it has been downloaded previously.
Now that I am using an alternative to PDW, the program loads very quickly
and the MsgBox question just entails one more click!

Michael

#15855 From: "Michael Hodge" <vbhelp@...>
Date: Mon Aug 10, 2009 10:46 am
Subject: Probably Not!
braxtoncotta...
Offline Offline
Send Email Send Email
 
A friend monitors Red Squirrels, which are very rare in the UK. I have
written two programs for her to help in her work. She wants to make the
second one available to those who report sightings to her. No objections
from me!

In essence, the program has a desktop looking like a cockpit control panel!
Entries are made by using option buttons, combo boxes and a very occasional
text box. Entries are written to more than one page, making analysis both
quicker and easier.

The problem is this: both my friend and I have MS Office installed on our
computers. So I use Excel for storage.  But most off-the-peg computers in
the UK are sold with MS Works installed - No Excel!

Both of us want to be perfectly legal. Does this mean that my friend can
only offer my program to those with MS Office? Or, to explain the Subject of
the email, is it correct to say that it is not possible for the program to
work on a computer that is without MS Excel?

Michael

#15856 From: Rob <robhp@...>
Date: Mon Aug 10, 2009 12:28 pm
Subject: Re: Probably Not!
crombierob
Offline Offline
Send Email Send Email
 
In what manner are you using 'Excel for storage' ?
Are you automating it ?
If so, then they will need to own Excel on their PC

Surely (I know you told me not to call you Surely), there is a better
method of storage that you could use ?

Regards,
Rob

Michael Hodge wrote:
>
>
> A friend monitors Red Squirrels, which are very rare in the UK. I have
> written two programs for her to help in her work. She wants to make the
> second one available to those who report sightings to her. No objections
> from me!
>
> In essence, the program has a desktop looking like a cockpit control
> panel!
> Entries are made by using option buttons, combo boxes and a very
> occasional
> text box. Entries are written to more than one page, making analysis both
> quicker and easier.
>
> The problem is this: both my friend and I have MS Office installed on our
> computers. So I use Excel for storage. But most off-the-peg computers in
> the UK are sold with MS Works installed - No Excel!
>
> Both of us want to be perfectly legal. Does this mean that my friend can
> only offer my program to those with MS Office? Or, to explain the
> Subject of
> the email, is it correct to say that it is not possible for the program to
> work on a computer that is without MS Excel?
>
> Michael
>
>



[Non-text portions of this message have been removed]

#15857 From: Rob <robhp@...>
Date: Mon Aug 10, 2009 12:32 pm
Subject: Re: Probably Not!
crombierob
Offline Offline
Send Email Send Email
 
PS  If you can get me a direct line to Bill Gates, I will tell him where
to put MS Works

Rob wrote:
>
>
> In what manner are you using 'Excel for storage' ?
> Are you automating it ?
> If so, then they will need to own Excel on their PC
>
> Surely (I know you told me not to call you Surely), there is a better
> method of storage that you could use ?
>
> Regards,
> Rob
>
> Michael Hodge wrote:
> >
> >
> > A friend monitors Red Squirrels, which are very rare in the UK. I have
> > written two programs for her to help in her work. She wants to make the
> > second one available to those who report sightings to her. No objections
> > from me!
> >
> > In essence, the program has a desktop looking like a cockpit control
> > panel!
> > Entries are made by using option buttons, combo boxes and a very
> > occasional
> > text box. Entries are written to more than one page, making analysis
> both
> > quicker and easier.
> >
> > The problem is this: both my friend and I have MS Office installed
> on our
> > computers. So I use Excel for storage. But most off-the-peg computers in
> > the UK are sold with MS Works installed - No Excel!
> >
> > Both of us want to be perfectly legal. Does this mean that my friend can
> > only offer my program to those with MS Office? Or, to explain the
> > Subject of
> > the email, is it correct to say that it is not possible for the
> program to
> > work on a computer that is without MS Excel?
> >
> > Michael
> >
> >
>
> [Non-text portions of this message have been removed]
>
>



[Non-text portions of this message have been removed]

#15858 From: "Michael Hodge" <vbhelp@...>
Date: Mon Aug 10, 2009 2:54 pm
Subject: Re: Probably Not!
braxtoncotta...
Offline Offline
Send Email Send Email
 
Thanks Rob - but I have no direct line to Bill Gates!

It might help if I added that I am using 19 pages on an Excel spreadsheet.
For instance, in this decade (2001-2010) 10 pages are needed: one per year.
The other 9 cover such areas as Habitat; Age; Numbers; Red/Grey; etc. An
entry for 2009 (for instance) would be entered on the 2009 page and also on
column 9 of the other appropriate page, making it easy to make bar charts,
etc.

The idea is that, from time to time, each voluntary sub-contractor sends the
Excel spreadsheet (as an email attachment) to "Head Office". Spreadsheets
other than Excel would do, but all participants would need to have the same
type.

You are, I think, confirming my opinion that my friend's idea will only work
with those who have Excel on their computers. I just wanted to make certain
that I am right ... for once!

Michael

#15859 From: "John Stubbe" <johnstubbe@...>
Date: Mon Aug 10, 2009 2:19 pm
Subject: Re: Probably Not!
johnstubbe
Offline Offline
Send Email Send Email
 
Will installing OpenOffice.org 3 work?


   ----- Original Message -----
   From: Michael Hodge
   To: vbhelp@yahoogroups.com
   Sent: Monday, August 10, 2009 6:46 AM
   Subject: [vbhelp] Probably Not!


     A friend monitors Red Squirrels, which are very rare in the UK. I have
   written two programs for her to help in her work. She wants to make the
   second one available to those who report sightings to her. No objections
   from me!

   In essence, the program has a desktop looking like a cockpit control panel!
   Entries are made by using option buttons, combo boxes and a very occasional
   text box. Entries are written to more than one page, making analysis both
   quicker and easier.

   The problem is this: both my friend and I have MS Office installed on our
   computers. So I use Excel for storage. But most off-the-peg computers in
   the UK are sold with MS Works installed - No Excel!

   Both of us want to be perfectly legal. Does this mean that my friend can
   only offer my program to those with MS Office? Or, to explain the Subject of
   the email, is it correct to say that it is not possible for the program to
   work on a computer that is without MS Excel?

   Michael





[Non-text portions of this message have been removed]

#15860 From: "Michael Hodge" <vbhelp@...>
Date: Wed Aug 12, 2009 5:09 pm
Subject: Re: Probably Not!
braxtoncotta...
Offline Offline
Send Email Send Email
 
Many thanks. However, I am now satisfied that the program will not work
unless the user's computer has Excel, but will work if it does.

Thanks for helping me to reach this conclusion.

Michael

#15861 From: "Ulrike Haupt" <rica@...>
Date: Wed Aug 12, 2009 6:27 pm
Subject: Re: Re: Probably Not!
ulrikehaupt
Offline Offline
Send Email Send Email
 
Michael
what is stopping you from using a jet engine backend database to collect the
data? Nobody needs to have access installed and when the stuff comes in you can
export the data to excel for the primary user
Blissings
Ulrike
from Namibia - somewhere in AFrica - thinking in db mode most of the time
   ----- Original Message -----
   From: Michael Hodge
   To: vbhelp@yahoogroups.com
   Sent: Wednesday, August 12, 2009 7:09 PM
   Subject: [vbhelp] Re: Probably Not!


     Many thanks. However, I am now satisfied that the program will not work
   unless the user's computer has Excel, but will work if it does.

   Thanks for helping me to reach this conclusion.

   Michael





[Non-text portions of this message have been removed]

#15863 From: "Michael Hodge" <vbhelp@...>
Date: Tue Nov 17, 2009 12:47 pm
Subject: Updates and installation
braxtoncotta...
Offline Offline
Send Email Send Email
 
The problem related to programs written in VB6.

When I update an EXE file, there is no problem. I send the updated *.exe to
my friends and tell them to copy it to the appropriate folder in C:\Program
Files, overwriting the previous version.

However, Versions 2 and 3 go further than updating the EXE file. They
include additional files, such as DLL and OCX. How can I send these to my
friends with instructions on how to install them? Better still, can I send
them a mini-program which will actually do the installation?

Michael

#15864 From: Rob <robhp@...>
Date: Tue Nov 17, 2009 1:56 pm
Subject: Re: Updates and installation
crombierob
Offline Offline
Send Email Send Email
 
Hi Michael,
I never install my programs.
When I do need to have an ocx or DLL, what I do is create a VB project
(and Installer) with those Dependencies in it.
The project has no code, and it's only purpose in life is to install the
controls/DLLs into the user's PC.
Running that install creates a start menu entry, which I tell the user
to ignore.
If I later  send an exe that  needs those controls, they just place the
exe into a folder and run it.
No install of the real VB project is required.
I have done this for the free SGrid2 and for vbSendMail, and it works a
charm.
HTH,
Rob

Michael Hodge wrote:
>
>
> The problem related to programs written in VB6.
>
> When I update an EXE file, there is no problem. I send the updated
> *.exe to
> my friends and tell them to copy it to the appropriate folder in
> C:\Program
> Files, overwriting the previous version.
>
> However, Versions 2 and 3 go further than updating the EXE file. They
> include additional files, such as DLL and OCX. How can I send these to my
> friends with instructions on how to install them? Better still, can I send
> them a mini-program which will actually do the installation?
>
> Michael
>
>



[Non-text portions of this message have been removed]

Messages 15833 - 15864 of 15864   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help