Search results

what i meant is for this one its not clear. was that complete already? End If

well people have different perceptions. anyway maybe you have also made it clear to me when you said that when you read post #20 and you could not continue on due to your concentration level. well probably I wont continue on this comment because doing so might just fall into a loop.

i would prefer #2

simply answered by georgewilkinson

just to mention: was tmp and i variable properly set?

i think its the field types there. for example there is no smallint field type in access. I think you should familiarize yourself first with table field types.

cant you use these code (see attached database) to locate the database?

Rabbie, that portion that you stated: "Sometimes there are a several questions to be answered and guess which ones I will try to answer first. Those where the problem is clearly described or those where it takes several minutes to work out what the the questioner actually is asking" This is...

ok. I worked it out. ok tnx for assisting

thanks every one for your assistance. I have modified your codes and come up with my own and here it is and I want to share this to you: '----------------------------------------- Dim tdf As DAO.TableDef For Each tdf In CurrentDb.TableDefs If Left(tdf.Name, 4) <> "MSys" _ And...

I have this database and it has local and linked tables. what I want to do is to decipher thru vba what table types are " linked " and by that criteria, loop thru those objects and delete them.

I think you terming the tables linked to each other as linked table, while I think what you are seeing is link relationship of tables. You should differentiate that. I think what you want to say is you want to view the records from table 2 of database2 that is linked in table 1 of database1...

thanks for the reply Dave but I have seen relinker of several sites but it was not enough for my project though I just studied their code. DCrake the purpose of several backends is because I am foreseeing the each database file to get big and for the purposes of replicating the data to other...

I think it is still upon the individual who will reply if he wanted or not to reply regardless of what rules to be follow to get a reply or assistance. You just cannot force them to answers. There are many post headers that are still not following the convention set on this post but still...

is this forum useless?

anyone care to assist me please?

Dim db As Database Dim Tbl As TableDef Dim TblNames As String Dim TblCount As Integer Set db = CurrentDb TblCount = 0 For Each Tbl In db.TableDefs If Tbl.Attributes = 0 Then 'Ignores System Tables TblNames = Tbl.Name End If Next Tbl ---------------------------------------- Now with the...

Dim db As Database Dim Tbl As TableDef Dim TblNames As String Dim TblCount As Integer Set db = CurrentDb TblCount = 0 For Each Tbl In db.TableDefs If Tbl.Attributes = 0 Then 'Ignores System Tables TblNames = Tbl.Name MsgBox TblNames End If Next Tbl...

Private Sub Command0_Click() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData ' Check each object of the AllTables collection For Each obj In dbs.AllTables ' When you find a table, display its name MsgBox obj.Name Next obj End Sub...

up for this post please.