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 ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10089412.html
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
http://www.experts-exchange.com/Programming/Misc/Q_20446446.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20861326.html
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
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21189502.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21372241.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21425320.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21675239.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21811662.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10110627.html
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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_11631139.html
Zones:
VB DBDate Answered: 10/25/2000 Grade: B Views: 0