Connecting Tech Pros Worldwide Forums | Help | Site Map

using VB to rename a field...

Wendell Cochran
Guest
 
Posts: n/a
#1: Nov 12 '05
when i import .dbf files, access truncates the file names.

i need to restore the names to the originals (i do this repeatedly, so i
need a routine to automate).

am currently using Access97

thank you for any help.

wendell cochran



Douglas J. Steele
Guest
 
Posts: n/a
#2: Nov 12 '05

re: using VB to rename a field...


CurrentDb().TableDefs("MyTable").Fields("MyField") .Name = "NewFieldName"



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Wendell Cochran" <wendell.cochran2@verizon.net> wrote in message
news:dLIvb.5434$b91.4162@nwrddc01.gnilink.net...[color=blue]
> when i import .dbf files, access truncates the file names.
>
> i need to restore the names to the originals (i do this repeatedly, so i
> need a routine to automate).
>
> am currently using Access97
>
> thank you for any help.
>
> wendell cochran
>
>[/color]


Wendell Cochran
Guest
 
Posts: n/a
#3: Nov 12 '05

re: using VB to rename a field...


thank you


"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:k%Ivb.697$B04.264@twister01.bloor.is.net.cabl e.rogers.com...[color=blue]
> CurrentDb().TableDefs("MyTable").Fields("MyField") .Name = "NewFieldName"
>
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "Wendell Cochran" <wendell.cochran2@verizon.net> wrote in message
> news:dLIvb.5434$b91.4162@nwrddc01.gnilink.net...[color=green]
> > when i import .dbf files, access truncates the file names.
> >
> > i need to restore the names to the originals (i do this repeatedly, so i
> > need a routine to automate).
> >
> > am currently using Access97
> >
> > thank you for any help.
> >
> > wendell cochran
> >
> >[/color]
>
>[/color]


Closed Thread