473,699 Members | 2,570 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stop a query

I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address. The
same query is used as the RecordSource of lots of similar reports, but all
with different sized Address text boxes. For the function to work, the
report need to be open in design view, so that the Text Box Width can be
"measured". The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either no
Reports are open, or a Report is open, but the particular Text Box is not on
the report (i.e. the wrong Report is open)

TIA

Phil
Aug 10 '07 #1
6 6860
Try this...Starting with the report Closed, From your Procedure, Call
ControlFound ("YourReportNam e", "YourControlNam e")
the Function will find the report, open it in design mode, check for the
control and if the control is found, returns ControlFound = True
Then you can act on the information, Don't forget to Close the Report and
move on to the next report.

Good luck
Len Robichaud

------------------------------------------------------------
Option Compare Database
Option Explicit

'Returns True if the specified report is open in Design View and The Control
is found.
'Any Error returns a False

Function ControlFound(By Val strReportName As String, ByVal strControlName As
String) As Boolean
On Error GoTo ControlFound_Er ror

Const conObjStateClos ed = 0
Dim strControl As Variant
ControlFound = False

'If the Report Exists and it is currently closed, Open it in Design mode
If SysCmd(acSysCmd GetObjectState, acReport, strReportName) =
conObjStateClos ed Then
DoCmd.OpenRepor t strReportName, acViewDesign
'Now check to see if the control exists on the report
strControl = Reports(strRepo rtName).Control s(strControlNam e).Name
If Len(strControl) 0 Then ControlFound = True
End If

ControlFound_Ex it:
Exit Function

ControlFound_Er ror:
ControlFound = False
Resume ControlFound_Ex it

End Function
---------------------------------------------------------------

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
>I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address.
The same query is used as the RecordSource of lots of similar reports, but
all with different sized Address text boxes. For the function to work, the
report need to be open in design view, so that the Text Box Width can be
"measured". The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either no
Reports are open, or a Report is open, but the particular Text Box is not
on the report (i.e. the wrong Report is open)

TIA

Phil

Aug 10 '07 #2
Thanks for that, Len. That works fine, but how do I terminate the query from
continuing to run. It is the running of the query that initiates checking
the report is open and that the control exists. If the ControlFound is
False, I want to abort running the query that called it

Thanks

Phil
"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************** @news.corp.more usenet.net...
Try this...Starting with the report Closed, From your Procedure, Call
ControlFound ("YourReportNam e", "YourControlNam e")
the Function will find the report, open it in design mode, check for the
control and if the control is found, returns ControlFound = True
Then you can act on the information, Don't forget to Close the Report and
move on to the next report.

Good luck
Len Robichaud

------------------------------------------------------------
Option Compare Database
Option Explicit

'Returns True if the specified report is open in Design View and The
Control is found.
'Any Error returns a False

Function ControlFound(By Val strReportName As String, ByVal strControlName
As String) As Boolean
On Error GoTo ControlFound_Er ror

Const conObjStateClos ed = 0
Dim strControl As Variant
ControlFound = False

'If the Report Exists and it is currently closed, Open it in Design mode
If SysCmd(acSysCmd GetObjectState, acReport, strReportName) =
conObjStateClos ed Then
DoCmd.OpenRepor t strReportName, acViewDesign
'Now check to see if the control exists on the report
strControl = Reports(strRepo rtName).Control s(strControlNam e).Name
If Len(strControl) 0 Then ControlFound = True
End If

ControlFound_Ex it:
Exit Function

ControlFound_Er ror:
ControlFound = False
Resume ControlFound_Ex it

End Function
---------------------------------------------------------------

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
>>I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address.
The same query is used as the RecordSource of lots of similar reports, but
all with different sized Address text boxes. For the function to work, the
report need to be open in design view, so that the Text Box Width can be
"measured". The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either no
Reports are open, or a Report is open, but the particular Text Box is not
on the report (i.e. the wrong Report is open)

TIA

Phil


Aug 12 '07 #3
Explain in more detail what you are trying to accomplish and the steps in
your process. You may need to incorporate another procedure. Talk me
through your process.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
Thanks for that, Len. That works fine, but how do I terminate the query from
continuing to run. It is the running of the query that initiates checking
the report is open and that the control exists. If the ControlFound is
False, I want to abort running the query that called it

Thanks

Phil
"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************** @news.corp.more usenet.net...
Try this...Starting with the report Closed, From your Procedure, Call
ControlFound ("YourReportNam e", "YourControlNam e")
the Function will find the report, open it in design mode, check for the
control and if the control is found, returns ControlFound = True
Then you can act on the information, Don't forget to Close the Report and
move on to the next report.

Good luck
Len Robichaud

------------------------------------------------------------
Option Compare Database
Option Explicit

'Returns True if the specified report is open in Design View and The
Control is found.
'Any Error returns a False

Function ControlFound(By Val strReportName As String, ByVal strControlName
As String) As Boolean
On Error GoTo ControlFound_Er ror

Const conObjStateClos ed = 0
Dim strControl As Variant
ControlFound = False

'If the Report Exists and it is currently closed, Open it in Design mode
If SysCmd(acSysCmd GetObjectState, acReport, strReportName) =
conObjStateClos ed Then
DoCmd.OpenRepor t strReportName, acViewDesign
'Now check to see if the control exists on the report
strControl = Reports(strRepo rtName).Control s(strControlNam e).Name
If Len(strControl) 0 Then ControlFound = True
End If

ControlFound_Ex it:
Exit Function

ControlFound_Er ror:
ControlFound = False
Resume ControlFound_Ex it

End Function
---------------------------------------------------------------

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
>>I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address.
The same query is used as the RecordSource of lots of similar reports, but
all with different sized Address text boxes. For the function to work, the
report need to be open in design view, so that the Text Box Width can be
"measured". The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either no
Reports are open, or a Report is open, but the particular Text Box is not
on the report (i.e. the wrong Report is open)

TIA

Phil



Aug 12 '07 #4
Thanks for coming back to me, Len

I am trying to create a number of similar Club directories - Names,
addresses, phone, email etc. I use the same front end DB for all the clubs
and a different BE for each club. Each Club wants their directory in a
different format so for example, one Club wants their directory in a 1/2 A5
booklet form. One Club in particular wants the Surname and address on 1 line
and First name, mobile and emails of each of the family members on
subsequent lines indented in from the Surname.To make the booklet neat, for
example if the address is longer than it's text box, I want to ensure that
the second line starts at a space, and doesn't split a word. With the names
I want to line up all the first names and phone numbers, so have to work out
the length of the Surname so that all the First names are suitably indented
and then work out the length of the longest first name so that the phone
numbers all line up.
I Am using Stephen Lebans modTextHeightWi dth to calculate spaces required
and using all sorts of manipulations to combine say 5 address fields into 1
concatenated address.

The query that is the record source for each of these Club Directory reports
calls a number of functions to combine the information in different ways
depending on parameters it gets passed from a hidden form. It also needs the
information from the intended report to get the field.Lengths so that the
correct formatting can be applied. What I am trying to do is stop the query
running if it can't find the necessary information from the report as it
process the first record. Otherwise I get the error message repeated 1000
times for each record. Gets rather boring

Probably a much simpler way of doing it, with 1 query per report - but
messy. 6 Clubs, 2 or 3 similar reports each could be 18 queries and 18
reports. There must be a more elegant way.

Thanks

Phil

"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************@n ews.corp.moreus enet.net...
Explain in more detail what you are trying to accomplish and the steps in
your process. You may need to incorporate another procedure. Talk me
through your process.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
Thanks for that, Len. That works fine, but how do I terminate the query
from
continuing to run. It is the running of the query that initiates checking
the report is open and that the control exists. If the ControlFound is
False, I want to abort running the query that called it

Thanks

Phil
"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************** @news.corp.more usenet.net...
>Try this...Starting with the report Closed, From your Procedure, Call
ControlFound ("YourReportNam e", "YourControlNam e")
the Function will find the report, open it in design mode, check for the
control and if the control is found, returns ControlFound = True
Then you can act on the information, Don't forget to Close the Report and
move on to the next report.

Good luck
Len Robichaud

