[AccessD] Create A Table

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
> 







More information about the AccessD mailing list