473,804 Members | 3,068 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

cleaner ASP pages using subs

I have decided to re-write the intranet site i created over a year ago. The
coding is pretty awful and hard to read cos I made the mistake of not
putting comments in or putting crappy comments in with the code. So I have
decided to try and make things neater by grouping it into subs. So i have a
sub to create the variables, a sub for the connection etc.

Only problem is when i call my subs, it says that the variable is undefined.
If i scrap the subs and put everything into the order they would be the page
works. I use the subs it doesn't.

Can anyone offer any insight or point me to a page that describes in detail
the solution i am trying to achieve

thanks in advance

sample code below.

my page would look something like
<body bgcolor="#FFFFF F" text="#000000" link="#804040" vlink="#008080"
alink="#004080" >
<%
declareVar()
%>
<!--#include file="connectio n/connstring.inc"-->
<%
DBStrings()
%>

my subs are below as an example.
<%
sub declareVar()
'The declaration section
dim conn
dim strconn
dim physicaldbpath
dim strSQL
Dim RS
dim F
dim X

end sub
%>
<%
sub DBStrings()
set conn = server.createob ject("adodb.con nection")
conn.open strconn
strSQL = "Select Name, Number, Full_Number From AB_Dials;"
set RS = conn.execute(st rSQL)

end sub
%>
<%
sub connClose()
RS.close
set RS = nothing
conn.close
set conn = nothing
end sub
%>
Jul 19 '05 #1
13 2101
CJM
By declaring the variables within a sub, you are limiting the scope of the
variables to within that sun only...

Declare your subs in the main page, or if they are the same on every page,
put them in an external file and use #include.

To be honest, your attempt to clean up your pages may well further confuse
the problem.

If you have segments of code that are re-used on every page, eg. a header,
footer ot menu, you can obvious place these in a separate file and link them
in... but using subs doesnt sound like a very good solution...
Chris

"Steven Scaife" <nospam> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I have decided to re-write the intranet site i created over a year ago. The coding is pretty awful and hard to read cos I made the mistake of not
putting comments in or putting crappy comments in with the code. So I have decided to try and make things neater by grouping it into subs. So i have a sub to create the variables, a sub for the connection etc.

Only problem is when i call my subs, it says that the variable is undefined. If i scrap the subs and put everything into the order they would be the page works. I use the subs it doesn't.

Can anyone offer any insight or point me to a page that describes in detail the solution i am trying to achieve

thanks in advance

sample code below.

my page would look something like
<body bgcolor="#FFFFF F" text="#000000" link="#804040" vlink="#008080"
alink="#004080" >
<%
declareVar()
%>
<!--#include file="connectio n/connstring.inc"-->
<%
DBStrings()
%>

my subs are below as an example.
<%
sub declareVar()
'The declaration section
dim conn
dim strconn
dim physicaldbpath
dim strSQL
Dim RS
dim F
dim X

end sub
%>
<%
sub DBStrings()
set conn = server.createob ject("adodb.con nection")
conn.open strconn
strSQL = "Select Name, Number, Full_Number From AB_Dials;"
set RS = conn.execute(st rSQL)

end sub
%>
<%
sub connClose()
RS.close
set RS = nothing
conn.close
set conn = nothing
end sub
%>

Jul 19 '05 #2
Ok thanks, any ideas of how i can organise my pages so they are structured
nice or should i just stick with the standard way of doing it and comment it
properly. The intranet needs rewriting to use dsn less connections anyways
cos its using a dsn and the code i wrote is pap.

"CJM" <cj*******@news groups.nospam> wrote in message
news:uz******** *****@TK2MSFTNG P10.phx.gbl...
By declaring the variables within a sub, you are limiting the scope of the
variables to within that sun only...

Declare your subs in the main page, or if they are the same on every page,
put them in an external file and use #include.

To be honest, your attempt to clean up your pages may well further confuse
the problem.

If you have segments of code that are re-used on every page, eg. a header,
footer ot menu, you can obvious place these in a separate file and link them in... but using subs doesnt sound like a very good solution...
Chris

"Steven Scaife" <nospam> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I have decided to re-write the intranet site i created over a year ago. The
coding is pretty awful and hard to read cos I made the mistake of not
putting comments in or putting crappy comments in with the code. So I

have
decided to try and make things neater by grouping it into subs. So i

have a
sub to create the variables, a sub for the connection etc.

Only problem is when i call my subs, it says that the variable is

undefined.
If i scrap the subs and put everything into the order they would be the

page
works. I use the subs it doesn't.

Can anyone offer any insight or point me to a page that describes in

detail
the solution i am trying to achieve

thanks in advance

sample code below.

my page would look something like
<body bgcolor="#FFFFF F" text="#000000" link="#804040" vlink="#008080"
alink="#004080" >
<%
declareVar()
%>
<!--#include file="connectio n/connstring.inc"-->
<%
DBStrings()
%>

my subs are below as an example.
<%
sub declareVar()
'The declaration section
dim conn
dim strconn
dim physicaldbpath
dim strSQL
Dim RS
dim F
dim X

end sub
%>
<%
sub DBStrings()
set conn = server.createob ject("adodb.con nection")
conn.open strconn
strSQL = "Select Name, Number, Full_Number From AB_Dials;"
set RS = conn.execute(st rSQL)

end sub
%>
<%
sub connClose()
RS.close
set RS = nothing
conn.close
set conn = nothing
end sub
%>


Jul 19 '05 #3
CJM wrote:
By declaring the variables within a sub, you are limiting the scope
of the variables to within that sun only...

Right
Declare your subs in the main page, or if they are the same on every
page, put them in an external file and use #include.

That won't help with the "undefined variables" problem, unless you're
talking about creating an include page in which the global variables are
declared. Global variables must be declared outside of functions or subs.

However, I suggest minimizing the use of global variables. Global variables
can confuse things because their values can be changed anywhere in your
code, making debugging very difficult. Instead of global variables, use sub
and function arguments as much as possible to pass around your objects and
values.

OTOH, global constants can be a great thing. If you have a hard-coded
connection string, for instance, it would certainly be useful to encapsulate
that in a constant.
To be honest, your attempt to clean up your pages may well further
confuse the problem.

If you have segments of code that are re-used on every page, eg. a
header, footer ot menu, you can obvious place these in a separate
file and link them in... but using subs doesnt sound like a very good
solution...

Why not? I would say a combination of both techniques will certainly help
make things cleaner. Encapsulate the code in a function or sub which is
place in an include page. What is the downside of using functions or subs in
your view?

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #4
CJM

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

That won't help with the "undefined variables" problem, unless you're
talking about creating an include page in which the global variables are
declared. Global variables must be declared outside of functions or subs.

I *was* talking about global variables in an #include page... should have
made that clear, sorry.
However, I suggest minimizing the use of global variables. Global variables can confuse things because their values can be changed anywhere in your
code, making debugging very difficult. Instead of global variables, use sub and function arguments as much as possible to pass around your objects and
values.

OTOH, global constants can be a great thing. If you have a hard-coded
connection string, for instance, it would certainly be useful to encapsulate that in a constant.

Personally, I hold the connection string in an application variable...
useful for maintaining separate development/production versions of the same
system. All pages in my systems can be copied between servers with the
exception of Global.asa, which is uniqure for every installation.
Why not? I would say a combination of both techniques will certainly help
make things cleaner. Encapsulate the code in a function or sub which is
place in an include page. What is the downside of using functions or subs in your view?

Not necessarily a downside, but maybe lacking an upside.

Functions & Subs are very useful for re-using code withing a page. Also
useful for segregating a discrete & perhaps complex piece of code, for
example a complex algorithmn - or something that you want to take out of the
flow of the page/script.

I would only use them in these situations, though there is no reason why you
couldnt use them more - it's just that the benefits are questionable.

Also, you may find that if your code is sufficiently complex to merit plenty
of subs and functions (for the reasons outline above), that moving across to
a COM object might be an improvements.

I think you might be reading my response to the OP in a slightly
over-enthusiastic way! Until we can see what the OP was proposing, it's hard
to pass further comment.

Chris

Jul 19 '05 #5
On Fri, 2 Jul 2004 12:41:02 +0100, "CJM" <cj*******@news groups.nospam>
wrote:
By declaring the variables within a sub, you are limiting the scope of the
variables to within that sun only...

Declare your subs in the main page, or if they are the same on every page,
put them in an external file and use #include.
This can often be more confusing. Variables declared in a sub don't
get changed by other code inadvertantly. And you don't end up
redeclaring variables accidentally because they don't show in the page
you're coding.
To be honest, your attempt to clean up your pages may well further confuse
the problem.
Subs and functions have their place, and should be used. While the
object isn't to clean up code, including commonly used functions in
every page can simplify quite a bit of coding. One example posted
recently is a Print function. Replaces Response.Write statements and
adds a VbCrLf for readability of the source page, and is a nifty
little function. Including that in every page is a no-brainer, and
not having the function in the page code by using an include file
cleans the page up.
If you have segments of code that are re-used on every page, eg. a header,
footer ot menu, you can obvious place these in a separate file and link them
in... but using subs doesnt sound like a very good solution...
Includes will clean up pages for commonly used code, but functions and
subs clean up repetitive code in a single page. The best of both
worlds is an include of common functions.

Jeff

Chris

"Steven Scaife" <nospam> wrote in message
news:%2******* *********@TK2MS FTNGP09.phx.gbl ...
I have decided to re-write the intranet site i created over a year ago.

The
coding is pretty awful and hard to read cos I made the mistake of not
putting comments in or putting crappy comments in with the code. So I

have
decided to try and make things neater by grouping it into subs. So i have

a
sub to create the variables, a sub for the connection etc.

Only problem is when i call my subs, it says that the variable is

undefined.
If i scrap the subs and put everything into the order they would be the

page
works. I use the subs it doesn't.

Can anyone offer any insight or point me to a page that describes in

detail
the solution i am trying to achieve

thanks in advance

sample code below.

my page would look something like
<body bgcolor="#FFFFF F" text="#000000" link="#804040" vlink="#008080"
alink="#004080" >
<%
declareVar()
%>
<!--#include file="connectio n/connstring.inc"-->
<%
DBStrings()
%>

my subs are below as an example.
<%
sub declareVar()
'The declaration section
dim conn
dim strconn
dim physicaldbpath
dim strSQL
Dim RS
dim F
dim X

end sub
%>
<%
sub DBStrings()
set conn = server.createob ject("adodb.con nection")
conn.open strconn
strSQL = "Select Name, Number, Full_Number From AB_Dials;"
set RS = conn.execute(st rSQL)

end sub
%>
<%
sub connClose()
RS.close
set RS = nothing
conn.close
set conn = nothing
end sub
%>


Jul 19 '05 #6
Dan
I don't know how you code things but I like to put the *flow* code in a
separate ASP page (I'm not sure how common this is or whether it is
considered "desirable" ).

If you have a form on page that requires validation or depending on what his
entered redirects to another page, put the code that decides what to do next
on a seperate page.

For a simple example suppose you have a page called "contact.as p" which
contains a form allowing a user to submit their contact information. I
would have the form in "contact.as p" post to "post_contact.a sp". And in
"post_contact.a sp" I would put the validation code as well as the code that
determines where to go next (maybe..."thank _you.asp" or "error.asp" ).

Suppose you are creating a "wizardish" application, where the user has to go
through a series of steps and can jump back and forth between steps. IMHO
putting the logic to determine what to do next on the same page that
displays the form is messy and less readable.

I might be in the minority on this though.

Dan
"Steven Scaife" <nospam> wrote in message
news:u7******** ********@TK2MSF TNGP09.phx.gbl. ..
Ok thanks, any ideas of how i can organise my pages so they are structured
nice or should i just stick with the standard way of doing it and comment it properly. The intranet needs rewriting to use dsn less connections anyways cos its using a dsn and the code i wrote is pap.

"CJM" <cj*******@news groups.nospam> wrote in message
news:uz******** *****@TK2MSFTNG P10.phx.gbl...
By declaring the variables within a sub, you are limiting the scope of the variables to within that sun only...

Declare your subs in the main page, or if they are the same on every page, put them in an external file and use #include.

To be honest, your attempt to clean up your pages may well further confuse the problem.

If you have segments of code that are re-used on every page, eg. a header, footer ot menu, you can obvious place these in a separate file and link

them
in... but using subs doesnt sound like a very good solution...
Chris

"Steven Scaife" <nospam> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I have decided to re-write the intranet site i created over a year
ago. The
coding is pretty awful and hard to read cos I made the mistake of not
putting comments in or putting crappy comments in with the code. So I

have
decided to try and make things neater by grouping it into subs. So i have
a
sub to create the variables, a sub for the connection etc.

Only problem is when i call my subs, it says that the variable is

undefined.
If i scrap the subs and put everything into the order they would be

the page
works. I use the subs it doesn't.

Can anyone offer any insight or point me to a page that describes in

detail
the solution i am trying to achieve

thanks in advance

sample code below.

my page would look something like
<body bgcolor="#FFFFF F" text="#000000" link="#804040" vlink="#008080"
alink="#004080" >
<%
declareVar()
%>
<!--#include file="connectio n/connstring.inc"-->
<%
DBStrings()
%>

my subs are below as an example.
<%
sub declareVar()
'The declaration section
dim conn
dim strconn
dim physicaldbpath
dim strSQL
Dim RS
dim F
dim X

end sub
%>
<%
sub DBStrings()
set conn = server.createob ject("adodb.con nection")
conn.open strconn
strSQL = "Select Name, Number, Full_Number From AB_Dials;"
set RS = conn.execute(st rSQL)

end sub
%>
<%
sub connClose()
RS.close
set RS = nothing
conn.close
set conn = nothing
end sub
%>



Jul 19 '05 #7
dont meen to spam, but my last project (a blog) is a fairly good example of
subs and functions.

free;

http://www.pscode.com/vb/scripts/Sho...=8899&lngWId=4
"Jeff Cochran" <je*********@zi na.com> wrote in message
news:40******** ********@msnews .microsoft.com. ..
On Fri, 2 Jul 2004 12:41:02 +0100, "CJM" <cj*******@news groups.nospam>
wrote:
By declaring the variables within a sub, you are limiting the scope of thevariables to within that sun only...

Declare your subs in the main page, or if they are the same on every page,put them in an external file and use #include.


This can often be more confusing. Variables declared in a sub don't
get changed by other code inadvertantly. And you don't end up
redeclaring variables accidentally because they don't show in the page
you're coding.
To be honest, your attempt to clean up your pages may well further confusethe problem.


Subs and functions have their place, and should be used. While the
object isn't to clean up code, including commonly used functions in
every page can simplify quite a bit of coding. One example posted
recently is a Print function. Replaces Response.Write statements and
adds a VbCrLf for readability of the source page, and is a nifty
little function. Including that in every page is a no-brainer, and
not having the function in the page code by using an include file
cleans the page up.
If you have segments of code that are re-used on every page, eg. a header,footer ot menu, you can obvious place these in a separate file and link themin... but using subs doesnt sound like a very good solution...


Includes will clean up pages for commonly used code, but functions and
subs clean up repetitive code in a single page. The best of both
worlds is an include of common functions.

Jeff

Chris

"Steven Scaife" <nospam> wrote in message
news:%2******* *********@TK2MS FTNGP09.phx.gbl ...
I have decided to re-write the intranet site i created over a year ago.

The
coding is pretty awful and hard to read cos I made the mistake of not
putting comments in or putting crappy comments in with the code. So I

have
decided to try and make things neater by grouping it into subs. So i
havea
sub to create the variables, a sub for the connection etc.

Only problem is when i call my subs, it says that the variable is

undefined.
If i scrap the subs and put everything into the order they would be the

page
works. I use the subs it doesn't.

Can anyone offer any insight or point me to a page that describes in

detail
the solution i am trying to achieve

thanks in advance

sample code below.

my page would look something like
<body bgcolor="#FFFFF F" text="#000000" link="#804040" vlink="#008080"
alink="#004080" >
<%
declareVar()
%>
<!--#include file="connectio n/connstring.inc"-->
<%
DBStrings()
%>

my subs are below as an example.
<%
sub declareVar()
'The declaration section
dim conn
dim strconn
dim physicaldbpath
dim strSQL
Dim RS
dim F
dim X

end sub
%>
<%
sub DBStrings()
set conn = server.createob ject("adodb.con nection")
conn.open strconn
strSQL = "Select Name, Number, Full_Number From AB_Dials;"
set RS = conn.execute(st rSQL)

end sub
%>
<%
sub connClose()
RS.close
set RS = nothing
conn.close
set conn = nothing
end sub
%>

Jul 19 '05 #8
<<
Ok thanks, any ideas of how i can organise my pages so they are
structured nice or should i just stick with the standard way of doing it
and comment it properly.


Here's an example of something that may give you some ideas for
structure.

' See what btn used, where opened from, or where referred from.
If Request.Form("b tnClose") <> "" Then ' Close btn.
' Close.
Call ClosePg()
Elseif Request.Form("b tnSave") <> "" Then ' Save btn.
' Set var.
Call SetVar("frompos t")

' Save rec.
Call SaveRec()

' Show pg.
Call ShowPg()
Elseif Request.Form("b tnNew") <> "" Then ' New btn from this pg.
' Set var.
Call SetVar("new")

' Show pg.
Call ShowPg()
Elseif Request.Form("b tnDel") <> "" Then ' Del btn.
' Set var.
Call SetVar("frompos t")

' Del rec.
Call DelRec()

' Set var.
Call SetVar("new")

' Show pg.
Call ShowPg()
Elseif Request.Form("b tnShowList") <> "" Then ' ShowList btn.
' Set var.
Call SetVar("frompos t")

' Show pg.
Call ShowPg()
Elseif Request.QuerySt ring("CustID") <> "" Then ' CustID from Many pg.
Session(mstrSes sionPrefix & "Cust-FromPg") = "custmany.a sp"

' Set var.
Call SetVar("fromdb" )

' Show pg.
Call ShowPg()
Elseif Request.QuerySt ring("CustID") = "" Then ' Add btn from MainMenu
pg.
Session(mstrSes sionPrefix & "Cust-FromPg") = "mainmenu.a sp"

' Set var.
Call SetVar("new")

' Show pg.
Call ShowPg()
Else ' Nothing.
' This should never be the case.
End If

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #9
Basically I just wanted to clean everything up. I wrote the site over two
years ago when I first learnt ASP, my second ASP site was a lot better, it
used disconnected recordsets and had comments and read better.

I used a combination of handwritten code and dreamweaver ultradev when i
became lazy, which was a big mistake cos its horrible and luckily so far on
my rewrite I haven't reached the pages with loads of code, some have like
500+ lines of code.

I originally used the request object but never specified what i was using so
just used request("textbo x")
rather than request.form("t extbox"). I'm probably leaving this org soon now
that I have graduated and hope to move into a web programmer position, so
this is for both the org and my benefit. i.e. I get back up to speed on ASP
they have a better functioning intranet that is easier to update.

I noticed an article on webmonkey that used classes but i haven't any
experience of these, this probably would have been a nice way of
encapsulating everything and using a sort of OO approach, but my degree
never taught object orientation so i didn't bother.

Basically, I wanted something that read nice, i have placed my commonly used
variables into a include file so now i have connect.inc and close.inc.
These open and close my database connections and dim the RS and strSQL
variables.

I have also tried to keep the ASP code seperate from the HTML as this makes
it easier to understand, i was wondering if it was better to use a sub that
looped through the recordset and wrote the contents into a list box etc. so
all i did within the select tags was this
<select "name>
loopintooption( )
</select>

basically just things like that

Does this give a better understanding of what i originally asked.

ps. I like how I have started a debate on how people go about programming
there sites i feel important now, lol, hopefully more people will notice
this thread and get some tips from the pros.

thanks for everyones time
Jul 19 '05 #10

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

Similar topics

8
2295
by: | last post by:
In global.asa I have some code outside all the Subs. I have some confirmation that it is being executed OnStart. Yet I can's see if it is executed OnEnd. The literature I have says that OnEnd the Sub Application_OnEnd is executed, but is does not say that anything else is executed Actually I even can't understand if global.asa is permited to have any code outside the Subs
20
7358
by: Al Moritz | last post by:
Hi all, I was always told that the conversion of Word files to HTML as done by Word itself sucks - you get a lot of unnecessary code that can influence the design on web browsers other than Internet Explorer. Our computer expert in my company had told me already a while ago that I should learn HTML and encode myself. I was never inclined to do so (I am no computer expert), and when upon his suggestion I looked how my pages (converted to...
2
1500
by: nakhi | last post by:
Hi, I declared a dataset outside any subs, then I fill the dataset with a tables in a Private Sub1, then I want to take the data out from the dataset in Sub2. like . sub2() datagrid.datasource=ds.tables("t").defautview datagrid.databind() end sub
2
2916
by: collie | last post by:
Hi, I have 2 listboxes. The first gets populated from the db as soon as the page loads. The second listbox get populated based on the user's selection from the first listbox. However, currently the code is such that with each selection there is a postback. We want to avoid it using filter and javascript. I am not using ADO.NET but adodbc and no datagrids or datasets (please don't tell me that i should as my boss clearly doesn't want...
7
1873
by: djc | last post by:
I have several subroutines (all inline code) that wind up using the same database connection object variable. I have been declaring a new variable in every sub. I just now came to a point where I want to call one sub that will utilize a database connection from within another sub that is already utilizing a database connection. 1) Can I just declare this database connection once outside of all subroutines to make it global (the way I...
21
2149
by: Sandy | last post by:
Hello - I am using Visual Studio .Net. I need an example of how to construct a class that can be used throughout a project where I can include its subs and functions in various pages in the project. I googled this and either I didn't use the correct words, or there doesn't seem to be much on it. Any help will be appreciated!
14
3076
by: antonyliu2002 | last post by:
I am new to .NET framework. A bunch of web pages of mine need the same function. Right now, I put the Subs in each individual page. I think there must be a way to save my Subs in a separate file and then have each web page link to it. Could you guys please let me know how to do this? Thanks a lot!
11
1887
by: Nicky Smith | last post by:
Hello, I'm studying a book on VB.net Win apps, and I'm reading a section on events and delegates and raising events. Is it just me, or is this not just subs dressed up as something else? I mean, for one, delegates point to subs, so when you call a delegate, why not just call the sub dierectly and not bother adding the extra code involved adding the delegate?
5
3153
by: Brett | last post by:
In a class, I have several Private subs. I declare an instance of the class such as: Dim MySelf as new Class1 within a private sub. The motive is to provide access to other subs within the same class. Is this correct? It would be nice to declare the MySelf instance in the Class public space (just under Private Class Class1). That will give this error: Cannot refer to an instance member of a class from within a shared
0
10320
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10073
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9134
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7609
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6846
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5513
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5645
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3806
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2981
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.