access troubles after office service pack 1a update

  • Thread starter Thread starter bulldoggrace
  • Start date Start date
B

bulldoggrace

I have office 2000 pro and installed the service pack
update and now when I run access 2000 I can no longer
filter records correctly. I have a command button on a
form that will filter a record by acct number. When the
form is opened and the command button is cliked for the
first time it works fine. If I click on the command
button a second time to view a different acct number it
dose not function. Not sure if a global options was
changed and I could just not locate. Thank you for any
help offered?
 
More info:
- Is [Acct Number] a Text field or a Number field?
- What code is in the Click event procedure of your button?

The service packs are *really* important.
Make sure you also install SP3 for Office 2000, and SP8 for JET 4.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
[acct number] is a number field
the command button was programmed by the wizard in vb to
run a macro

Thanks for the help
-----Original Message-----
More info:
- Is [Acct Number] a Text field or a Number field?
- What code is in the Click event procedure of your button?

The service packs are *really* important.
Make sure you also install SP3 for Office 2000, and SP8 for JET 4.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"(e-mail address removed)"
message
I have office 2000 pro and installed the service pack
update and now when I run access 2000 I can no longer
filter records correctly. I have a command button on a
form that will filter a record by acct number. When the
form is opened and the command button is cliked for the
first time it works fine. If I click on the command
button a second time to view a different acct number it
dose not function. Not sure if a global options was
changed and I could just not locate. Thank you for any
help offered?
Click to expand...


.
Click to expand...
 
Try something like the following. It assumes:
- You have an *unbound* text box named "txtFindAccNum" where the user enters
the number to filter.
- You have a button named "cmdFilter" that performs the filtering.
- You have set the button's On Click property to:
[Event Procedure]

Private Sub cmdFilter_Click()
If Not IsNull(Me.txtFindAccNum) Then
MsgBox "Enter a number."
Else
If Me.Dirty Then 'Save first.
Me.Dirty = False
End If
With Me.RecordsetClone
.FindFirst "[Acct Number] = " & Me.[txtFindAccNum]
If .NoMatch Then
MsgBox "Not found"
Else
Me.Bookmark = .Bookmark
End If
End With
End If
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
[acct number] is a number field
the command button was programmed by the wizard in vb to
run a macro

Thanks for the help
-----Original Message-----
More info:
- Is [Acct Number] a Text field or a Number field?
- What code is in the Click event procedure of your button?

The service packs are *really* important.
Make sure you also install SP3 for Office 2000, and SP8 for JET 4.


"(e-mail address removed)"
message
I have office 2000 pro and installed the service pack
update and now when I run access 2000 I can no longer
filter records correctly. I have a command button on a
form that will filter a record by acct number. When the
form is opened and the command button is cliked for the
first time it works fine. If I click on the command
button a second time to view a different acct number it
dose not function. Not sure if a global options was
changed and I could just not locate. Thank you for any
help offered?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top