473,503 Members | 1,712 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Custom error message for Runtime error 3022

I am trying trap Runtime error 3022 (duplicates) in the click event of
a command button that closes the form. I have code in the Form_Error
event that does a good job of providing a more meaningful error message
than the default. It works in every situation except when the user
clicks the close button. I am using Me.Dirty=False to force a save but
if there are duplicates I just get the standard Runtime 3022 error
message. I am wondering why the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub above
to produce a custom error message, but the standard error message was
being produced as soon as the Me.Dirty=False statement was reached. and
the On Error Go To ErrorHandler was ignored. I obvously don't
understand the sequence of events enough. Can anyone Help me out? By
the way, The Form allows entry of Volunteer Hours worked at a seniors
home by various church groups.

Nov 11 '06 #1
8 13077
Why not use the BeforeUpdate event of the form and/or the entry field for
the primary key? This would alert users to a duplicate before they continue
to enter all the other info, rather than after the fact. BTW, you can set
the form's properties to remove the Close box.
-Ed

"g_man" <ga*******@gmail.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
>I am trying trap Runtime error 3022 (duplicates) in the click event of
a command button that closes the form. I have code in the Form_Error
event that does a good job of providing a more meaningful error message
than the default. It works in every situation except when the user
clicks the close button. I am using Me.Dirty=False to force a save but
if there are duplicates I just get the standard Runtime 3022 error
message. I am wondering why the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub above
to produce a custom error message, but the standard error message was
being produced as soon as the Me.Dirty=False statement was reached. and
the On Error Go To ErrorHandler was ignored. I obvously don't
understand the sequence of events enough. Can anyone Help me out? By
the way, The Form allows entry of Volunteer Hours worked at a seniors
home by various church groups.

Nov 12 '06 #2
"g_man" <ga*******@gmail.comwrote in message
<11**********************@f16g2000cwb.googlegroups .com>:
I am trying trap Runtime error 3022 (duplicates) in the click event
of a command button that closes the form. I have code in the
Form_Error event that does a good job of providing a more meaningful
error message than the default. It works in every situation except
when the user clicks the close button. I am using Me.Dirty=False to
force a save but if there are duplicates I just get the standard
Runtime 3022 error message. I am wondering why the Form_Error event
is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub
above to produce a custom error message, but the standard error
message was being produced as soon as the Me.Dirty=False statement
was reached. and the On Error Go To ErrorHandler was ignored. I
obvously don't understand the sequence of events enough. Can anyone
Help me out? By the way, The Form allows entry of Volunteer Hours
worked at a seniors home by various church groups.
Try trapping it within your close button code - use resume next
for the part that might trigger an error, and check.

Private Sub cmdClose_Click()

If Me.Dirty Then
On Error Resume Next
Me.Dirty = False
If (Err.Number = 3022) Then
Err.Clear
Me.Undo
End If
On Error Goto 0 ' or use your error handler
End If
DoCmd.Close acForm, Me.Name, acSaveYes

End Sub

I don't think the Form Error triggers by runtime errors, which is
what you'll get when firing off the save through code.

--
Roy-Vidar
Nov 12 '06 #3
Roy, thanks for your reply, I tried your code, with a watch on
Err.Number. The standard error message was triggered as soon as the
Me.Dirty=False statement was executed. Err.Number's value still had not
changed to 3022. Shouldn't execution skip to the next statement after
the line that triggers the error in other words to the
If(Err.Number....) statement?

RoyVidar wrote:
"g_man" <ga*******@gmail.comwrote in message
<11**********************@f16g2000cwb.googlegroups .com>:
I am trying trap Runtime error 3022 (duplicates) in the click event
of a command button that closes the form. I have code in the
Form_Error event that does a good job of providing a more meaningful
error message than the default. It works in every situation except
when the user clicks the close button. I am using Me.Dirty=False to
force a save but if there are duplicates I just get the standard
Runtime 3022 error message. I am wondering why the Form_Error event
is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub
above to produce a custom error message, but the standard error
message was being produced as soon as the Me.Dirty=False statement
was reached. and the On Error Go To ErrorHandler was ignored. I
obvously don't understand the sequence of events enough. Can anyone
Help me out? By the way, The Form allows entry of Volunteer Hours
worked at a seniors home by various church groups.

Try trapping it within your close button code - use resume next
for the part that might trigger an error, and check.

Private Sub cmdClose_Click()