------------------------------------------------------------
Option Compare Database
Option Explicit

'Returns True if the specified report is open in Design View and The
Control is found.
'Any Error returns a False

Function ControlFound(By Val strReportName As String, ByVal strControlName
As String) As Boolean
On Error GoTo ControlFound_Er ror

Const conObjStateClos ed = 0
Dim strControl As Variant
ControlFound = False

'If the Report Exists and it is currently closed, Open it in Design mode
If SysCmd(acSysCmd GetObjectState, acReport, strReportName) =
conObjStateClo sed Then
DoCmd.OpenRepor t strReportName, acViewDesign
'Now check to see if the control exists on the report
strControl = Reports(strRepo rtName).Control s(strControlNam e).Name
If Len(strControl) 0 Then ControlFound = True
End If

ControlFound_E xit:
Exit Function

ControlFound_E rror:
ControlFound = False
Resume ControlFound_Ex it

End Function
---------------------------------------------------------------

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******* ******@corp.sup ernews.com...
>>>I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address.
The same query is used as the RecordSource of lots of similar reports,
but
all with different sized Address text boxes. For the function to work,
the
report need to be open in design view, so that the Text Box Width can be
"measured" . The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either no
Reports are open, or a Report is open, but the particular Text Box is not
on the report (i.e. the wrong Report is open)

TIA

Phil




Aug 13 '07 #5
Here is my suggestion.
In the Backend database create a new table of report parameters
Let that table have one record with as many fields as is necessary to store
all of the data parameters that your report queries need.
Link that to the front end and use DLookup(s) to retrieve the data for your
queries instead of opening the reports.
"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
Thanks for coming back to me, Len

I am trying to create a number of similar Club directories - Names,
addresses, phone, email etc. I use the same front end DB for all the clubs
and a different BE for each club. Each Club wants their directory in a
different format so for example, one Club wants their directory in a 1/2 A5
booklet form. One Club in particular wants the Surname and address on 1 line
and First name, mobile and emails of each of the family members on
subsequent lines indented in from the Surname.To make the booklet neat, for
example if the address is longer than it's text box, I want to ensure that
the second line starts at a space, and doesn't split a word. With the names
I want to line up all the first names and phone numbers, so have to work out
the length of the Surname so that all the First names are suitably indented
and then work out the length of the longest first name so that the phone
numbers all line up.
I Am using Stephen Lebans modTextHeightWi dth to calculate spaces required
and using all sorts of manipulations to combine say 5 address fields into 1
concatenated address.

The query that is the record source for each of these Club Directory reports
calls a number of functions to combine the information in different ways
depending on parameters it gets passed from a hidden form. It also needs the
information from the intended report to get the field.Lengths so that the
correct formatting can be applied. What I am trying to do is stop the query
running if it can't find the necessary information from the report as it
process the first record. Otherwise I get the error message repeated 1000
times for each record. Gets rather boring

Probably a much simpler way of doing it, with 1 query per report - but
messy. 6 Clubs, 2 or 3 similar reports each could be 18 queries and 18
reports. There must be a more elegant way.

Thanks

Phil

"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************@n ews.corp.moreus enet.net...
Explain in more detail what you are trying to accomplish and the steps in
your process. You may need to incorporate another procedure. Talk me
through your process.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
Thanks for that, Len. That works fine, but how do I terminate the query
from
continuing to run. It is the running of the query that initiates checking
the report is open and that the control exists. If the ControlFound is
False, I want to abort running the query that called it

Thanks

Phil
"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************** @news.corp.more usenet.net...
>Try this...Starting with the report Closed, From your Procedure, Call
ControlFound ("YourReportNam e", "YourControlNam e")
the Function will find the report, open it in design mode, check for the
control and if the control is found, returns ControlFound = True
Then you can act on the information, Don't forget to Close the Report and
move on to the next report.

Good luck
Len Robichaud

------------------------------------------------------------
Option Compare Database
Option Explicit

'Returns True if the specified report is open in Design View and The
Control is found.
'Any Error returns a False

Function ControlFound(By Val strReportName As String, ByVal strControlName
As String) As Boolean
On Error GoTo ControlFound_Er ror

