duplicate fields

[Guest]

Hi i am using some code that is supposed to check if a field (serial number)
has been entered in twice in two different records and i am keep receiving
the error invalid use of null. Here is my code. I would appreicate any help.


Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim SERIAL_NO As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset

Set rsc = Me.RecordsetClone

SERIAL_NO = Me.SERIAL_NO.Value
stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

'check form details tables for duplicate SERIAL_NO
If DCount("Serial_NO", "Hardware", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Warning Serial Number " _
& SERIAL_NO & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.", vbInformation _
, "Duplicate Information"
'Go to record of original Serial Number
rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark
End If

Set rsc = Nothing
End Sub

 

[Tim Ferguson]

Hi i am using some code that is supposed to check if a field (serial
number) has been entered in twice in two different records and i am
keep receiving the error invalid use of null. Here is my code. I would
appreicate any help.


stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark

You don't say which error is causing the Use Of Null error, but I'm
guessing it's the rsc.Bookmark expression. It's always a good idea to
check for NoMatch before assuming that there is a current record.

A more specific worry is whether Serial_No is really a text value: if
it's not then filtering on

Serial_No = '1023'

is dodgy and may fail. But that doesn't explain the error above so I may
be way off.

As a slightly wider concern, you seem to be making a lot of work for
yourself. Since you are scanning the entire recordset once, there is no
need to do it twice. For example:

strLinkCriterion = "Serial_No = " & etc
rsc.FindFirst strLinkCriterion
If rsc.NoMatch Then
' the record is a new one, don't do anything

Else
' point at it
MsgBox etc, etc
Me.Bookmark = rsc.Bookmark

End If


As a wider concern again, it's not very friendly to wait until the
Form_BeforeUpdate event before ditching the user's input. It might be
kinder to use the Serial_No_BeforeUpdate event, or actually to handle the
entire allocation business programmatically.

HTH


Tim F

 

[Nick]

Hi Tim,
I hope you don't mind me jumping in as I have a similar
problem.
I have two fields MemNo and Status. The status has codes
F, N, NF, A and X. If when the MenNo and Status are equal
when the status code equals F, N or NF I would like to be
prevented from creating a new or changing an existing
record which give a message to change either field. (This
does not apply to other status codes, A and X).
I hope this makes sense?
Nick

-----Original Message-----
"=?Utf-8?B?QWxmcmVkIEZQQw==?="

wrote in news:068A3441-70F8-41FD-B6CA- (e-mail address removed):

Hi i am using some code that is supposed to check if a field (serial
number) has been entered in twice in two different records and i am
keep receiving the error invalid use of null. Here is my code. I would
appreicate any help.


stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark

You don't say which error is causing the Use Of Null error, but I'm
guessing it's the rsc.Bookmark expression. It's always a good idea to
check for NoMatch before assuming that there is a current record.

A more specific worry is whether Serial_No is really a text value: if
it's not then filtering on

Serial_No = '1023'

is dodgy and may fail. But that doesn't explain the error above so I may
be way off.

As a slightly wider concern, you seem to be making a lot of work for
yourself. Since you are scanning the entire recordset once, there is no
need to do it twice. For example:

strLinkCriterion = "Serial_No = " & etc
rsc.FindFirst strLinkCriterion
If rsc.NoMatch Then
' the record is a new one, don't do anything

Else
' point at it
MsgBox etc, etc
Me.Bookmark = rsc.Bookmark

End If


As a wider concern again, it's not very friendly to wait until the
Form_BeforeUpdate event before ditching the user's input. It might be
kinder to use the Serial_No_BeforeUpdate event, or actually to handle the
entire allocation business programmatically.

HTH


Tim F

.

 

[Tim Ferguson]

If when the MenNo and Status are equal
when the status code equals F, N or NF I would like to be
prevented from creating a new or changing an existing
record which give a message to change either field.

What is the question? This sound more like a table design issue than
anything else...


Tim F

 

[Nick]

Hi Tim,
I think you are right it probably is a design problem.
Being very new to access and not knowing VB it is hard to
know which way to go, so I hope you could point me in the
right direction.
The table I'm using has the following fields; ID - auto
number primary key, Member Number - number, Status - text
and then other fields for personal details.

Our club is small and we re-use member numbers. These
member numbers become available for re-use when the member
has been archived, (Status A), or declined, (Status X). So
there may be multiple members with the same member number
and the same Status A or X.
The Status codes we use that cannot have duplicates are N
for new members, F for financial members and NF for non-
financial members

If a previous member re-joins the club, that is they are
archived A, we simply change their status to, N or F and
we also try to issue them their old member number if
available. This save time re-entering their data and keep
the database size to a minium.

I suppose that what I was trying to ask in my last post
was, is there any way of putting some code in place that
would not allow duplicates member numbers for members
who's status is N, F or NF but would allow duplicates for
member numbers for members who's status is A or X.
Regards
Nick

 

[Tim Ferguson]

[email protected]:

I hope you could point me in the

right direction.

Since this is a new question, you should really start a new thread.
Alfred (?) the original poster is unlikely to want to read through a lot
of unrelated stuff.

These
member numbers become available for re-use when the member
has been archived,

Unless you have a really good business need for this, it is generally a
Really Bad Idea.


B Wishes


Tim F

 

[Nick]

Thanks Tim,
I'll try a new post some time.
Regards
Nick

 

[Guest]

Good morning, i have an additional question related to my previosu question i
first asked a couple days ago. Now after i use a form with one single textbox
in which i enter a serial number i intend for my code to search the entire
table and tell me if it has found a match, and if it has take me to that
specific match, now if it does not find a match it can just take me to the
first record on the form that i am pointing to (hardware). After i click my
validate button it tells me whether or not it found a match but it gives me
an error saying run-time error '2465' Microsoft Access can't find the field
'|' reffered to in your expression. I'm guessing it is something wrong with
my code that i am missing. I would appreciate any help with this .

-thanks

here is my code


Dim SERIAL_NO As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset


SERIAL_NO = Me.SERIAL_NO.Value
stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

'check form details tables for duplicate SERIAL_NO
If DCount("Serial_NO", "Hardware", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Warning Serial Number " _
& SERIAL_NO & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.", vbInformation _
, "Duplicate Information"
'Go to record of original Serial Number
DoCmd.OpenForm "hardware"

Form_hardware.Combo48.SetFocus
Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
Me.Bookmark = Me.RecordsetClone.Bookmark
rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark
End If



Set rsc = Nothing
End Sub

 

[Ken Snell [MVP]]

I'm confused by your code... you are doing two searches in a row and moving
the form's recordset to the result of each search. Do you really mean to do
that? Only the last search will be the result on your form.
Form_hardware.Combo48.SetFocus
Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
Me.Bookmark = Me.RecordsetClone.Bookmark
rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark

To move to the first record if there is no match, replace these lines of
code with these (I am assuming that you just need the first search):
Form_hardware.Combo48.SetFocus
Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark

 

[Guest]

Thanks for your quick response. To respond to what you said i am intending to
do only one search and if their is a match i would like the recordset to be
at that record in which it matched with, but if there is no match i would
like just the first record to come up. How off am i with my code?

I'm confused by your code... you are doing two searches in a row and moving
the form's recordset to the result of each search. Do you really mean to do
that? Only the last search will be the result on your form.
Form_hardware.Combo48.SetFocus
Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
Me.Bookmark = Me.RecordsetClone.Bookmark
rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark

To move to the first record if there is no match, replace these lines of
code with these (I am assuming that you just need the first search):
Form_hardware.Combo48.SetFocus
Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark

--

Ken Snell
<MS ACCESS MVP>

Good morning, i have an additional question related to my previosu
question i
first asked a couple days ago. Now after i use a form with one single
textbox
in which i enter a serial number i intend for my code to search the entire
table and tell me if it has found a match, and if it has take me to that
specific match, now if it does not find a match it can just take me to the
first record on the form that i am pointing to (hardware). After i click
my
validate button it tells me whether or not it found a match but it gives
me
an error saying run-time error '2465' Microsoft Access can't find the
field
'|' reffered to in your expression. I'm guessing it is something wrong
with
my code that i am missing. I would appreciate any help with this .

-thanks

here is my code


Dim SERIAL_NO As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset


SERIAL_NO = Me.SERIAL_NO.Value
stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

'check form details tables for duplicate SERIAL_NO
If DCount("Serial_NO", "Hardware", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Warning Serial Number " _
& SERIAL_NO & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.", vbInformation
_
, "Duplicate Information"
'Go to record of original Serial Number
DoCmd.OpenForm "hardware"

Form_hardware.Combo48.SetFocus
Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
Me.Bookmark = Me.RecordsetClone.Bookmark
rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark
End If



Set rsc = Nothing
End Sub

 

[Ken Snell [MVP]]

Thanks for your quick response. To respond to what you said i am intending
to
do only one search and if their is a match i would like the recordset to
be
at that record in which it matched with, but if there is no match i would
like just the first record to come up. How off am i with my code?

See my post to which you replied. I put the code near the end of the reply.

 

[Guest]

Hey i tried that new code you gave me in place of mines and i am still
getting the error : "RUN TIME ERROR '2465' Microsoft Office Access can't find
the field '|' reffered to in your expression."

Any ideas on this. Here is what my new code looks like with what you gave me.

CODE::::

Private Sub Command4_Click()

Dim SERIAL_NO As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset


SERIAL_NO = Me.SERIAL_NO.Value
stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

'check form details tables for duplicate SERIAL_NO
If DCount("Serial_NO", "Hardware", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Warning Serial Number " _
& SERIAL_NO & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.", vbInformation _
, "Duplicate Information"
'Go to record of original Serial Number
DoCmd.OpenForm "hardware"
DoCmd.FindRecord stLinkCriteria
' rsc.FindFirst stLinkCriteria
' Me.Bookmark = rsc.Bookmark
Form_hardware.Combo48.SetFocus


Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
End If

Set rsc = Nothing
End Sub

 

[Ken Snell [MVP]]

I see that SERIAL_NO is a text field. Change the last block of code to this:

Me.RecordsetClone.FindFirst "SERIAL_NO = '" & Me.[Combo48] & "'"
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
End If

 

[Guest]

Ok i put this last code into the last block and i am still getting the same
error as before. Just to run down with you very briefly. What is going on is
that their is a textbox on a form called validate. Now that form has a
textbox and that textbox is supposed to search for a match in the table. Now
if it finds a match it is supposed to find it and bring it up in another form
called hardware. When the form hardware opens up it just brings me to the
first record in the table everytime and that is the same place i receieve the
error based on the code that we both have been trying to get. Now in addition
on the hardware form, which is the one that opens up, their is a textbox
called serial_no that is where the data comes from to do the comparison. Now
their is another box which is a combo box and it is called combo48 and this
combobox "afterupdate" searches all of the records in the main table and
brings up the record. Now my intention is to use that use that combo48 to
search after the form hardware is brought up to bring up the record from the
validate screen. I apologize ahead of time i know it is alot of info and i
would greatly appreciate any ideas with this. And i do appreciate all the
help you have given me so far.

-alfred

I see that SERIAL_NO is a text field. Change the last block of code to this:

Me.RecordsetClone.FindFirst "SERIAL_NO = '" & Me.[Combo48] & "'"
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
End If


--

Ken Snell
<MS ACCESS MVP>

Hey i tried that new code you gave me in place of mines and i am still
getting the error : "RUN TIME ERROR '2465' Microsoft Office Access can't
find
the field '|' reffered to in your expression."

Any ideas on this. Here is what my new code looks like with what you gave
me.

CODE::::

Private Sub Command4_Click()

Dim SERIAL_NO As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset


SERIAL_NO = Me.SERIAL_NO.Value
stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

'check form details tables for duplicate SERIAL_NO
If DCount("Serial_NO", "Hardware", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Warning Serial Number " _
& SERIAL_NO & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.", vbInformation
_
, "Duplicate Information"
'Go to record of original Serial Number
DoCmd.OpenForm "hardware"
DoCmd.FindRecord stLinkCriteria
' rsc.FindFirst stLinkCriteria
' Me.Bookmark = rsc.Bookmark
Form_hardware.Combo48.SetFocus


Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
End If

Set rsc = Nothing
End Sub

 

[Ken Snell [MVP]]

You're using
Form_hardware.Combo48.SetFocus

in one line, and then I used
Me.[Combo48]

in another.

I admit to not having a very good idea of your form setup and such. I think
perhaps the code that I provided is doing a search on the wrong form. That
code will search on the form that is running the code, but I think you're
wanting to do the search on the other form instead?

I am unfamiliar with the syntax of Form_hardware as an object for a form?
Perhaps you have set that equal to some form object?

I'm sorry, I'm just not able to follow along with what your code is wanting
to do here. I've read your explanation for what you want to happen, but I'm
just not clear about the details.

Let me repeat back what I think I'm understanding (which is not everything)
and tell me where I'm off the track:

(1) A form named Validate has a text box on it. The user enters a value into
this textbox.
(2) You run code that determines if the entered value is in a table (which
one?).
(3) If the value in (2) is found in the table, a new form named Hardware is
opened. This form is supposed to display the record matched to the value in
(1).

At this point, I am becoming lost. I don't know which form has Combo48 on it
nor what it's relationship is to the serial_no textbox. I also don't know
which form contains the serial_no textbox.

May I suggest that you step back and carefully outline what is supposed to
happen -- what the user enters, what the form's code does, etc.
--

Ken Snell
<MS ACCESS MVP>

Ok i put this last code into the last block and i am still getting the
same
error as before. Just to run down with you very briefly. What is going on
is
that their is a textbox on a form called validate. Now that form has a
textbox and that textbox is supposed to search for a match in the table.
Now
if it finds a match it is supposed to find it and bring it up in another
form
called hardware. When the form hardware opens up it just brings me to the
first record in the table everytime and that is the same place i receieve
the
error based on the code that we both have been trying to get. Now in
addition
on the hardware form, which is the one that opens up, their is a textbox
called serial_no that is where the data comes from to do the comparison.
Now
their is another box which is a combo box and it is called combo48 and
this
combobox "afterupdate" searches all of the records in the main table and
brings up the record. Now my intention is to use that use that combo48 to
search after the form hardware is brought up to bring up the record from
the
validate screen. I apologize ahead of time i know it is alot of info and i
would greatly appreciate any ideas with this. And i do appreciate all the
help you have given me so far.

-alfred

I see that SERIAL_NO is a text field. Change the last block of code to
this:

Me.RecordsetClone.FindFirst "SERIAL_NO = '" & Me.[Combo48] & "'"
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
End If


--

Ken Snell
<MS ACCESS MVP>

Hey i tried that new code you gave me in place of mines and i am still
getting the error : "RUN TIME ERROR '2465' Microsoft Office Access
can't
find
the field '|' reffered to in your expression."

Any ideas on this. Here is what my new code looks like with what you
gave
me.

CODE::::

Private Sub Command4_Click()

Dim SERIAL_NO As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset


SERIAL_NO = Me.SERIAL_NO.Value
stLinkCriteria = "[Serial_NO]=" & "'" & SERIAL_NO & "'"

'check form details tables for duplicate SERIAL_NO
If DCount("Serial_NO", "Hardware", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Warning Serial Number " _
& SERIAL_NO & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.",
vbInformation
_
, "Duplicate Information"
'Go to record of original Serial Number
DoCmd.OpenForm "hardware"
DoCmd.FindRecord stLinkCriteria
' rsc.FindFirst stLinkCriteria
' Me.Bookmark = rsc.Bookmark
Form_hardware.Combo48.SetFocus


Me.RecordsetClone.FindFirst "SERIAL_NO = " & Me.[Combo48]
If Me.RecordsetClone.NoMatch = True Then
Me.RecordsetClone.MoveFirst
MsgBox "No record found that matches your entry."
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
End If

Set rsc = Nothing
End Sub

 

[Guest]

I apologize for the hard time that i am giving you but please bare with me
for a minute let me run it down.

1.) A form called "Validate" appears with textbox called "validate_serial"
2.) User enters a serial number into textbox "validate_serial"
3.) This number is searched from a table called "hardware"
4.) If a match is found a message box appears and says that ' Warning Serial
number ????? has already been entered, You will now been taken to the record'
5.) Then the form "hardware" opens and the user is taken to that record in
the form "hardware"
6.) If no match was found then user is taken to the first record in a form
called "hardware"

i hope this makes more sense than i said it before. That is the
functionality of what im trying to do. Now Combo48 is a combo box in
the"hardware" from which opens up after the number is entered into the
"validate" form. Combo48 has the following code associated with it
afterupdate

:::Me.RecordsetClone.FindFirst "[PROPERTY_ID] = " & Me![Combo48]
Me.Bookmark = Me.RecordsetClone.Bookmark

So I was trying to use combo48's afterupdate feature to search for the
record from the "validate" form. Maybe a better question to ask you would be
is this possible to use that feature in a different form. In essense i am
trying to use a record search in one form "hardware" to pull up a record's
number from another form "validate"

Again thank you and i hope this sheads some light on the situation.

-alfred

 

[Ken Snell [MVP]]

No apology needed....it's not always easy to describe what you see and know
to a complete stranger! < g >

Now, what you've posted here helps immensely. I am going to recommend an
entirely different approach to you for doing what you want. (Note that there
are many ways to do what you want to do; this is just one way to get there.)
Two methods initially come to mind. One would continue the use of your
Validate form. The other would eliminate the use of the Validate form and
instead use the Hardware form both for validation and for displaying the
data.

Which approach would you prefer to try? Post back with your decision; also
include the Record Source string from the Hardware form so that we'll be
able to use it in the suggested approach (note that, if the record source is
a table name, then post the name of the table and the field names in the
table that you're using in the Hardware form).

 

[Guest]

Sorry it took so long for me to get back to you i have been in meetings for
the last day and a half. But as far as solutions are concerned i don't need
the validation form i just thought it might have been a good idea to
incorporate it in the DB. I realized more and more how much simplier it would
to not do it with the validation form so i think that would probably be the
best way for me to go for the rest of this project.

the record source is indeed the table named "hardware"
Field Names: STATE_PROPERTY_ID, PROPERTY_ID, TYPE, SERIAL_NO, STATUS,
ASSIGNED_LOCATION, ORGANIZATION, DATE_UPDATE, SURPLUS_DATE, MAKE, MODEL,
SURPLUS TO, COMMENTS.
Also there is a subform called "Transfer History" and is has the fields:
PROPERTY_ID, TRANSFERRING_CITY, TRANSFERRING_SECTION,
RECEIVING_CITY,RECEIVING_SECTION, TRANSFER_DATE.
Also their are the 3 search fields that use this code:::

Me.RecordsetClone.FindFirst "[PROPERTY_ID] = " & Me![Combo38]
Me.Bookmark = Me.RecordsetClone.Bookmark

and those fields are called combo42, combo38, and combo48

Just to clarify, the name of the table is called "hardware" and the name of
the form is named "hardware" as well. I am making some changes to this
database that someone else created years ago, so i hope it doesn't confuse
you.

hope that is everything you need let me know if you need anything else.

thanx

-alfred

 

[Ken Snell [MVP]]

OK .

Open the Hardware form in design view. If not already visible, make the Form
Header and Footer sections visible (View | Form Header/Footer).

Put a combo box in the Form Header section. Let's name it cboFind. Set its
Row Source property to this:
SELECT PROPERTY_ID FROM Hardware ORDER BY PROPERTY_ID;

Click on the Event tab for the combo box, and select After Update event.
Select [Event Procedure] from the dropdown list. Click the three-dot button
at far right of box to open the Visual Basic Editor (VBE). In the line
between the "Private Sub" and "End Sub" lines, type this:
Me.Requery

Close the VBE.

Change the Record Source of the main form to this:
SELECT * FROM Hardware WHERE PROPERTY_ID=[cboFind];

Save the form.

Now to "move" to the desired record when you open the form, select the
desired property id value from the combo box. The form then will display the
matching data.

 

[Guest]

Ken,

Thanks a lot. You have helped me so much and i cannot thank you enough.
Everything works great and this is exactly the solution i was looking for. I
wish if i had some other questions on access that i could ask you directly
but i know the chances are probably slim to none. But again thanks and God
Bless.

-alfred