If Me.Dirty Then
On Error Resume Next
Me.Dirty = False
If (Err.Number = 3022) Then
Err.Clear
Me.Undo
End If
On Error Goto 0 ' or use your error handler
End If
DoCmd.Close acForm, Me.Name, acSaveYes

End Sub

I don't think the Form Error triggers by runtime errors, which is
what you'll get when firing off the save through code.

--
Roy-Vidar
Nov 13 '06 #4
Ed, thanks for your reply. Strangely enough, using the close box on the
form with duplicate records does trigger my custom error message. The
problem I found was when the last record added is a duplicate. After
the combobox (cboGroupID) value is changed this changes the GroupID
field in the underlying table which is part of a multiple primary key
along with fields for the month and year. The Change event for this
combobox sets the focus in a text box to add the number of hours. If
the user enters hours in this box and then hits my close button and
hours have already been entered for this group in a previous record
then the standard Runtime error 3022 message is produced not my custom
message. If the user makes the duplicate entry and then tries to start
a new record, my message is displayed. It is only if it is the last
record before they hit my close button that the stock message gets
displayed. I have tried putting code into the before update event of
the form the combobox and numerous other events. Any ideas?

Ed Robichaud wrote:
Why not use the BeforeUpdate event of the form and/or the entry field for
the primary key? This would alert users to a duplicate before they continue
to enter all the other info, rather than after the fact. BTW, you can set
the form's properties to remove the Close box.
-Ed

"g_man" <ga*******@gmail.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
I am trying trap Runtime error 3022 (duplicates) in the click event of
a command button that closes the form. I have code in the Form_Error
event that does a good job of providing a more meaningful error message
than the default. It works in every situation except when the user
clicks the close button. I am using Me.Dirty=False to force a save but
if there are duplicates I just get the standard Runtime 3022 error
message. I am wondering why the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub above
to produce a custom error message, but the standard error message was
being produced as soon as the Me.Dirty=False statement was reached. and
the On Error Go To ErrorHandler was ignored. I obvously don't
understand the sequence of events enough. Can anyone Help me out? By
the way, The Form allows entry of Volunteer Hours worked at a seniors
home by various church groups.
Nov 13 '06 #5
One common technique is to use the BeforeUpdate of the combobox to run a
DLookup of the underlying table and check for any matching records, then
either add it, or pop-up a msgbox and clear it.
-Ed

"g_man" <ga*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Ed, thanks for your reply. Strangely enough, using the close box on the
form with duplicate records does trigger my custom error message. The
problem I found was when the last record added is a duplicate. After
the combobox (cboGroupID) value is changed this changes the GroupID
field in the underlying table which is part of a multiple primary key
along with fields for the month and year. The Change event for this
combobox sets the focus in a text box to add the number of hours. If
the user enters hours in this box and then hits my close button and
hours have already been entered for this group in a previous record
then the standard Runtime error 3022 message is produced not my custom
message. If the user makes the duplicate entry and then tries to start
a new record, my message is displayed. It is only if it is the last
record before they hit my close button that the stock message gets
displayed. I have tried putting code into the before update event of
the form the combobox and numerous other events. Any ideas?

Ed Robichaud wrote:
>Why not use the BeforeUpdate event of the form and/or the entry field for
the primary key? This would alert users to a duplicate before they
continue
to enter all the other info, rather than after the fact. BTW, you can
set
the form's properties to remove the Close box.
-Ed

"g_man" <ga*******@gmail.comwrote in message
news:11**********************@f16g2000cwb.googleg roups.com...
>I am trying trap Runtime error 3022 (duplicates) in the click event of
a command button that closes the form. I have code in the Form_Error
event that does a good job of providing a more meaningful error message
than the default. It works in every situation except when the user
clicks the close button. I am using Me.Dirty=False to force a save but
if there are duplicates I just get the standard Runtime 3022 error
message. I am wondering why the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub above
to produce a custom error message, but the standard error message was
being produced as soon as the Me.Dirty=False statement was reached. and
the On Error Go To ErrorHandler was ignored. I obvously don't
understand the sequence of events enough. Can anyone Help me out? By
the way, The Form allows entry of Volunteer Hours worked at a seniors
home by various church groups.

Nov 13 '06 #6
"g_man" <ga*******@gmail.comwrote in message
<11**********************@i42g2000cwa.googlegroups .com>:
Roy, thanks for your reply, I tried your code, with a watch on
Err.Number. The standard error message was triggered as soon as the
Me.Dirty=False statement was executed. Err.Number's value still had
not changed to 3022. Shouldn't execution skip to the next statement
after the line that triggers the error in other words to the
If(Err.Number....) statement?

RoyVidar wrote:
>"g_man" <ga*******@gmail.comwrote in message
<11**********************@f16g2000cwb.googlegroup s.com>:
>>I am trying trap Runtime error 3022 (duplicates) in the click event
of a command button that closes the form. I have code in the
Form_Error event that does a good job of providing a more
meaningful error message than the default. It works in every
situation except when the user clicks the close button. I am using
Me.Dirty=False to force a save but if there are duplicates I just
get the standard Runtime 3022 error message. I am wondering why
the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub
above to produce a custom error message, but the standard error
message was being produced as soon as the Me.Dirty=False statement
was reached. and the On Error Go To ErrorHandler was ignored. I
obvously don't understand the sequence of events enough. Can
anyone Help me out? By the way, The Form allows entry of Volunteer
Hours worked at a seniors home by various church groups.

Try trapping it within your close button code - use resume next
for the part that might trigger an error, and check.

Private Sub cmdClose_Click()

If Me.Dirty Then
On Error Resume Next
Me.Dirty = False
If (Err.Number = 3022) Then
Err.Clear
Me.Undo
End If
On Error Goto 0 ' or use your error handler
End If
DoCmd.Close acForm, Me.Name, acSaveYes

End Sub

I don't think the Form Error triggers by runtime errors, which is
what you'll get when firing off the save through code.

--
Roy-Vidar
If you are using resume next, then I think it should, could be you have
break on all errors (in VBE - Tools | Options - the General tab, set to
"Break on Unhandled Errors") - or is it another number? Something
triggered by for instance the before update event of the form?

--
Roy-Vidar
Nov 13 '06 #7
Roy,
I did have it set to "break on all errors". I didn't even think to look
at that. Between your help and Ed's my problem is solved. I really
appreciate the help. Thanks so much
RoyVidar wrote:
"g_man" <ga*******@gmail.comwrote in message
<11**********************@i42g2000cwa.googlegroups .com>:
Roy, thanks for your reply, I tried your code, with a watch on
Err.Number. The standard error message was triggered as soon as the
Me.Dirty=False statement was executed. Err.Number's value still had
not changed to 3022. Shouldn't execution skip to the next statement
after the line that triggers the error in other words to the
If(Err.Number....) statement?

RoyVidar wrote:
"g_man" <ga*******@gmail.comwrote in message
<11**********************@f16g2000cwb.googlegroups .com>:
I am trying trap Runtime error 3022 (duplicates) in the click event
of a command button that closes the form. I have code in the
Form_Error event that does a good job of providing a more
meaningful error message than the default. It works in every
situation except when the user clicks the close button. I am using
Me.Dirty=False to force a save but if there are duplicates I just
get the standard Runtime 3022 error message. I am wondering why
the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub
above to produce a custom error message, but the standard error
message was being produced as soon as the Me.Dirty=False statement
was reached. and the On Error Go To ErrorHandler was ignored. I
obvously don't understand the sequence of events enough. Can
anyone Help me out? By the way, The Form allows entry of Volunteer
Hours worked at a seniors home by various church groups.

Try trapping it within your close button code - use resume next
for the part that might trigger an error, and check.

Private Sub cmdClose_Click()

If Me.Dirty Then
On Error Resume Next
Me.Dirty = False
If (Err.Number = 3022) Then
Err.Clear
Me.Undo
End If
On Error Goto 0 ' or use your error handler
End If
DoCmd.Close acForm, Me.Name, acSaveYes

End Sub

I don't think the Form Error triggers by runtime errors, which is
what you'll get when firing off the save through code.

--
Roy-Vidar

If you are using resume next, then I think it should, could be you have
break on all errors (in VBE - Tools | Options - the General tab, set to
"Break on Unhandled Errors") - or is it another number? Something
triggered by for instance the before update event of the form?

--
Roy-Vidar
Nov 13 '06 #8
Ed,

That did the trick. Between your help and Roy's my problem is solved. I
really appreciate both of you taking the time to help me out.

Ed Robichaud wrote:
One common technique is to use the BeforeUpdate of the combobox to run a
DLookup of the underlying table and check for any matching records, then
either add it, or pop-up a msgbox and clear it.
-Ed

