And the place on the displayed subform where it shows up is on the most recent entry, not necessarily the entry that the check box should be linked to. If I checked the box on the 2006 entry, it shows up as 2008 on the displayed subform (not as 2006) - but when opening the dataentry subform it shows on 2006, 2007 and 2008.
AUGH!
SoNew
Last Activity: Sep 3 '08, 10:14 PM
Joined: Mar 13 '08
Location:
-
sorry for double posting - I figured that since I was taking a different route in trying to figure out how to do it I shouldn't tack on to my last posting. I will do differently in the future.
Thanks for your help on this. It worked well to bind to the query. However while it doesn't now stay checked for all the different records, it does for all the records of that one person. That is to say that if they have more than one placement...Leave a comment:
-
okay, I hope this is what you are looking for.
The qry it relates to is called qryList_Reading CoachPlacements
The field name in the table (called tblReadingCoach Placements) is blnMentor
The qry involves two tables: tblRadingCoachP lacements and tblElementarySi tes
The subform I am attempting to put this into is set to look up qryList_Reading CoachPlacements - and does indeed see all the other data...Leave a comment:
-
Control Source Issue?
I have updated a linked table in the backend to allow me to enter data into a new field (then updated the link in the front end just to be safe). I then went into the front end and updated the query that relates to it (adding the field to the query). Now I am trying to create a checkbox in the subform I am working in in the front end and having no luck. If I enter the data via the query it shows up - both on the subform and in the table, so it's... -
How do I know if it is bound to a query (I didn't create the original form) - I went to properties under the form and the record source field was blank (I had to put in the tblMentor to have a drop down list on the blnMentor button) - but originally it was blank.
Thoughts?Leave a comment:
-
Checkbox remains checked
I am trying to add a checkbox to a form and am having a rather basic problem. As you will quickly tell I am not an access person, but my boss seems to think so :)
Anyhow, I needed to add a field but couldn't add it to the original table as it is linked. So I created a new table just for the sake of tracking the data. (called Mentor). I created a primary key auto number (ingMentorID), the checkbox info (blnMentor) and (ReadingCoachID )... -
I have disabled the one on the form - it is the actual database close button on the main background page that is the problem (sorry for the lack of technical terms - I don't know access all that well).Leave a comment:
-
Closing Database Using Quit Button
I have designed a database and have used the following code to disable the standard Microsoft close button. I want my users to have to click on a Quit button on the switchboard:
[CODE=vb]Private Sub Form_Unload(Can cel As Integer)
Dim LResponse As Integer
LResponse = MsgBox("Please Use Quit Button on Main Menu", vbOKOnly)
If LResponse = vbOK Then
Cancel = True
End If
End... -
MOVING TO ACCESS VBA.
CLOSE ThreadLeave a comment:
-
Loading "First" Record In form
I have a Database form in Single View for users to look-up and/or enter data. When the form loads the combo box is empty, which I like - but the fields in the form are all filled in with what the database sees as the "first" record - which is alphabetically not the first, but is as to the ID field. All that said, I would like the fields to either fill in with the alphabetical first record, or merely blank. I found the code to have it load... -
Closing Database using a Quit Button
I have designed a database and have used the following code to disable the standard Microsoft close button. I want my users to have to click on a Quit button on the switchboard:
Private Sub Form_Unload(Can cel As Integer)
Dim LResponse As Integer
LResponse = MsgBox("Please Use Quit Button on Main Menu", vbOKOnly)
If LResponse = vbOK Then
Cancel = True
End If
End Sub... -
You are BRILLIANT! Thank you - works great!! :)Leave a comment:
-
Unlocking Lookup without Unlocking Form
To say I'm new is an understatement - but somehow my boss decided I was the one to create a database in Access 2003...I'm nearly there. I have a small problem in that I have locked the main form (although not yet the subform) using:
Then I have an Edit Button that folks can...Code:Private Sub Form_Current() If Me.NewRecord Then Me.AllowEdits = True Else Me.AllowEdits = False End If End Sub
No activity results to display
Leave a comment: