Brilliant, thanks Toby. That's worked perfectly. Thanks Jane
--- In [email protected], "Toby Bierly" <[EMAIL PROTECTED]> wrote: > I think you want to edit the DefaultValue property of the TableDef instead > of creating a new property. > > For example: > > tdfTable.Fields!FieldName.DefaultValue = "EnterValueHere" > > OR > > tdfField.DefaultValue = "EnterValueHere" > > > HTH, > Toby > > ----- Original Message ----- > From: "vjcross2004" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, September 22, 2005 9:39 AM > Subject: [AccessDevelopers] Re: Modify table in backend with code? > > > > Thanks for your advice. Network admin won't even give me a network > > login username when I'm on site - so I can't imagine they would let > > me use PCanywhere etc! > > > > I tried to do this years ago, on a old, old version of access & at > > the time there was no way of doing it - Access didn't have the > > capability. As you suggest I've got the 'modify' code in a temporary > > database, which someone can run for me on site. I've now tried with > > table defs again & have persisted & have now managed to get the > > correct syntax & have sucessfully added new fields to remote tables. > > So I'm happy. > > But, I'm now trying to change some of the properties of the new > > field, eg I want to set the default value. This is what I've tried. > > It creates the new field OK, but doesn't set the default value. > > > > Set dbsUpdate = wrkDefault.OpenDatabase(linkpath, True) > > Set tdfUpdate = dbsUpdate.TableDefs(TableName) > > With tdfUpdate > > Set tdfField = .CreateField(fieldname, dbBoolean) > > tdfField.Properties.Append tdfField.CreateProperty("Default", > > dbText, "False") ' This line does nothing > > .Fields.Append tdfField > > End With > > > > Does anyone have a suggestions? > > Jane > > > > --- In [email protected], "Databasedude.com" > > <[EMAIL PROTECTED]> wrote: > > > Have you ruled out remote connection to their system using > > GoToMyPC, > > > pcAnywhere, or other such services? That would let you have the > > > necessary hands-on. > > > > > > Aside from that, here's an idea I've used successfully several > > times > > > with remote clients: Create a temporary MDB that someone at the > > client > > > will execute, and then discard. > > > > > > This MDB would contain code to add the field to the table ... > > refer to > > > DAO tabledefs etc for instructions in VBA. > > > > > > Once you've tested to make sure it works on a copy of their back- > > end, > > > then submit it to your main contact person, ask them to run it for > > you > > > (preferably with everyone out of the data), and problem solved. > > > > > > HTH > > > Bryant > > > > > > --- In [email protected], "vjcross2004" > > <[EMAIL PROTECTED]> > > > wrote: > > > > Thanks for that, but I don't know of anyway of 'putting' > > anything > > > > into the backend to run, unless anyone has any suggestions. > > > > I am trying to avoid visiting the client (2 hrs travelling) for > > a 2 > > > > minute job. > > > > Thanks > > > > Jane > > > > > > > > --- In [email protected], [EMAIL PROTECTED] wrote: > > > > > I would personally use SQL ALTER TABLE statement. > > > > > > > > > > ALTER TABLE tblName ADD TextField VARCHAR(30); 'to add a 30 > > > > character text > > > > > field called TextField to table tblName. > > > > > > > > > > My guess is you must run this in the back end. Google ALTER > > TABLE > > > > and check > > > > > syntax for other data types and keys and indexes if necessary > > > > > > > > > > Hal McGee > > > > > Engineering Data Manager > > > > > Group Engineering - Process and Compliance > > > > > Seating Products Group > > > > > B/E Aerospace > > > > > Winston-Salem, NC > > > > > > > > > > > > > > > > > > > > > > > > > > > > "vjcross2004" > > > > > > > > > > > > > <[EMAIL PROTECTED] > > > > > > > > > ucts.plus.com> To > > > > > Sent by: > > > > [email protected] > > > > > > > > > AccessDevelopers@ cc > > > > > > > > > yahoogroups.com > > > > > > > > > > > Subject > > > > > [AccessDevelopers] > > Modify > > > > table in > > > > > 09/22/2005 07:33 backend with > > > > code? > > > > > > > > > AM > > > > > > > > > > > > > > > > > > > > > > > > > > > Please respond > > > > to > > > > > > > > > AccessDevelopers@ > > > > > > > > > yahoogroups.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I have a database split as FE/BE at a clients office. I need > > to > > > > add a > > > > > new field to one of the tables in the backend, using code > > which > > > > will > > > > > run once when the FE is first opened. I can use TableDefs OK > > to > > > > modify > > > > > tables within the existing FE, but not those linked from the > > BE. > > > > This > > > > > is a one time only event & all the users can be forced out of > > the > > > > > database before the change happens. > > > > > > > > > > Does anyone have any suggestions as to how to do it? > > > > > Thanks > > > > > Jane > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > > > > > > YAHOO! GROUPS LINKS > > > > > > > > > > Visit your group "AccessDevelopers" on the web. > > > > > > > > > > To unsubscribe from this group, send an email to: > > > > > [EMAIL PROTECTED] > > > > > > > > > > Your use of Yahoo! Groups is subject to the Yahoo! > > Terms of > > > > Service. > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > Yahoo! Groups Links > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
