Name for this mdb file in VBA

[Guest]

Hello,
Using VBA and the advice received from a previous posting, I put the
following information into a table

For Each fld In tdf.Fields
.AddNew
!TableName = tdf.Name
!FieldName = fld.Name
.Update
Next

Now, I see that I also need to add the name of the current mdb file to the
list.
what would be the correct code to do this?

How would I complete the following line?...

!MDB_File_Name = ??????

thank you.

Keith

 

[Brendan Reynolds]

CurrentProject.Name if you want just the file name, or
CurrentProject.FullName if you want the full path and name.

 

[Guest]

CurrentDb.Name will return the full path and name of the mdb you are working
in.

 

[Guest]

Hi, Keith.

For just the file name, if you're using Access 2000 or newer, try:

!MDB_File_Name = CurrentProject.Name

For the full path and file name, try:

!MDB_File_Name = CurrentDb().Name

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Guest]

thank you

CurrentDb.Name will return the full path and name of the mdb you are working
in.

 

[Guest]

thank you.

Hi, Keith.

For just the file name, if you're using Access 2000 or newer, try:

!MDB_File_Name = CurrentProject.Name

For the full path and file name, try:

!MDB_File_Name = CurrentDb().Name

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Guest]

thank you

CurrentProject.Name if you want just the file name, or
CurrentProject.FullName if you want the full path and name.