473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

RecordLocks In Access - Stuck here.

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.
Mar 26 '07 #1
19 4931
MMcCarthy
14,534 Expert Mod 8TB
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?
Mar 26 '07 #2
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.
Mar 26 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
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.
Mar 26 '07 #4
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?
Mar 26 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
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?
Mar 26 '07 #6
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.

Expand|Select|Wrap|Line Numbers
  1. Private Sub SelectIDNo_AfterUpdate()
  2.     Me.Filter = ""
  3.  
  4.     If Not IsNull(Me.SelectIDNo) Then
  5.         Me.FilterOn = True
  6.         Me.Filter = "[SSNo] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectIDNo] + "*'"
  7.     Else
  8.         Me.FilterOn = False
  9.     End If
  10.  
  11.     Me.SelectIDNo = ""
  12. End Sub
  13.  
  14. Private Sub SelectLastName_AfterUpdate()
  15.  
  16.     Me.Filter = ""
  17.  
  18.     If Not IsNull(Me.SelectLastName) Then
  19.         Me.Filter = "[LastName] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectLastName] + "*'"
  20.         Me.FilterOn = True
  21.     Else
  22.         Me.FilterOn = False
  23.     End If
  24.  
  25.     Me.SelectLastName = ""
  26. End Sub
  27.  
Thanks- I do need to filter these results say based on SSN.
Mar 26 '07 #7
MMcCarthy
14,534 Expert Mod 8TB
I got this -

Hope this helps. There is an [Event Procedure] in After Update properties.

Expand|Select|Wrap|Line Numbers
  1. Private Sub SelectIDNo_AfterUpdate()
  2.     Me.Filter = ""
  3.  
  4.     If Not IsNull(Me.SelectIDNo) Then
  5.         Me.FilterOn = True
  6.         Me.Filter = "[SSNo] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectIDNo] + "*'"
  7.     Else
  8.         Me.FilterOn = False
  9.     End If
  10.  
  11.     Me.SelectIDNo = ""
  12. End Sub
  13.  
  14. Private Sub SelectLastName_AfterUpdate()
  15.  
  16.     Me.Filter = ""
  17.  
  18.     If Not IsNull(Me.SelectLastName) Then
  19.         Me.Filter = "[LastName] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectLastName] + "*'"
  20.         Me.FilterOn = True
  21.     Else
  22.         Me.FilterOn = False
  23.     End If
  24.  
  25.     Me.SelectLastName = ""
  26. End Sub
  27.  
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.
Mar 26 '07 #8
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.
Mar 26 '07 #9
MMcCarthy
14,534 Expert Mod 8TB
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.
Mar 26 '07 #10
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.
Mar 26 '07 #11
MMcCarthy
14,534 Expert Mod 8TB
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.
Expand|Select|Wrap|Line Numbers
  1. 'Me.SelectIDNo = ""
and see if that makes any difference.

Mary
Mar 26 '07 #12
Comment out the lines reseting the textboxes.
Expand|Select|Wrap|Line Numbers
  1. 'Me.SelectIDNo = ""
and see if that makes any difference.

Mary

Nothing. Still same error and behaviour. :(
Mar 26 '07 #13
MMcCarthy
14,534 Expert Mod 8TB
Nothing. Still same error and behaviour. :(
Is there any code in the forms events like the on current or on change event?
Mar 26 '07 #14
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?

Expand|Select|Wrap|Line Numbers
  1. Private Sub SelectIDNo_AfterUpdate()
  2.     Me.Filter = ""
  3.  
  4.     If Not IsNull(Me.SelectIDNo) Then
  5.         Me.Filter = "[SSNo] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectIDNo] + "*'"
  6.         Me.FilterOn = True
  7.     Else
  8.         Me.FilterOn = False
  9.     End If
  10.  
  11.     Me.SelectIDNo = ""
  12. End Sub
  13.  
  14. Private Sub SelectIDNo_BeforeUpdate(Cancel As Integer)
  15.  
  16. End Sub
  17.  
  18. Private Sub SelectLastName_AfterUpdate()
  19.  
  20.     Me.Filter = ""
  21.  
  22.     If Not IsNull(Me.SelectLastName) Then
  23.         Me.Filter = "[LastName] LIKE '" + Forms![AO_ViewEditCandidateData]![SelectLastName] + "*'"
  24.         Me.FilterOn = True
  25.     Else
  26.         Me.FilterOn = False
  27.     End If
  28.  
  29.     Me.SelectLastName = ""
  30. End Sub
  31.  
Mar 27 '07 #15
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?"
Mar 27 '07 #16
MMcCarthy
14,534 Expert Mod 8TB
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
Mar 27 '07 #17
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. :(
Mar 27 '07 #18
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?
Mar 27 '07 #19
MMcCarthy
14,534 Expert Mod 8TB
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
Mar 27 '07 #20

Sign in to post your reply or Sign up for a free account.

Similar topics

63
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...
2
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...
7
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...
4
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...
2
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...
6
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...
17
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...
14
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. ...
16
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...
0
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...
0
isladogs
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...
1
isladogs
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...
0
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...
0
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...
1
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...
1
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....
0
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...
0
isladogs
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...

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.