Const conObjStateClos ed = 0
Dim strControl As Variant
ControlFound = False

'If the Report Exists and it is currently closed, Open it in Design mode
If SysCmd(acSysCmd GetObjectState, acReport, strReportName) =
conObjStateClo sed Then
DoCmd.OpenRepor t strReportName, acViewDesign
'Now check to see if the control exists on the report
strControl = Reports(strRepo rtName).Control s(strControlNam e).Name
If Len(strControl) 0 Then ControlFound = True
End If

ControlFound_E xit:
Exit Function

ControlFound_E rror:
ControlFound = False
Resume ControlFound_Ex it

End Function
---------------------------------------------------------------

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******* ******@corp.sup ernews.com...
>>>I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address.
The same query is used as the RecordSource of lots of similar reports,
but
all with different sized Address text boxes. For the function to work,
the
report need to be open in design view, so that the Text Box Width can be
"measured" . The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either no
Reports are open, or a Report is open, but the particular Text Box is not
on the report (i.e. the wrong Report is open)

TIA

Phil





Aug 13 '07 #6
Ok, Len I'll give it a try

Thanks

Phil

"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************** @news.corp.more usenet.net...
Here is my suggestion.
In the Backend database create a new table of report parameters
Let that table have one record with as many fields as is necessary to
store
all of the data parameters that your report queries need.
Link that to the front end and use DLookup(s) to retrieve the data for
your
queries instead of opening the reports.
"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...
Thanks for coming back to me, Len

I am trying to create a number of similar Club directories - Names,
addresses, phone, email etc. I use the same front end DB for all the clubs
and a different BE for each club. Each Club wants their directory in a
different format so for example, one Club wants their directory in a 1/2
A5
booklet form. One Club in particular wants the Surname and address on 1
line
and First name, mobile and emails of each of the family members on
subsequent lines indented in from the Surname.To make the booklet neat,
for
example if the address is longer than it's text box, I want to ensure
that
the second line starts at a space, and doesn't split a word. With the
names
I want to line up all the first names and phone numbers, so have to work
out
the length of the Surname so that all the First names are suitably
indented
and then work out the length of the longest first name so that the phone
numbers all line up.
I Am using Stephen Lebans modTextHeightWi dth to calculate spaces required
and using all sorts of manipulations to combine say 5 address fields into
1
concatenated address.

The query that is the record source for each of these Club Directory
reports
calls a number of functions to combine the information in different ways
depending on parameters it gets passed from a hidden form. It also needs
the
information from the intended report to get the field.Lengths so that the
correct formatting can be applied. What I am trying to do is stop the
query
running if it can't find the necessary information from the report as it
process the first record. Otherwise I get the error message repeated 1000
times for each record. Gets rather boring

Probably a much simpler way of doing it, with 1 query per report - but
messy. 6 Clubs, 2 or 3 similar reports each could be 18 queries and 18
reports. There must be a more elegant way.

Thanks

Phil

"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******** *************@n ews.corp.moreus enet.net...
>Explain in more detail what you are trying to accomplish and the steps in
your process. You may need to incorporate another procedure. Talk me
through your process.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******* ******@corp.sup ernews.com...
Thanks for that, Len. That works fine, but how do I terminate the query
from
continuing to run. It is the running of the query that initiates checking
the report is open and that the control exists. If the ControlFound is
False, I want to abort running the query that called it

Thanks

Phil
"Len Robichaud" <le***********@ rqwproserv.comw rote in message
news:46******* *************** *@news.corp.mor eusenet.net...
>>Try this...Starting with the report Closed, From your Procedure, Call
ControlFoun d ("YourReportNam e", "YourControlNam e")
the Function will find the report, open it in design mode, check for the
control and if the control is found, returns ControlFound = True
Then you can act on the information, Don't forget to Close the Report
and
move on to the next report.

Good luck
Len Robichaud

------------------------------------------------------------
Option Compare Database
Option Explicit

'Returns True if the specified report is open in Design View and The
Control is found.
'Any Error returns a False

Function ControlFound(By Val strReportName As String, ByVal
strControlNam e
As String) As Boolean
On Error GoTo ControlFound_Er ror

Const conObjStateClos ed = 0
Dim strControl As Variant
ControlFoun d = False

'If the Report Exists and it is currently closed, Open it in Design mode
If SysCmd(acSysCmd GetObjectState, acReport, strReportName) =
conObjStateCl osed Then
DoCmd.OpenRepor t strReportName, acViewDesign
'Now check to see if the control exists on the report
strControl = Reports(strRepo rtName).Control s(strControlNam e).Name
If Len(strControl) 0 Then ControlFound = True
End If

ControlFound_ Exit:
Exit Function

ControlFound_ Error:
ControlFound = False
Resume ControlFound_Ex it

End Function
---------------------------------------------------------------

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13****** *******@corp.su pernews.com...
I am running a query that calls a function used to format addresses
depending on the width of a control on a report that shows that address.
The same query is used as the RecordSource of lots of similar reports,
but
all with different sized Address text boxes. For the function to work,
the
report need to be open in design view, so that the Text Box Width can be
"measured ". The function is obviously called for each line of the query
(about 1000 times). How can I neatly abort running the query if either
no
Reports are open, or a Report is open, but the particular Text Box is
not
on the report (i.e. the wrong Report is open)

TIA

Phil





Aug 13 '07 #7

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

Similar topics

1
1972
by: Suzi Carr | last post by:
Hello, We create querydefs in VB programs (i.e. CreateQueryDef). But as illustrated below, Access regenerates the SQL code we specify -- particularly the WHERE clause. While the new code is logically equivalent, it often results in MUCH slower query performance and this has become a big problem in some applications. If we go to query design mode, we can see that our code was replaced. When we manually change it back, the query runs much...
0
1286
by: strangedub | last post by:
I am working on a C# Windows program that needs to kill a known process. I have written code that works in development mode but hits an "Access Denied" exception when running the compiled program: Here's my original code: // Now stop the server process Process myProcesses; myProcesses = Process.GetProcessesByName("MyServer"); foreach(Process myProcess in myProcesses) {
3
2469
by: prakashsha | last post by:
HI, I've an asp.net page which has a button. On click of the button the program queries the database and gets the result and displays the same.Now assume that my program takes 2 minutes to get the results.In the mean time if the user press Esc button to stop the process. The page will stop processing but my database connection will be trying to retrieve the records. How to solve this ??? Thanks in Adavance.
4
14888
by: James Radke | last post by:
Hello, I am attempting to use the proper Try/Catch technique when accessing my Microsoft SQL server database and have a question... If I use something similar to the following: Try set up SQL connection open the SQL connection
1
9770
by: kevcar40 | last post by:
hi is it possible to stop a form opening if the result of the query is null? eg select a company name from a combobox if the name is not in the table (ie the query returns null) can i stop the form opening thanks
3
2340
by: diego | last post by:
Greetings everyone! Is there a way to stop query analyzer from processing remaining query statements? Let's say i have the following query in query analyzer: query statements if condition begin query statements stop the query
1
2287
by: bharadwaj | last post by:
Hi All, I am executing one query in sql analyzer. It was taking too much of time.I am not able to stop the query using stop button,it was not responding. Many users are working with that database at the same time,not possible to stop services(agent or server) also. Any help from you. Regards Bharat
4
8974
kcdoell
by: kcdoell | last post by:
Hello: What is the best way to stop a report from running if the query is empty? Currently, I have a form that has a command button on it. The user has to make selections from 3 combo boxes on the form and then via the cmdbutton the report opens in preview mode. I want to stop it from executing if the query is empty. I thought I could do this by checking the record count by the following code but I error out with the following message: ...
5
2857
by: Guillermo Antonio Amaral Bastidas | last post by:
Hi everybody, I have a quick and probably dumb question, keep in mind I just dumped my old love FastCGI + Perl for it's younger hotter friend PHP5. If the user calls a time consuming script and then stops or refreshes the browser before the script had time to finish will Apache kill the script mid execution or will it let it finish ? I ask this stupid question because this seems to be happening in one
0
9178
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9035
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...
1
8916
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8885
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
7752
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
6534
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
4376
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...
1
3058
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2348
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.