Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / May 2007

Tip: Looking for answers? Try searching our database.

Checkbox Value Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trepalium@gmail.com - 03 May 2007 19:33 GMT
Hello,

  I'm getting an error telling me that "You can't assign a value to
this object" whenever I try to assign values to a checkbox. My Code is
below. Any ideas? I have the values assigned as true and false in this
code, but I have tried with 0 and 1 and have received the same error.

------------------------------------------------------------------------------------------------------------------------------------
Private Sub List372_BeforeUpdate(Cancel As Integer)
ErrorID = List372.Column(0)
ErrorCategory = List372.Column(1)
ErrorType = List372.Column(2)
ErrorDetail = List372.Column(3)
ErrorDate = List372.Column(4)

Call DBConnect

sql = "SELECT
ERRORID,ERRORCATEGORY,ERRORTYPE,ERRORDETAIL,ERRORDESCRIPTION,ERRORDATE,RESPONSIBLEPARTY,ERRORRESOLVED
FROM " & tblErrors & " WHERE ERRORID = '" & ErrorID & "'"
rsdata.Open (sql)

Text380.Value = rsdata("ERRORCATEGORY")
Text382.Value = rsdata("ERRORTYPE")
Text384.Value = rsdata("ERRORDETAIL")
Text386.Value = rsdata("ERRORDESCRIPTION")
Text390.Value = rsdata("ERRORDATE")
Combo505.Value = rsdata("RESPONSIBLEPARTY")

If rsdata("ERRORRESOLVED") = 1 Then
   Check392.Value = True
ElseIf rsdata("ERRORRESOLVED") = O Then
   Check392.Value = False
End If

rsdata.Close

End Sub
----------------------------------------------------------------------------------------------------------
Ed Metcalfe - 03 May 2007 23:58 GMT
> Hello,
>
[quoted text clipped - 35 lines]
> End Sub
> ----------------------------------------------------------------------------------------------------------

I assume the errors are occurring here:
Check392.Value = True
Check392.Value = False

If so I can't see anything wrong with what you are trying to do. Are you
sure these control is an Access checkbox? Try running the following check in
the immediate window:

?typeof forms!form1!check392 is Access.CheckBox

Ed Metcalfe.
Trepalium@gmail.com - 04 May 2007 20:44 GMT
> <Trepal...@gmail.com> wrote in message
>
[quoted text clipped - 53 lines]
>
> - Show quoted text -

I figured out why it wasn't working. They were bound for some
reason... Access automatically binds a  checkbox when you put it on a
tab. That stinks.
ThomCarr - 11 May 2007 20:46 GMT
On May 4, 3:44 pm, Trepal...@gmail.com wrote:

> > <Trepal...@gmail.com> wrote in message
>
[quoted text clipped - 59 lines]
>
> - Show quoted text -

Are updating the table directly?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.