"g_man" <ga*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Ed, thanks for your reply. Strangely enough, using the close box on the
form with duplicate records does trigger my custom error message. The
problem I found was when the last record added is a duplicate. After
the combobox (cboGroupID) value is changed this changes the GroupID
field in the underlying table which is part of a multiple primary key
along with fields for the month and year. The Change event for this
combobox sets the focus in a text box to add the number of hours. If
the user enters hours in this box and then hits my close button and
hours have already been entered for this group in a previous record
then the standard Runtime error 3022 message is produced not my custom
message. If the user makes the duplicate entry and then tries to start
a new record, my message is displayed. It is only if it is the last
record before they hit my close button that the stock message gets
displayed. I have tried putting code into the before update event of
the form the combobox and numerous other events. Any ideas?

Ed Robichaud wrote:
Why not use the BeforeUpdate event of the form and/or the entry field for
the primary key? This would alert users to a duplicate before they
continue
to enter all the other info, rather than after the fact. BTW, you can
set
the form's properties to remove the Close box.
-Ed

"g_man" <ga*******@gmail.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
I am trying trap Runtime error 3022 (duplicates) in the click event of
a command button that closes the form. I have code in the Form_Error
event that does a good job of providing a more meaningful error message
than the default. It works in every situation except when the user
clicks the close button. I am using Me.Dirty=False to force a save but
if there are duplicates I just get the standard Runtime 3022 error
message. I am wondering why the Form_Error event is not triggered.

Here are the two relevant subs:
First the Form_Error Sub...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim strMsg As String
Dim Group As String
Dim Selection As Integer
Const conDuplicateKey = 3022
Group = DLookup("[Name]", "tblGroups", "[GroupID] = " _
& Me.GroupID)

If DataErr = conDuplicateKey Then
' Don't show built-in error messages
Response = acDataErrContinue
strMsg = "You have already entered hours for " & Group & vbCr
' Show a custom error message
MsgBox strMsg, vbOKOnly, "Duplicate Value"
If Response = vbOK Then
'Me.Undo
cboGroupID.SetFocus
End If
End If
End Sub

And the Close button's Click event

Private Sub cmdClose_Click()
Me.Dirty = False
DoCmd.Close acForm, Me.Name, acSaveYes
End Sub

I tried putting a On Error GoTo statement with a select case that
tested the Err.Number and then had similar code to Form_Error sub above
to produce a custom error message, but the standard error message was
being produced as soon as the Me.Dirty=False statement was reached. and
the On Error Go To ErrorHandler was ignored. I obvously don't
understand the sequence of events enough. Can anyone Help me out? By
the way, The Form allows entry of Volunteer Hours worked at a seniors
home by various church groups.
Nov 13 '06 #9

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

Similar topics

13
5456
by: TC | last post by:
Folks Is there >>ANY<< way to get the actual text of an error that is trapped by the Form_Error event? I mean actual text like: "duplicate record in table XYZ", not template text like:...
3
6857
by: Nathan Bloomfield | last post by:
Hi there, I am having difficulty with a piece of code which would work wonders for my application if only the error trapping worked properly. Basically, it works as follows: - adds records...
6
2294
by: dee | last post by:
Hi In web.config I have to the following: <configuration> <system.web> <customErrors defaultRedirect="error.htm" mode="On" /> </system.web> </configuration>
4
13585
by: Pat | last post by:
In my Web.config i have :- <customErrors mode="On" defaultRedirect="genericerror.htm"> <error statusCode="404" redirect="pagenotfound.aspx"/> </customErrors to get page not found error but...
6
8148
by: sara | last post by:
I have a procedure to automate bringing several Excel files into our Access tables, on a daily basis. The problem is that if the user has a problem, and tries to run the import again (maybe 3...
7
7765
by: Jan | last post by:
Hi: When I searched the newsgroup for this problem, I saw two or three instances of the question being asked, but it was never answered. Not too promising, but here goes: I have a form with...
2
19396
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
5
2729
by: dlblack | last post by:
I have created a form that captures Capital Project Request data for review. After the reviewer has made their decision as to approve or deny the project request, they click an approval button or a...
0
2897
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
7202
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
7328
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...
1
6991
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...
1
5013
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...
0
4672
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...
0
3167
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...
0
1512
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 ...
1
736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
380
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...

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.