instructor
Last Activity: Jan 27 '15, 07:36 PM
Joined: Dec 26 '14
Location:
-
Yes, all tables are appropriately related. -
MS Access Passing Data in Forms
I have an Access database where I am trying to use a form with subforms. There are 3 tables linked to one another. After I have created the form with the two subforms, everything works fine (all data is correctly showing in all forms). However, when I go back to the main form to locate a record to update, the subforms don't bring up any data. The subforms are blank. Why does it work when first opened (all forms are correct), but when searching for... -
I went to another computer and the Navigation Pane worked fine. So, it seems to be only in my computer's copy of Access. I have checked the File, Options but don't see where I would have made a change that would cause this. However, since I have never seen this before, I could have missed something.Leave a comment:
-
No. No code that references the navigation pane. I sized it down and then it just froze. The rest of the application works fine.Leave a comment:
-
Thank you! That accomplished what I wanted.Leave a comment:
-
Navigation Pane In Access Frozen
The Navigation Pane in Access has frozen providing me with very little showing. No matter what I do, I cannot enlarge the pane. Any ideas? Thanks. -
That did it! Thank you.Leave a comment:
-
Passing data from one record to a control in a new record
I have a subform that I would like to pass the contents of one control to a new record. I tried:
...Code:Private Sub form_Afterupdate() Dim ctl as Control For Each ctl in Screen.ActiveForm.Controls If ctl.Tag = "Carry" Then Ctl.DefaultValue = """" & ctl.Value & """" End If Next End subLast edited by Rabbit; Dec 27 '14, 01:20 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: