Help -- Schema.Ini file format 
Author Message
 Help -- Schema.Ini file format
What is the format for the schema.ini file used to import text files into
an Access database?  It isn't in the Access help file, the VB6 help file,
nor in any of the Access and VB3-6 books I have.

As I vaguely remember, it is something like:

[Filename]
field1 info
field2 info
etc.

[Filename2]
stuff

But I forget what the field info needs to look like.

TIA,
Randy Gritton
--




Mon, 23 Apr 2001 03:00:00 GMT
 Help -- Schema.Ini file format

Hello to all,
I have a form that contains datafields being updated with Data Field and Data
Source properties.  Is there a way I can have a frame with several option
radio buttons which will reflect changes in a field?  I have a field that can
contain one of four text choices.  How can I have these buttons show the
contents of the database field? When the database field contains ABCD the
first button will get checked, when the database field contains EFGH the
second button will get checked etc.

Thanks for your time,
Evan Panagiotopoulos

  evanp.vcf
< 1K Download


Wed, 25 Apr 2001 03:00:00 GMT
 Help -- Schema.Ini file format

First, make sure you paste the option buttons *into* the frame.  This
is what makes them an option group.  Next, test the value of your
field for each of the 4 possibilities.  When you've found one, set the
frame's Value property to the number corresponding to the appropriate
option button.  This will be one-based, not zero-based.  Thus, you can
set the frame to either 1, 2, 3, or 4.  This should automatically set
the appropriate option button.

Dim rst as Recordset
Dim strValue as String

rst = CurrentDb.OpenTableDef("your table here")

strValue = rst.Fields("name of your field here")

If strValue = "ABCD" then
   fraFrameName = 1
ElseIf strValue = "EFGH" then
   fraFrameName = 2
ElseIf strValue =  ...
   ...
End If

Jim

 >This is a multi-part message in MIME format.
 >--------------E4EAAC3824AC50F967C047DA
 >Content-Type: text/plain; charset=us-ascii
 >Content-Transfer-Encoding: 7bit

 >Hello to all,
 >I have a form that contains datafields being updated with Data Field
and Data
 >Source properties.  Is there a way I can have a frame with several
option
 >radio buttons which will reflect changes in a field?  I have a field
that can
 >contain one of four text choices.  How can I have these buttons show
the
 >contents of the database field? When the database field contains
ABCD the
 >first button will get checked, when the database field contains EFGH
the
 >second button will get checked etc.

 >Thanks for your time,
 >Evan Panagiotopoulos

 >--------------E4EAAC3824AC50F967C047DA
 >Content-Type: text/x-vcard; charset=us-ascii;
 > name="evanp.vcf"
 >Content-Transfer-Encoding: 7bit
 >Content-Description: Card for Evan Panagiotopoulos
 >Content-Disposition: attachment;
 > filename="evanp.vcf"

 >begin:vcard
 >n:Panagiotopoulos;Evan
 >tel;fax:(914) 457-4056
 >tel;home:Home Sweet Home
 >tel;work:Valley Central High School (914) 457-3122
 >x-mozilla-html:TRUE
 >org:Valley Central High School;Mathematics
 >adr:;;;;;;
 >version:2.1

 >title:Computer Teacher
 >fn:Display Name
 >end:vcard

 >--------------E4EAAC3824AC50F967C047DA--

__________________________________________________________

           Need a laugh?  Try NetScrap.com ...

                It's not just the Stuff
     It's the Things that keep bringing you back.

To reply by mail, remove "spamstop." in my email address.



Sat, 28 Apr 2001 03:00:00 GMT
 Help -- Schema.Ini file format

Quote:

> Is there a way I can have a frame with several option
> radio buttons which will reflect changes in a field?  I have a field
> that can
> contain one of four text choices.  How can I have these buttons show
> the
> contents of the database field?

Hi.

The easiest way to do this would (VB5) be to make your textbox
invisible, and place something like the following code in the
textbox.change sub:

Select Case textbox
Case "ABCD"
        opt1(0)=true
Case "EFGH"
        opt1(1)=true
etc.
etc.

Similarly, in the optionbox sub, update the textbox value.
I.e. If opt1(0) then textbox="ABCD"
etc.

As another, general, note, I always recommend people who use the
DBcontrol, the minute they run into this type of problems, to start
using the direct database objects instead. This way, you can manipulate
the database data and the user data completely independently, YOU are in
control, and can add all sorts of validation, formatting etc.
Look in help for Database, Recordset, Table.

HTH,
Morten.
--

.sig
.disclaimer



Fri, 27 Apr 2001 03:00:00 GMT
 Help -- Schema.Ini file format

First, make sure you paste the option buttons *into* the frame.  This
is what makes them an option group.  Next, test the value of your
field for each of the 4 possibilities.  When you've found one, set the
frame's Value property to the number corresponding to the appropriate
option button.  This will be one-based, not zero-based.  Thus, you can
set the frame to either 1, 2, 3, or 4.  This should automatically set
the appropriate option button.

Dim rst as Recordset
Dim strValue as String

rst = CurrentDb.OpenTableDef("your table here")

strValue = rst.Fields("name of your field here")

If strValue = "ABCD" then
   fraFrameName = 1
ElseIf strValue = "EFGH" then
   fraFrameName = 2
ElseIf strValue =  ...
   ...
End If

Jim

 >This is a multi-part message in MIME format.
 >--------------E4EAAC3824AC50F967C047DA
 >Content-Type: text/plain; charset=us-ascii
 >Content-Transfer-Encoding: 7bit

 >Hello to all,
 >I have a form that contains datafields being updated with Data Field
and Data
 >Source properties.  Is there a way I can have a frame with several
option
 >radio buttons which will reflect changes in a field?  I have a field
that can
 >contain one of four text choices.  How can I have these buttons show
the
 >contents of the database field? When the database field contains
ABCD the
 >first button will get checked, when the database field contains EFGH
the
 >second button will get checked etc.

 >Thanks for your time,
 >Evan Panagiotopoulos

 >--------------E4EAAC3824AC50F967C047DA
 >Content-Type: text/x-vcard; charset=us-ascii;
 > name="evanp.vcf"
 >Content-Transfer-Encoding: 7bit
 >Content-Description: Card for Evan Panagiotopoulos
 >Content-Disposition: attachment;
 > filename="evanp.vcf"

 >begin:vcard
 >n:Panagiotopoulos;Evan
 >tel;fax:(914) 457-4056
 >tel;home:Home Sweet Home
 >tel;work:Valley Central High School (914) 457-3122
 >x-mozilla-html:TRUE
 >org:Valley Central High School;Mathematics
 >adr:;;;;;;
 >version:2.1

 >title:Computer Teacher
 >fn:Display Name
 >end:vcard

 >--------------E4EAAC3824AC50F967C047DA--

__________________________________________________________

           Need a laugh?  Try NetScrap.com ...

                It's not just the Stuff
     It's the Things that keep bringing you back.

To reply by mail, remove "spamstop." in my email address.



Sat, 28 Apr 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Schema.ini file date formats

2. Help! with Schema.ini file and ODBC text

3. Format definition in schema.ini

4. Where to put the Schema.ini File

5. ADO, Text Files and that damned Schema.ini

6. SCHEMA.INI Must I use this file name???

7. Schema.ini With Adhoc ODBC Text File Connections

8. Text File Databases/Schema.ini Limitation

9. schema.ini file location

10. How to ignore a column in Schema.ini file

11. Importing Text Files with Schema.ini and Execute SQL Missing first Record

12. Schema.ini File


 
Powered by phpBB® Forum Software