Hello everyone,
I have a form-1 with a subform-B in it. When I try to add a new record it gives me an error that I cannot add record the joins key of table <name> not in result set. When I try to delete the record it does not delete the record from the subform-B. I checked the 1 to many relationship and the boxes for for the cascading delete and update are checked. If anyone can help me fix this it would be greatly appreciated.
...
rwest
Last Activity: Jan 11 '12, 04:03 PM
Joined: Dec 27 '11
Location:
-
Cascading Deletes and Updates
-
I did it as am embedded macro and went through the steps when I placed the button, I didn't write code for it. it opens the floods form Where "[floodid]=" & [floodid]. Do I need to write code for it? -
buttons that open forms
Hello
I created a floods sub form in my main publications form. In this sub form I created a button that opens another from called info connected with a specific flood id. When I click on the button in the subform for a flood id #1 the right data form opens, when I click the button for a different flood id it only opens the data form for flood id #1. If this makes sense to anyone and they can help me it would be greatly appreciated.
... -
Thanks! I knew it was something like that I just couldn't find the right event.Leave a comment:
-
Using a Check Box to make a Text Visible/Invisible
Hello
I have a form where there is a check box and it clicked new text is visible. The problem is when I add a new record that does not have the check box checked and then I filter through the rest of the records that do have it checked the text is no longer visible. below is the code that I have. Thanks for the help.
...Code:If Me.Check117 Then Me.duration.Visible = True Me.txthrs.Visible = True Me.eventdateend.Enabled
-
Filtering dates
Hello everyone,
I have a form that is connected to a table called floods that has a date column as mm/dd/yyyy. I want to filter my form but only by the year. When I try to filter it nothing happens, i don't even get an error. Below is the code if anyone could help in this matter it would be greatly appreciated.
Thanks
...Code:Me.FindYear = IIf(IsDate(Me.FindYear), _ Format(Me.FindYear, -
Filtering forms by date
Hello everyone,
I was wondering if it is possible to filter a form in access by date when the populated field on the form is the date (i.e. dd/mm/yyyy).If this is possible I was wondering what the code for doing this might look like.
Thanks -
Filtering Forms
I have a form connected to a table called floods. On this form I want to filter the records by date, municipality, and drainageway.the date comes from the floods table but the municipality and the drainageway are both subforms connected to the tables municipalities and drainageways respectively.I have tried to come up with the codes for these filters but nothings is working right.part of my code is below. Any help with this would be greatly appreciated.... -
Would you have an example of the SQL code? The main form's record source is from a table called customers and I want the sub form's record source to be from the tables orders and types. I have a connection between customers and orders, and between orders and types but not between customers and orders. This is why I want 2 record sources for the subform of orders and types. If there is another way I can do this that would be great too.Leave a comment:
-
Multiple Record Sources for a form
I was wondering if it is possible to have multiple record sources for a form without creating queries, and if so how do I go about doing that.
Thanks
No activity results to display
Leave a comment: