Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-05-2019, 10:41 PM   #16
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,573
Thanks: 58
Thanked 2,427 Times in 2,327 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Can't assign Value to this object

if you are calling the "Edit Form" from the main form (not on subform):

Me.BBSubForm.Form!theMemoName.ControlSource=""

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-05-2019, 11:37 PM   #17
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

Managed to sort out the syntax and applied the code... sadly it didn't change anything (afaik).
I still get the locked message (on at least the one with the problem) and it's ok on the others.
Is there anything else I could try? I can work around the glitch, but would be nice to have it fixed and learn why it does what it does.
kirkm is offline   Reply With Quote
Old 07-05-2019, 11:40 PM   #18
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

thanks arnelgp. I shall do that.. what I ended up now is
Code:
Private Sub cmdEdtEntry_Click()
    With Form_BBsubform
    .Controls("AComment").ControlSource = ""
    End With

    DoCmd.OpenForm "frmMismatchComm", acNormal, , , , acDialog, "BoundData"

    With Form_BBsubform
    .Controls("AComment").ControlSource = "AComment"
    End With
    
End Sub

kirkm is offline   Reply With Quote
Old 07-05-2019, 11:43 PM   #19
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,573
Thanks: 58
Thanked 2,427 Times in 2,327 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Can't assign Value to this object

if nothing works, can you upload your db.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-06-2019, 10:04 AM   #20
axsprog
Newly Registered User
 
Join Date: Jun 2019
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
axsprog is on a distinguished road
Re: Can't assign Value to this object

default value setting in form
axsprog is offline   Reply With Quote
Old 07-06-2019, 05:24 PM   #21
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

Thanks arnelgp. I've spent most of today trying to trim it back to a bare minimum - to demo the problem. It's still 4 MB after compacting.
I will try and make it smaller. Is there a size limit to an attachment here?
kirkm is offline   Reply With Quote
Old 07-06-2019, 06:58 PM   #22
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,573
Thanks: 58
Thanked 2,427 Times in 2,327 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Can't assign Value to this object

just leave 2 records from your table with notes/memo. include the form and subform and the edit form. compact and repair. then Zip your db and upload the Zip file.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-07-2019, 12:15 AM   #23
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

Understood... but as I was trimming it further just now , I tested for the problem and it has gone. So I'll start over and try to pinpoint what /when it comes right.
kirkm is offline   Reply With Quote
Old 07-07-2019, 03:36 AM   #24
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Can't assign Value to this object

Quote:
Could not update; currently locked by another session on this machine.".
This is not to do with the ldb file

if you have two forms open, with the same record and you try to save one, you will see a message something like "another user has edited your record", when in fact YOU YOURSELF are the other user.

One way to see this is to add record selectors to your forms. a dirty/edited record will show a pencil in the record selector bar to the left of the detail area.


Are you actually using RECORD LOCKING in your database? - your error message is different to the one I mentioned above, which is what you get with no record locking (optimistic record locking). If so, I would think carefully whether you do need record locking, as it can add more complications than it solves.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 07-07-2019, 03:36 PM   #25
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

I'm not sure if I have Record Locking. Most likely it's whatever the default is. I haven't got Record selectors on the edit Form as it looks at just one Record. This Form seems okay as both the original and cut back work. The problem must be something removed from somewhere else.

There is a record selected on the main form, then the edit Form opens to this record. This usually save changes but it's not consistent .
kirkm is offline   Reply With Quote
Old 07-07-2019, 05:20 PM   #26
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,077
Thanks: 81
Thanked 1,600 Times in 1,484 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Can't assign Value to this object

Quote:
There is a record selected on the main form, then the edit Form opens to this record.
That is two references to the same record at the same time, and forms usually are opened in an update mode. Then your edit will do the same. That is your conflict.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 07-07-2019, 11:28 PM   #27
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

You're probably spot on, but I haven't found it yet. In its cut down form it is working mostly as beforehand with only *some* records failing. I don't understand that so it'll be interesting to find out exactly what's going on.
kirkm is offline   Reply With Quote
Old 07-07-2019, 11:32 PM   #28
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,573
Thanks: 58
Thanked 2,427 Times in 2,327 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Can't assign Value to this object

you uoload your db with the form and the form for eding even with no records on the table and well just add one.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-08-2019, 05:12 PM   #29
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 649
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Can't assign Value to this object

At the moment the demo works so there would be nothing to show you.
I now have the demo and original on 2 different computers and hope to step through each and detect where one errors and the other doesn't.
That's my plan, but I've struck an unrelated problem.
Error 429 Active-X component can't create Object
Code:
Set clsMouseWheel = New MouseWheel.CMouseWheel
After looking further I find although "MouseWheel.dll" is in the Windows/System32 folder, browsing to it from Access will not find it. Likewise Running REGSVR also fails to find it.
Is this somethingt to do with 64 bit ? (Windows on this machine is 64 bit)
kirkm is offline   Reply With Quote
Old 07-08-2019, 08:47 PM   #30
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,573
Thanks: 58
Thanked 2,427 Times in 2,327 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Can't assign Value to this object

i don't see any mousewheel.dll on windows 10 x64.
you have to copy it from the computer that has it.
put both on system32 and syswow64.
then run regsvr (the 64 version) from syswow64.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
can't assign a value to this object deltekkie Forms 10 04-02-2019 07:48 AM
You Can't Assign A Value To This Object forms_are_nightmares Forms 22 02-14-2013 09:19 PM
can't assign value to an object jeo Forms 1 01-13-2005 01:26 PM
You cant assign a value to this object?? desibasha General 0 04-08-2004 02:02 PM
You can't assign a value to this object kholm Forms 1 10-30-2002 12:31 PM




All times are GMT -8. The time now is 11:57 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World