Reuben Cummings
accessd at gfconsultants.com
Wed Jan 6 11:03:16 CST 2010
The Back End Upgrader will do this. It will not do it from within a certain form. It will create the table as soon as the application opens. You can create a table. Add the two fields. Create the index. Create the relationship. Reuben Cummings GFC, LLC 812.523.1017 > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos > Sent: Tuesday, January 05, 2010 9:13 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Create A Table > > > What ever happened to th "Back End Updater" project? > > GK > > On Tue, Jan 5, 2010 at 7:12 PM, Rocky Smolin > <rockysmolin at bchacc.com> wrote: > > Dear List: > > > > I need to create a table in the back end, populate it with > a couple of > > fields, set the primary index, set one of the fields as the > FK to a PK in > > another table, and link the table to the front end. I need > to do this from > > code behind a form IN the front end. > > > > I could cobble this together from bits of stuff I have, > but, among all the > > Access sites that are out there, maybe someone knows of a > page with this > > very thing on it, or a close approximation. > > > > Yes? > > > > Or I could go on site to do this which would cost the user > an hour of my > > travel time but that might be cheaper than doing the code > unless there's > > something that I can put together quickly. (Also hate to go > out driving > > around if I can avoid it) > > > > MTIA, > > > > Rocky Smolin > > > > Beach Access Software > > > > 858-259-4334 > > > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > > > www.bchacc.com <http://www.bchacc.com/> > > > > > > > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > > > -- > Gary Kjos > garykjos at gmail.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >