Glad to know it helped. It was far from perfect as I found
out when I re-read your FMPAF Form info.
I have made quite a few changes including setting up
Relationships but they are probably incorrect. I won't
upload it unless you want to see what I've changed. Let
If you can, let me know what the structure is, either as
Relationships or in a Data Flow Diagram.
--- In MS_Access_Professionals@yahoogroups.com
> Hey Clive,
> I've taken a good look at the coding and methods you've used and
> pretty sure I can now apply it to the real database. I goofed up
> sample I gave you by not making it exactly like the real one, but
> sure I can work around the misconceptions I gave you.
> It taught me a lesson. Next time I make a sample dB, I'll use more
> care to make it exactly as the real dB is.
> The primary difference is that I didn't make it clear to you that
> account numbers are what contain the money. The vendors purchase
> *from* the accounts. So the relationship between the vendors to
> is a one to many, with the accts being the many.
> I'll adapt your code to this if I can.
> Thanks again, and if I get stuck, I'll post a question.
> --- In MS_Access_Professionals@yahoogroups.com, "horastacatto"
> <zctek@> wrote:
> > Hi Tony,
> > Sorry to have taken so long to get back to you with
> > an updated version of your DB. It is in the Group Files
> > as FMPAF_Fixed.zip.
> > It is not perfect yet(what is) but it should give you
> > enough to get you going.
> > I have included a form that opens when you start the DB
> > with a list of comments and questions. You will no doubt
> > have some more questions for me.
> > I would appreciate your feedback when you have had time to
> > look at it.
> > Regards, Clive.