Advertisement

1 - 10 of 48 containing alltags:("TableDefs") (0 seconds)
I try to write a sub thats do the following thing:(acc97) 1.Loops trough all the ATTACHED tables 2.If there is a field in a table called "periode" and the size of this field is 4 set it to 6 Here ...
Zones: MS AccessDate Answered: 10/16/1998 Grade: B Views: 0
hi,    can anybody tell me what is the concepts of the TABLEDEF and its complete sysntax ...     brac
Zones: ProgrammingDate Answered: 01/16/2003 Grade: A Views: 8
Hello, Thanks in advance for any help you can offer. I've got a table "dbo_coll".  In the properties from the design view the description reads "somelongdescription" I want to evaluate this d...
Zones: MS AccessDate Answered: 01/26/2004 Grade: A Views: 0
which property tells me if a table is linked or not? i.e. TableDefs(xx).Properties(???) thanks
Zones: MS AccessDate Answered: 10/31/2004 Grade: A Views: 25
I have a system consisting of FE and  BE databases with a number of linked tables.  I need to send out a locked up version of the system to various people who will fill out the information and send...
Zones: MS AccessDate Answered: 04/04/2005 Grade: A Views: 0
I'll like to hide / unhide all my table objects except tblSample1, tblSample2 and tblSample3 from another DB. How can I achieve this ?. I tried putting something together but couldnt quite comp...
Zones: MS AccessDate Answered: 05/17/2005 Grade: A Views: 0
Having a table name, say tMyTable, I need to audit the all fields'... 1. Name 2. Field Propety 3. Charters (if text) 4. DefaulValue 5. Input Mask 6. Format Also, table's creation date, m...
Zones: MS AccessDate Answered: 12/26/2005 Grade: A Views: 0
Hello, I am creating a lookup screen that will allow an end user to go in, select a table from the list box.  Then in the list box adjacent from the table listing, it will display the primary k...
Zones: MS AccessDate Answered: 05/03/2006 Grade: B Views: 0
When I try to run my updated from Access 2.0 database, it falls over at my TableDefs.Refresh / Delete lines with the error message "Object Variable or With Block Variable not set". Does anyone know...
Zones: MS AccessDate Answered: 03/17/2002 Grade: A Views: 0
What is the best way to copy a table from one (Access97)db into another using code (VB5)?? All fields, indexes, and properties thereof must be preserved. I can't help thinking this is easier than I...
Zones: VB DBDate Answered: 10/25/2000 Grade: B Views: 0