Hi,
I am completely new to Access. Here is something that I am experiencing...
I have this form and I search for candidate. Whatever results I get, I try to navigate from one to another and it gives me this error - Access can't apply the filter because all records are locked.
I have set the Advanced Property (in Tools Menu --> Options) of Locking as No Lock but it is still the same. Please help.
Thanks.
19 4931
Hi,
I am completely new to Access. Here is something that I am experiencing...
I have this form and I search for candidate. Whatever results I get, I try to navigate from one to another and it gives me this error - Access can't apply the filter because all records are locked.
I have set the Advanced Property (in Tools Menu --> Options) of Locking as No Lock but it is still the same. Please help.
Thanks.
What is the record source of the form you are using?
What is the record source of the form you are using?
I know I am dumb to ask this but how do you find that? I am really new.
I know I am dumb to ask this but how do you find that? I am really new.
Open the form in Design View. Open the properties of the form. Under the Data tab there is a property called Record Source. While you're there check the property of the filter also.
Open the form in Design View. Open the properties of the form. Under the Data tab there is a property called Record Source. While you're there check the property of the filter also.
Record Source is Candidate
Filter field is empty.
Is Candidate table locked? That is what you mean?
Record Source is Candidate
Filter field is empty.
Is Candidate table locked? That is what you mean?
No I think your only problem is your searching. When you search you apply a filter to show only the record(s) you are searching for. You will have to remove the filter to continue to navigate through the records. How are you seaching the form?
No I think your only problem is your searching. When you search you apply a filter to show only the record(s) you are searching for. You will have to remove the filter to continue to navigate through the records. How are you seaching the form?
I got this -
Hope this helps. There is an [Event Procedure] in After Update properties. -
Private Sub SelectIDNo_AfterUpdate()
-
Me.Filter = ""
-
-
If Not IsNull(Me.SelectIDNo) Then
-
Me.FilterOn = True
-
Me.Filter = "[SSNo] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectIDNo] + "*'"
-
Else
-
Me.FilterOn = False
-
End If
-
-
Me.SelectIDNo = ""
-
End Sub
-
-
Private Sub SelectLastName_AfterUpdate()
-
-
Me.Filter = ""
-
-
If Not IsNull(Me.SelectLastName) Then
-
Me.Filter = "[LastName] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectLastName] + "*'"
-
Me.FilterOn = True
-
Else
-
Me.FilterOn = False
-
End If
-
-
Me.SelectLastName = ""
-
End Sub
-
Thanks- I do need to filter these results say based on SSN.
I got this -
Hope this helps. There is an [Event Procedure] in After Update properties. -
Private Sub SelectIDNo_AfterUpdate()
-
Me.Filter = ""
-
-
If Not IsNull(Me.SelectIDNo) Then
-
Me.FilterOn = True
-
Me.Filter = "[SSNo] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectIDNo] + "*'"
-
Else
-
Me.FilterOn = False
-
End If
-
-
Me.SelectIDNo = ""
-
End Sub
-
-
Private Sub SelectLastName_AfterUpdate()
-
-
Me.Filter = ""
-
-
If Not IsNull(Me.SelectLastName) Then
-
Me.Filter = "[LastName] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectLastName] + "*'"
-
Me.FilterOn = True
-
Else
-
Me.FilterOn = False
-
End If
-
-
Me.SelectLastName = ""
-
End Sub
-
Thanks- I do need to filter these results say based on SSN.
These filters control the records available to the form. Why do you need to navigate from the searched record. A button to return all records and remove all searches could be implemented.
These filters control the records available to the form. Why do you need to navigate from the searched record. A button to return all records and remove all searches could be implemented.
I am just search records from a given table, and getting some records. I wnt to navigate those returned records from the original recordset. But when I navigate I get this error. That is when I jump frm one record to another (in the returned recordset) I get this error. Other wise, in the original set, it navigates fine.
I am just search records from a given table, and getting some records. I wnt to navigate those returned records from the original recordset. But when I navigate I get this error. That is when I jump frm one record to another (in the returned recordset) I get this error. Other wise, in the original set, it navigates fine.
You must not be returning the number of records you think you are. In the navigation buttons on the bottom of the form it should say 1 of X (Filtered). The X represents the number of records being returned by the filter.
You must not be returning the number of records you think you are. In the navigation buttons on the bottom of the form it should say 1 of X (Filtered). The X represents the number of records being returned by the filter.
yes it says, 1 of 3 filtered. Also, if I click OK in the error popup the record jumps to next one but the error always pops up.
Thanks for your help. I really appreciate your efforts.
yes it says, 1 of 3 filtered. Also, if I click OK in the error popup the record jumps to next one but the error always pops up.
Thanks for your help. I really appreciate your efforts.
Comment out the lines reseting the textboxes.
and see if that makes any difference.
Mary
Comment out the lines reseting the textboxes.
and see if that makes any difference.
Mary
Nothing. Still same error and behaviour. :(
Nothing. Still same error and behaviour. :(
Is there any code in the forms events like the on current or on change event?
Is there any code in the forms events like the on current or on change event?
No. All I could see is BeforeUpdate and AfterUpdate events. And some print events for printing? - Private Sub SelectIDNo_AfterUpdate()
-
Me.Filter = ""
-
-
If Not IsNull(Me.SelectIDNo) Then
-
Me.Filter = "[SSNo] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectIDNo] + "*'"
-
Me.FilterOn = True
-
Else
-
Me.FilterOn = False
-
End If
-
-
Me.SelectIDNo = ""
-
End Sub
-
-
Private Sub SelectIDNo_BeforeUpdate(Cancel As Integer)
-
-
End Sub
-
-
Private Sub SelectLastName_AfterUpdate()
-
-
Me.Filter = ""
-
-
If Not IsNull(Me.SelectLastName) Then
-
Me.Filter = "[LastName] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectLastName] + "*'"
-
Me.FilterOn = True
-
Else
-
Me.FilterOn = False
-
End If
-
-
Me.SelectLastName = ""
-
End Sub
-
Is there any code in the forms events like the on current or on change event?
Is it possible to have any kind of virus in Database? Because this database was made in Office 2000. When I opened the same database using office 2003, it did not let me open it.
The error in Office 2003 was - " This database has programs that could harm your computer, do you still want to open it?"
Is it possible to have any kind of virus in Database? Because this database was made in Office 2000. When I opened the same database using office 2003, it did not let me open it.
The error in Office 2003 was - " This database has programs that could harm your computer, do you still want to open it?"
This is a standard warning message in 2003.
Compile the database and see if it compiles OK.
Mary
This is a standard warning message in 2003.
Compile the database and see if it compiles OK.
Mary
Hi, it opened fine. Thanks. But the error remains the same. :(
This is a standard warning message in 2003.
Compile the database and see if it compiles OK.
Mary
Is there a way to explicitly compile it?
Is there a way to explicitly compile it?
Open the VBA Editor window and you will find compile under the Debug menu (I think). If not it's there somewhere.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jerome |
last post by:
Hi, I'm a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?
Is it as easy...
|
by: Ed |
last post by:
Hi,
I'm stuck at the moment trying to work out how to access the value of a
textfield which gets added in a DIV element.
I have functions to add and remove the textfields from the elements as...
|
by: RCS |
last post by:
Okay, a rather 'interesting' situation has arisen at a place I work: I need
to convert a database from Access to something that can be used over the
web.
I am currently maintaining and...
|
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The...
|
by: egoldthwait |
last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a
Citrix farm. The issue: we have never converted an Access Db to Oracle
but can probably use Oracle's Workbench to assist with...
|
by: onnodb |
last post by:
Hi all,
While working on an Access UI to a MySQL database (which should be a
reasonable, low-cost, flexible interface to the DB, better than
web-based, much less costly than a full-fledged .NET...
|
by: IC1(SW/AW) |
last post by:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.
How can I write some...
|
by: ApexData |
last post by:
I am considering building some distributable commercial applications.
For about a year now, I have been using Access2000. This was my first
venture into object oriented database development. ...
|
by: Neil |
last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text
feature does not support: a) full text justification; b) programmatic
manipulation.
I was hoping that someone might...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
| |