Solved

You can't lock a control while it has unsaved changes

Posted on 2006-06-27
14
646 Views
Last Modified: 2009-12-16
Private Sub btnCalc_Click()
    Dim blnOK As Boolean
   
    blnOK = checkErrors
   
    If blnOK Then
        calculatePrice
        lblPrice.Caption = FormatCurrency(totalPrice)
        lblCost.Caption = FormatCurrency(totalCost)
        lblHours.Caption = totalHours
        Set lstPart.Recordset = rsPart
       
        highlightUsed
        lstPart.Locked = True
       
        blnQuoteGiven = True
    End If
   
   
   
End Sub

Public Sub highlightUsed()
    'highlights the row in the listbox that has the price that was used for the estimate
   
    Dim i As Integer
    For i = 1 To lstPart.ListCount
        If lstPart.Column(1, i) = rsPart!WAREHOUSE Then
            lstPart.Selected(i) = True
            Exit Sub
        End If
    Next
End Sub

"You can't lock a control while it has unsaved changes"
Why do i get this error, and how can i fix it?
0
Comment
Question by:intern1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
14 Comments
 

Author Comment

by:intern1
ID: 16995136
I'm trying to highlight the row in the listbox which has a value that has a certain value in it and then lock it so that it cannot be unselected.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 16995613
just to note, listbox entries start subscript start from zero

it should be for

for i = 0 to lstPart.ListCount-1


but not seen your error with regards to a listbox before




0
 

Author Comment

by:intern1
ID: 16995627
I believe, at least in Access, If you have column headers they count as the first row, but i will double check.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 65

Expert Comment

by:rockiroads
ID: 16995757
ok, I didnt realise u had column headers, in that case then yes, u start from 1

What is rsPart, is that rs anything to do with current form?
Have u tried creating a seperate rowsource, perhaps set rowsource using SQL instead
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 16995761
Have u tried creating a seperate rowsource

supposed to say

Have u tried creating a seperate recordset
0
 

Author Comment

by:intern1
ID: 16996167
I changed it to lstParts.rowsource = sSQL

It still gives me that lock error
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 16996243
Hmmm, I wonder if its changes in the form that your in, hence the error message
Though it dont make sense why it complains about it when u try to lock a listbox
Thats MS Access for ya


try one of two things

Me.Requery

or

Me.Dirty = False

before u lock the listbox

0
 

Author Comment

by:intern1
ID: 16996339
doesn't work.  I also tried putting the recordset back to the listbox and used dbOpenSnapShot as the type. That didn't work either
0
 

Author Comment

by:intern1
ID: 16996400
I made a temporary fix.  I'm storing the index i want selected in a module level variable and using the listbox click event to reselect it everytime a different list item gets clicked on.

But i'm still open to a real fix
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 16996415
I thought about that also, but I thought u wouldnt like that idea as its a hack

what happens if u disable the listbox instead of locking it, does that make a difference?
0
 

Author Comment

by:intern1
ID: 16996678
Disabling it works, but poses a problem if i want to allow them to scroll still.  I guess Lock would do the same thing? so i'll just have to make sure that i have the listbox big enough to see all possible items if i do that
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 16996731
whats the alternative, a subform perhaps?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CISCO WIFI 6 73
Return Data From Website in Access 6 59
View SQL Count Records 3 32
Creating a filter on a subform MS access 2010 6 17
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question