If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
add table field
Hi:
Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard |
#2
|
|||
|
|||
add table field
|
#3
|
|||
|
|||
add table field
On Feb 8, 6:31 pm, "Rick Brandt" wrote:
wrote: Hi: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard Your code would have to first open the back end database where the table resides and then it would use code to modify the table in that file. Nothing can be done via the link. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick: But can I open the back-end Db table from the front end Db? I think I heard that this is do-able, but I don't know how. Richard |
#4
|
|||
|
|||
add table field
Richard,
To open up the backend database, look up the OpenDatabase Method in the help file. To add a field to a table, look up the TableDef Object in the help file. Good luck. -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005 Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org MS Colorado Events Administrator www.MSColoradoEvents.com This email made with 100% recycled electrons! Miscellaneous Access "stuff" at www.ScoBiz.com wrote in message ... On Feb 8, 6:31 pm, "Rick Brandt" wrote: wrote: Hi: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard Your code would have to first open the back end database where the table resides and then it would use code to modify the table in that file. Nothing can be done via the link. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick: But can I open the back-end Db table from the front end Db? I think I heard that this is do-able, but I don't know how. Richard |
#5
|
|||
|
|||
add table field
Good to see your name again Sco!
-- Duane Hookom Microsoft Access MVP "M.L. Sco Scofield" wrote: Richard, To open up the backend database, look up the OpenDatabase Method in the help file. To add a field to a table, look up the TableDef Object in the help file. Good luck. -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005 Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org MS Colorado Events Administrator www.MSColoradoEvents.com This email made with 100% recycled electrons! Miscellaneous Access "stuff" at www.ScoBiz.com wrote in message ... On Feb 8, 6:31 pm, "Rick Brandt" wrote: wrote: Hi: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard Your code would have to first open the back end database where the table resides and then it would use code to modify the table in that file. Nothing can be done via the link. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick: But can I open the back-end Db table from the front end Db? I think I heard that this is do-able, but I don't know how. Richard |
#6
|
|||
|
|||
add table field
Good to been seen Duane. :-)
Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005 Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org MS Colorado Events Administrator www.MSColoradoEvents.com This email made with 100% recycled electrons! Miscellaneous Access "stuff" at www.ScoBiz.com "Duane Hookom" wrote in message ... Good to see your name again Sco! -- Duane Hookom Microsoft Access MVP "M.L. Sco Scofield" wrote: Richard, To open up the backend database, look up the OpenDatabase Method in the help file. To add a field to a table, look up the TableDef Object in the help file. Good luck. -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005 Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org MS Colorado Events Administrator www.MSColoradoEvents.com This email made with 100% recycled electrons! Miscellaneous Access "stuff" at www.ScoBiz.com wrote in message ... On Feb 8, 6:31 pm, "Rick Brandt" wrote: wrote: Hi: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard Your code would have to first open the back end database where the table resides and then it would use code to modify the table in that file. Nothing can be done via the link. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick: But can I open the back-end Db table from the front end Db? I think I heard that this is do-able, but I don't know how. Richard |
#7
|
|||
|
|||
add table field
I see you too
"M.L. Sco Scofield" Sco at ScoBiz dot com wrote in message ... Good to been seen Duane. :-) Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005 Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org MS Colorado Events Administrator www.MSColoradoEvents.com This email made with 100% recycled electrons! Miscellaneous Access "stuff" at www.ScoBiz.com "Duane Hookom" wrote in message ... Good to see your name again Sco! -- Duane Hookom Microsoft Access MVP "M.L. Sco Scofield" wrote: Richard, To open up the backend database, look up the OpenDatabase Method in the help file. To add a field to a table, look up the TableDef Object in the help file. Good luck. -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005 Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org MS Colorado Events Administrator www.MSColoradoEvents.com This email made with 100% recycled electrons! Miscellaneous Access "stuff" at www.ScoBiz.com wrote in message ... On Feb 8, 6:31 pm, "Rick Brandt" wrote: wrote: Hi: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard Your code would have to first open the back end database where the table resides and then it would use code to modify the table in that file. Nothing can be done via the link. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick: But can I open the back-end Db table from the front end Db? I think I heard that this is do-able, but I don't know how. Richard |
#8
|
|||
|
|||
add table field
The fact that you have a need to add a column to a back end table "on the
fly" leads me to believe that you have a spreadsheet that you are calling a table. Under what conditions do you need to add a new column? wrote in message ... On Feb 8, 6:31 pm, "Rick Brandt" wrote: wrote: Hi: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard Your code would have to first open the back end database where the table resides and then it would use code to modify the table in that file. Nothing can be done via the link. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick: But can I open the back-end Db table from the front end Db? I think I heard that this is do-able, but I don't know how. Richard |
Thread Tools | |
Display Modes | |
|
|