A problem I would have is converting the existing single entries table into the new table, with a relationsal field to the full gift table. Anywhere I could find out about writing a routine to do the conversion? I'm guessing it's a routine I need to write and do once.
Thank You
mdewell
Last Activity: Sep 21 '15, 01:27 PM
Joined: Aug 4 '15
Location:
-
I'm trying to explain to the client about linked tables, one to many relationships. Cross your fingers. I won't hear back for a while though. Sorry if I was driving anyone to say, "What's the point in using Access, when you can't use in a relational manner?" I just think the customer isn't that familiar, but has done a little work in Access, yet is using me for the final product work.Leave a comment:
-
To clarify a little better, each item added by a click would create a new entry in the main table, but the client wants all the same info to remain there in the parent form, as well as the list of items to add, before a final save of the record(s). Any idea of a way to do this? The big item is to have a subform to show the items being added, and then creating a new record in the main table after the save button is clicked.
Thanks.Leave a comment:
-
OK, now this is where it gets really weird, at least for my knowledge of Access, the client wants this subform for entry of multiple lines into the main table. So the process I was thinking was to have this temporary subform/table, and then copy the lines into the main table. I guess, perhaps my better option would be to somehow create a subform that only shows the matching ID entries for the primary keys. I believe I have the primary key in a...Leave a comment:
-
Hello jforbes,
I think I found what the error was. A variable was defined as an integer, when the field was a string in the DB table. I got that fixed. Plus a control name was not matching, but that's not a problem now.
Here's where things get a little funny. It added it to the table fine. Yet it doesn't seem to show it in the subform. It clears out the entry from displaying in the subform as soon as the query is run....Leave a comment:
-
Thank you jforbes,
This is some awesome looking code. I'm a little more an engineer than a coder, but maybe I can learn. There seem to be some typos in what you had, but that's easy to understand. I'm guessing you weren't copying and pasting from your own test code. It all seems to work OK, except for an error when trying to run the SQL statement. Here is an example of what the sSQL variable looks like when trying to run the SQL:...Leave a comment:
-
mdewell started a topic Access 2007 Subform acting as clipboard, not adding new row to subform tablein AccessAccess 2007 Subform acting as clipboard, not adding new row to subform table
I am using Access 2007. I have a form with fields that I want to copy to a subform. I nave an ADD button that can sopy the data to the subform, so the subform is acting as a clipboard. I can get it to add a row, but not add a new row to subform table after doing one entry into the subform.
Here is some code I have tried:
...Code:With Me.GiftListSubform .Form.SetFocus .Form![GiftQuantity].SetFocusLast edited by Rabbit; Aug 4 '15, 07:39 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: