Copy form fields to related table

  • Thread starter Thread starter RcCypher
  • Start date Start date
R

RcCypher

I'm very new to access and I'm working with a database that is rather
beyond my own skill. However I have been tasked to find a way to
implement the solution that has been requested. So hopefully someone
will be able to save me from falling on my sword :)

The problem is basically this, I have a form in access that tracks
families, both parents and their kid, the addresses phone numbers
dates contacted etc.
Well occasionally we have to update phone numbers and addresses as
people move and get new phone plans etc. As such what they would like
me to do is find a way to automatically copy the updated fields from
the specific individual into a subform built to track the old
addresses and phone numbers. They would also like the subform to
automatically date itself based on the day the update was made. I
figure a macro would be the best approach to solve this problem
however I have 0 experience building Maco's in access. Can anyone
point me to good reference materials or perhaps recommend a simple
solution?
 
You should be able to do it with a simple append query.  Create a select
query based on your main form's recordsource.  Then turn that into an append
query.  I would probably add the datestamp as a general date/time to the
subform's recordsource.  Then all you need is a short macro
SetWarnings False
RunQuery "AppendQueryName"
SetWarnings True
Click to expand...

So I took your advise on this and have had great success. It took me a
while to figure out that I wasn't building a qry but a stored
procedure. But once I got past that point everything seemed to be
golden, until (I hate until's heh) I built the macro. Everything
works, I run the macro it adds the info the the table just like its
suppose to. However as soon as its done adding the data to the table.
I get an error message.

Action Failed
Macro Name:
z_address_update_master_form
Condition:
True
Action Name:
OpenStoredProcedure
Arguements:
child_address_update_procedure, Datasheet, Add
Error Number:
2950

Now I googled this error message and poked around on the web. The best
Microsoft can tell me is that its because the database is not in my
trusted locations. Well as best I can tell it is, the local copy is in
the folder located in my trusted locations, and the sql server copy is
added to my trusted locations on an admin share. So unless I am
overlooking something that is not the problem.

I've experimented with various arguments to see if that would resolve
the issue but I have had no luck with that fixing things.

Suggestions?
 
Back
Top