473,394 Members | 1,221 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

a2k - how to code a simple version check over the net

Thought it might be a cool feature to allow my users to click a button,
and connect to a webpage that would tell them if a more recent version
was available.

I can create a button that opens a webpage but it would be nice if it
could compare what they have with what I say is available, so I can say
something like "You have version 1.2. Version 1.3 is now available".

Any ideas?
Nov 13 '05 #1
3 1383
Deano wrote:
Thought it might be a cool feature to allow my users to click a button,
and connect to a webpage that would tell them if a more recent version
was available.

I can create a button that opens a webpage but it would be nice if it
could compare what they have with what I say is available, so I can say
something like "You have version 1.2. Version 1.3 is now available".

Any ideas?


When I "build" I create/update a Current Project "CurrentBuild" property
as follows:

'*******
With CurrentProject.Properties
CurrentBuild = .Item("CurrentBuild") + 1
.Add "CurrentBuild", CurrentBuild
.Item("CurrentBuild").Value = CurrentBuild
End With
'*******

I also update the htm page:

'*******
Private Sub UpdateCurrentBuildFile(ByVal cb As Long)
Dim FileNumber As Integer
Dim HTML As String

On Error GoTo UpdateCurrentBuildFileErr

FileNumber = FreeFile()

HTML = String(FileLen(CurrentBuildTemplatePath), vbNullChar)
Open CurrentBuildTemplatePath For Binary As #FileNumber
Get #FileNumber, , HTML
Close #FileNumber

Kill CurrentBuildPath

FileNumber = FreeFile()

Open CurrentBuildPath For Binary As #FileNumber
Put #FileNumber, , Replace(HTML, "number", CStr(cb))
Close #FileNumber

UpdateCurrentBuildFileExit:
Close
Exit Sub

UpdateCurrentBuildFileErr:
With Err
MsgBox .Description, vbCritical, "Error # " & .Number
End With
Resume UpdateCurrentBuildFileExit
End Sub
' *******

and the code of my form to check the build is

'*******
Private Sub Form_Load()
With DoCmd
.Restore
.RunCommand acCmdSizeToFitForm
End With
Me.Caption = "The build number of the current file is " &
CurrentProject.Properties("CurrentBuild").Value & "."
End Sub

Private Sub Form_Open(Cancel As Integer)
Me.wbHDSBHelp.Navigate "http://ffdba.com/ESO/CurrentBuild.htm"
End Sub
' *******

wbHDSBHelp is a web browser control

--
--
Lyle
--
From ADO28.chm

Deprecated Components
Each of the following components is considered obsolete. While these
components are still supported in this release of the Microsoft® Data
Access Components (MDAC), they may be removed in the future. When
writing new applications, you should avoid using these deprecated
components. When modifying existing applications, you are strongly
encouraged to remove any dependency on these components.

.....

Jet and Replication Objects (JRO)
The Microsoft Jet OLE DB Provider and other related components were
removed from MDAC 2.6. Microsoft has deprecated the Microsoft Jet
Engine, and plans no new releases or service packs for this component.
As a result, the Jet and Replication Objects (JRO) is being deprecated
in this release and will not be available in any future MDAC releases.

.....
Nov 13 '05 #2
Lyle Fairfield wrote:
Deano wrote:
Thought it might be a cool feature to allow my users to click a
button, and connect to a webpage that would tell them if a more
recent version was available.

I can create a button that opens a webpage but it would be nice if
it could compare what they have with what I say is available, so I
can say something like "You have version 1.2. Version 1.3 is now
available".

Any ideas?


<code snipped>

Thanks for that Lyle, that's got me thinking. Not sure about the web
control as I like to ship with as few additonal controls as possible.
Nov 13 '05 #3
Deano wrote:
Thanks for that Lyle, that's got me thinking. Not sure about the web
control as I like to ship with as few additonal controls as possible.


It's a good point; I am doing my help with remote html files read
through the web control however. In this way I can make them (very)
dynamic and responsive to users questions, needs, stubborness etc ...
and pretty them up too.

--
Lyle
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

242
by: James Cameron | last post by:
Hi I'm developing a program and the client is worried about future reuse of the code. Say 5, 10, 15 years down the road. This will be a major factor in selecting the development language. Any...
65
by: Skybuck Flying | last post by:
Hi, I needed a method to determine if a point was on a line segment in 2D. So I googled for some help and so far I have evaluated two methods. The first method was only a formula, the second...
8
by: | last post by:
Wel, I am rebuilding the VC# 2002 project that I have deployment problems with the 2003 version, hoping this solves the problems, but now I encounter this wierd bug??? If I have the project, and...
6
by: TPJ | last post by:
Help me please, because I really don't get it. I think it's some stupid mistake I make, but I just can't find it. I have been thinking about it for three days so far and I still haven't found any...
4
by: jason.awlt | last post by:
Greetings, I recently being bugged by the following error on my DB2. SQL0902C SQLSTATE = 58005 Reason Code = 14 This error comes out everytime i tried to insert some record to a table...
232
by: robert maas, see http://tinyurl.com/uh3t | last post by:
I'm working on examples of programming in several languages, all (except PHP) running under CGI so that I can show both the source files and the actually running of the examples online. The first...
11
by: John | last post by:
Access 2003 After my app is finished I'd like to create an mde file. Therefore my db has to be made in the 2002-2003 format. So I've created a new mdb (default in 2000 format), I converted this...
24
by: David | last post by:
Hi list. What strategies do you use to ensure correctness of new code? Specifically, if you've just written 100 new lines of Python code, then: 1) How do you test the new code? 2) How do...
4
by: David | last post by:
Hi list. Do test-driven development or behaviour-driven development advocate how to do higher-level testing than unit testing? types of testing: unit integration system
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.